Page 1 of 1

[SOLVED] Adding MySQL users

Posted: Sun May 06, 2007 5:55 pm
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,

Posted: Sun May 06, 2007 7:51 pm
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.

Posted: Mon May 07, 2007 9:57 am
by impulse()
I went into the 'Privilages' tab and then 'add new user' and this way works fine.

Posted: Mon May 07, 2007 1:39 pm
by timvw
If i remember well, you have to reload mysql so that the account changes are loaded...


mysqladmin reload -u root -p