Can't connect with non-root user to created database

[Clemens Eisserer]

Hi,

I try to create a non-root-user, and allow it to access a newly created database - running mysql-5.5 on Fedora16:

CREATE USER Some_User IDENTIFIED BY 'Some_Password';
CREATE DATABASE Some_Database;
GRANT ALL ON Some_Database.* TO 'Some_User' IDENTIFIED BY 'Some_Password';
FLUSH PRIVILEGES;

However, when I try to log in to Some_Database using Some_User, I always get:

mysql -h127.0.0.1 --user=Some_User -p Some_Database
Enter password:
ERROR 1045 (28000): Access denied for user 'Some_User'@'localhost' (using password: YES)

Any idea whats going wrong here?
Omitting the -h parameter doesn't help unfourtunatly :/

Thanks in advance, Clemens



Edited 1 time(s). Last edit at 03/15/2012 11:49AM by Clemens Eisserer.