MySQL Forums
Forum List  »  Newbie

Can't connect with non-root user to created database
Posted by: Clemens Eisserer
Date: March 15, 2012 11:49AM


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';
GRANT ALL ON Some_Database.* TO 'Some_User' IDENTIFIED BY 'Some_Password';

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.

Options: ReplyQuote

Written By
Can't connect with non-root user to created database
March 15, 2012 11:49AM
March 16, 2012 12:28AM

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.