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,