[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysql dependancy problems.

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

Reply to: