!! Need help resetting MySQL Root Password.

[spindler]

I used the following command to view my database.
sudo cp -pr /var/lib/mysql ~/mysql.org
I received an error.

sudo cp -pr /var/lib/mysql ~/mysql.org

So then I tried to copy my database using the following command.

sudo cp -pr /var/lib/mysql ~/mysql.org
I took a look at the home directory to see if I could find a backup.sql but I did not find anything. What does it look like? How do I know I created a backup successfully?

[spindler]

Thanks everyone for your help. i was able to recover MySQL. I still need to look into fixing the VAR chown issue but at least my website is up again.

Spindler

[PaulReaver]

just incase anyone else has this problem in the future

http://dev.mysql.com/doc/refman/4.1/...rmissions.html