473,883 Members | 1,649 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ERROR 1044 and 1045

Hi all,

I have a curious problem with the ERROR 1044 and 1045:

-system: OS X 10.4.3 (bash shell)
-bash schell prompt: /~ kssun$
-I have set passwd to 'kssun'
-I set path: PATH=${PATH}:/usr/local/mysql/bin

- symptom 1
when I type mysql (without passwd), I enter mysql prog with following
greeting msg:
---------------------------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 56 to server version: 5.0.17-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
---------------------------------------------------------------------------------------------------

But when I try to create database, I get ERROR 1044:
----------------------------------
mysql> create database hi;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'hi'
---------------------------------

for information:
-------------------------------------------
mysql> select user();
+-----------------+
| user() |
+-----------------+
| kssun@localhost |
+-----------------+
1 row in set (0.00 sec)
------------------------------------------------------

-Symptom 2
I try then to login with -u option, here are the results:

(1) login as kssun w/o passwd
successed as like login w/o user name, ERROR 1044 for create database,
select user() show kssun@localhost

(2) login as kssun with passwd
failed, ERROR 1045, however I typed the passwd that I set for bash
shell
-------------------------------------------------------------------
ras75-3-82-226-221-2:~ kssun$ mysql -u kssun -p
Enter password:
ERROR 1045 (28000): Access denied for user 'kssun'@'localh ost' (using
password: YES)
---------------------------------------------------------------

(3) login as root (w/o passwd)
successed to create dababase without any difficulty and user become:
----------------------------------
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+

Would someone have un idea of this mysterious situation?

Thanks for whom read this article.

ks

Dec 29 '05 #1
2 9464
You have an anonymous user installed. If you login as root with the correct
password, you can query your users with

select Host, User, Password from mysql.user;

here you'll see a user without a name (that's the anonymous user that will
be used if no other user account applies to the specified host, user and
password).

You can (and likely should) delete this anonymous user with

delete from mysql.user where User = '';
flush privileges;

Markus
Dec 29 '05 #2
When you want to find out who you are logged in as, do a :

select current_user();

The 'select user()' statement shows you the username and hostname you
are connected as, but this doesn't tell you much about how it maps to
the user privilege tables. The 'current_user() ' function will tell you
the privilege entry that is being used to authenticate you.

For anonymous users, the userid portion will be blank.

Chances are, if you do a 'select current_user()' , when you connect
you're connecting as an anonymous user (did you create a database user,
or are you trying to log in as an OS user?)

As the anonymous user (on a default installation) you'll be able to
connect to the server and perform operations on the 'test' and 'test_%'
databases (where '%' is any string).

When you connect as 'root', you are connecting as the default database
administrator - where no password is set by default - hence you have
administrative privileges.

You can use the 'CREATE USER' statement to create a new user - which
you can then use to manage the database. Check out the MySQL
documentation for more info on this command .

You can use the 'SET PASSWORD' statement to set a password for the
'root' user (since right now anyone that can log on locally to your
system can gain administrative privileges).

Once you set a password for the 'root' user, you will no longer be able
to connect without a password.

If you want to get rid of the anonymous users, just issue the following
statements:

delete from mysql.user where user='';
delete from mysql.db where user='';
flush privileges;

Once you do that you'll no longer be able to connect to the server
anonymously.

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
MySQL training from the experts.

arsisthesis wrote:
Hi all,

I have a curious problem with the ERROR 1044 and 1045:

-system: OS X 10.4.3 (bash shell)
-bash schell prompt: /~ kssun$
-I have set passwd to 'kssun'
-I set path: PATH=${PATH}:/usr/local/mysql/bin

- symptom 1
when I type mysql (without passwd), I enter mysql prog with following
greeting msg:
---------------------------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 56 to server version: 5.0.17-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
---------------------------------------------------------------------------------------------------

But when I try to create database, I get ERROR 1044:
----------------------------------
mysql> create database hi;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'hi'
---------------------------------

for information:
-------------------------------------------
mysql> select user();
+-----------------+
| user() |
+-----------------+
| kssun@localhost |
+-----------------+
1 row in set (0.00 sec)
------------------------------------------------------

-Symptom 2
I try then to login with -u option, here are the results:

(1) login as kssun w/o passwd
successed as like login w/o user name, ERROR 1044 for create database,
select user() show kssun@localhost

(2) login as kssun with passwd
failed, ERROR 1045, however I typed the passwd that I set for bash
shell
-------------------------------------------------------------------
ras75-3-82-226-221-2:~ kssun$ mysql -u kssun -p
Enter password:
ERROR 1045 (28000): Access denied for user 'kssun'@'localh ost' (using
password: YES)
---------------------------------------------------------------

(3) login as root (w/o passwd)
successed to create dababase without any difficulty and user become:
----------------------------------
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+

Would someone have un idea of this mysterious situation?

Thanks for whom read this article.

ks


Dec 30 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4597
by: Morten Gulbrandsen | last post by:
Hi programmers, Good morning ;-) I think something is wrong, Running windows I believe first I have to set some password, Which creates some user, Then I can grant the required privileges, for some databases. However granting privileges after setting password seems to reset some Other access,
0
1193
by: Morten Gulbrandsen | last post by:
C:\mysql\bin>mysql -u elmasri -pnavathe company Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 4.1.0-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select database(); +------------+ | database() | +------------+
8
18474
by: John | last post by:
Hello. I am currently working through a book on Dreamweaver and using PHP. I am having a little trouble with setting up the database though. I have php 4.2.3 and MySQL 4.0.20a. I am running locally with Apache 1.3.27 on Windows XP Pro. I seem to have finally got MySQL running after a lot of difficulty. In the book it says to type source C:\mysql\newland_tours.sql at the mysql> prompt, to generate the newland_tours database in my...
3
4157
by: dstewart | last post by:
Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in rinetd, the error message is: ERROR 2013: Lost connection to MySQL server during query Using the exact same query from prompt on several clients (some are SuSE 9.1, some are older Redhat systems, but none are configured
13
6628
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
3
22580
by: Greg Noss | last post by:
I'm trying to install MySQL. During the security settings portion fo the setup. I keep getting a Connection Error. Error Nr. 1045 Access denied for user'root'@'localhost'(using password:YES) ........ I had Zonealarm running. Changed the trusted zone security setting to low(disabled) then selected "retry" Failed again.
0
1336
by: baghath | last post by:
I am using linux server in virtually(putty). that server have a mysql. I got the error (ERROR 1045) in when i type mysql time.i need ur help for how to rectify the error in command mode. Regards Baghathsingh.R
1
3204
by: ajd335 | last post by:
Hi all... I am working with PHP and mysql. I have one form from which i am importing data into the table. Now i want "email " field result into a text file I am using code select email from table_1 into outfile '/location/result.txt';
7
6055
by: samalphins | last post by:
I have very strange error mysqldump: Got error: 1045: Access denied for user ''@'localhost' (using p assword: YES) when trying to connect I have installed mysql freshly with blank password for user "root" when I am trying perform backup with mysqldump I am getting the strange error I am trying with the folowing command d:\xampp\mysql\bin\mysqldump -u -p
0
9932
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11112
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10833
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10405
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7959
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5784
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4602
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4205
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3228
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.