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
Hi Warren, sounds like a real tough one. Only thing I can suggest is to (using mysql console):
| 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.