mysql password [solved]

mystified · l33t Joined: 14 Feb 2004 Posts: 771

I just finished repairing a partially hosed system but I cannot log into the mysql server because it won't recognize my user name and password. Is there anyway of getting around this and setting a new password?

Thanks

shivernz · n00b Joined: 12 Nov 2006 Posts: 70 Location: New Zealand

This looks like it may do the job...

http://www.cyberciti.biz/tips/recover-mysql-root-password.html

mystified · l33t Joined: 14 Feb 2004 Posts: 771

for some reason I can't get past step 2. It won't start mysql again. Is there a way to start over? remove the databases and start from scratch?

meal · Posted: Fri Nov 21, 2008 9:37 am Post subject:

paste error what you get
_________________
http://www.mkozak.pl
http://blog.mkozak.pl

mystified · l33t Joined: 14 Feb 2004 Posts: 771

It doesn't give me an error. It just hangs.

meal · Posted: Fri Nov 21, 2008 9:42 am Post subject:

mystified · l33t Joined: 14 Feb 2004 Posts: 771

meal · Posted: Fri Nov 21, 2008 11:01 am Post subject:

So, as you can see, you've got mysql running. You need to shut down it.

mystified · l33t Joined: 14 Feb 2004 Posts: 771

I can go through all the steps and change my password but I still can't login.

meal · Posted: Fri Nov 21, 2008 11:57 am Post subject:

And what if you specify the hostname?

mystified · l33t Joined: 14 Feb 2004 Posts: 771

No, everything gives me access denied. Isn't there a way to just start over with mysql?

meal · Posted: Fri Nov 21, 2008 5:36 pm Post subject:

delete all from /var/lib/mysql/mysql/* and run mysql_install_db
_________________
http://www.mkozak.pl
http://blog.mkozak.pl

mystified · l33t Joined: 14 Feb 2004 Posts: 771

Thanks!

meal · Posted: Sat Nov 22, 2008 7:48 pm Post subject:

If my solution helped you, add solved to topic

_________________
http://www.mkozak.pl
http://blog.mkozak.pl