Re: mysql dependancy problems.

[Nelson Menezes <nelson@burninghorizons.net>]

Chris Wakefield wrote:
> Greetings all.
>
> I've managed to re-install mysql-server-5.0, mysql-client-5.0 and the support 
> libraries, etc.  What is happening now is what prompted me to uninstall 2 
> days ago, which is I mistakenly had phpmyadmin remove three mysql users:  
> root, a user and the debian system maintainer.  The error I'm getting is:
>
>  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
>
> Since I can't log in as root, how can I recreate these users?

First, stop the server and back up your data directory. Should be 
/var/lib/mysql.

Second, run this:

	mv /var/lib/mysql/mysql /var/lib/mysql/mysql.backup

Then, run this:

	mysql_install_db --user=mysql
	chown -R mysql: /var/lib/mysql

Restart the server. You should now be able to log in as root with no 
password, but you'll have lost any other users that you have created. 
There should be a "mysql.backup" database that will have those; you can 
use that to help restore them.

Hope that helps.

--
Nelson Menezes