Home › Forums › Back End › [Solved] Only connect to MySQL as "root" user/no password › Re: [Solved] Only connect to MySQL as “root” user/no password
August 10, 2009 at 6:18 pm
#62028
davesgonebananas
Member
Hi Warren, sounds like a real tough one. Only thing I can suggest is to (using mysql console):
Code:
SHOW GRANTS FOR ‘rie_admin’@’localhost’;
| GRANT USAGE ON *.* TO ‘rie_admin’@’localhost’ IDENTIFIED BY PASSWORD ‘*xxxxxxx’ |
| GRANT ALL PRIVILEGES ON `xxz.* TO ‘rie_admin’@’localhost’
| GRANT USAGE ON *.* TO ‘rie_admin’@’localhost’ IDENTIFIED BY PASSWORD ‘*xxxxxxx’ |
| GRANT ALL PRIVILEGES ON `xxz.* TO ‘rie_admin’@’localhost’
There should be a minimum of GRANT USAGE and also a grant on the specific database. This might at least give you some insight as to why it’s not working.
Hope that at least points you in the right direction.
Cheers
Dave