Quote:
Originally Posted by sinchan_
hi all
I have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
regards
|
It looks like you changed the password/user, but the tool didn't save the new one.
Your databases are fine, since you can see them through the terminal. Best thing would be to go into a terminal, and set up a user. The message indicates the user name is not being passed (the ''@'localhost'). So set up a new user and use it, or check the MySQL docs on the "grant all" command.