mysql databases disapeared from GUI tools
 

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.