MySQL Forums
Forum List  »  Newbie

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'xyz'
Posted by: Dusty Maus
Date: January 29, 2012 02:42PM

I installed MySQL 5.5, logged in as root, created a new database

CREATE DATABASE hgkwin;

then created a new user

CREATE USER 'jutta';

and added all privs to her:

grant all privileges on hgkwin.* to 'jutta';

I checked it:

mysql> show grants for 'jutta';
+---------------------------------------------------+
| Grants for jutta@% |
+---------------------------------------------------+
| GRANT USAGE ON *.* TO 'jutta'@'%' |
| GRANT ALL PRIVILEGES ON `hgkwin`.* TO 'jutta'@'%' |
+---------------------------------------------------+
2 rows in set (0.00 sec)

and logged in as jutta:

mysql -u jutta

Unfortunately I can't access the db:

mysql> use hgkwin
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'hgkwin'

I checked my rights as jutta:

mysql> show grants for current_user;
+--------------------------------------+
| Grants for @localhost |
+--------------------------------------+
| GRANT USAGE ON *.* TO ''@'localhost' |
+--------------------------------------+

but no way to reach my database 'hgkwin'.

What's wrong???

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.