Skip navigation links

MySQL Forums :: Newbie :: Can't connect with non-root user to created database


Advanced Search

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

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.

Options: ReplyQuote


Subject Written By Posted
Can't connect with non-root user to created database Clemens Eisserer 03/15/2012 11:49AM
Re: Can't connect with non-root user to created database Grzegorz Agacinski 03/15/2012 02:13PM
Re: Can't connect with non-root user to created database Clemens Eisserer 03/15/2012 06:41PM
Re: Can't connect with non-root user to created database Rick James 03/18/2012 04:29PM
How to convert swf to video? lily an 03/16/2012 12:28AM
Re: How to convert swf to video? Rick James 03/18/2012 04:26PM


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.