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: