Re: [Solved] Only connect to MySQL as “root” user/no password

[davesgonebananas]

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’

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