Re: mysql dependancy problems.
Chris Wakefield wrote:
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
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
Second, run this:
mv /var/lib/mysql/mysql /var/lib/mysql/mysql.backup
Then, run this:
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.