[SOLVED] Adding MySQL users

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

[SOLVED] Adding MySQL users

Post by impulse() »

I'm running the following statement to add a new MySQL user:

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO 'test'@'%'
IDENTIFIED BY 'password' WITH GRANT OPTION;
But I'm getting denied access when trying to login. I can see the account has been created in the 'user' table. When logging into the root account (which has no trouble logging in) I get a warning stating that mcrypt isn't installed and I believe this may have something to do with the problem because aren't MySQL users passwords encrypted with mcrypt?
I am running Fedora Core 6 and I have installed mcrypt using 'yum install mcrypt' and I have restarted Apache and MySQL but I still get the warning.

Does anyone have any suggestions for solving the problems.

Regards,
Last edited by impulse() on Mon May 07, 2007 9:57 am, edited 1 time in total.
Begby
Forum Regular
Posts: 575
Joined: Wed Dec 13, 2006 10:28 am

Post by Begby »

Yeah, I think your issue lies with your mysql install. I suggest checking out the fedora forums if nobody here has a good answer.
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Post by impulse() »

I went into the 'Privilages' tab and then 'add new user' and this way works fine.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

If i remember well, you have to reload mysql so that the account changes are loaded...


mysqladmin reload -u root -p
Post Reply