I have resolved the problem by: - removing the /var/lib/mysql/mysql folder - reinstalling the mysql-server package
Anyway I have no idea of where this can come from. This seems like an obscure bug Is there a way to reinstall a new 'mysql' database without reinstalling the software ? ----- Original Message ----- From: "chatiman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 14, 2004 8:46 PM Subject: MySQL big problem > Since today I can only access to 2 databases (instead of 10) : > mysql -u root > > show databases shows me only 2 db > theres 10 in /var/lib/mysql > > I suspect that the grant tables are damaged . > How can I repair them ? > > Note that I cannot do > mysql -u mysql mysql > which returns access denied to '@localhost' > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]