View previous topic :: View next topic |
Author |
Message |
zambizzi Guru
Joined: 28 Aug 2004 Posts: 581 Location: Boise Idaho
|
Posted: Fri Sep 03, 2004 1:08 am Post subject: mysql root lock-out |
|
|
I'm not sure how this happened but I can't get into mysql. Either I typed the password wrong and can't figure out what it is or something else is going haywire.
Either way, I can't mysql -u root into mysql.
I thought perhaps uninstalling and re-installing would solve it but it still tells me "permission denied" after I've re-installed it.
Is there a file somewhere or something I need to purge/delete in order to "reset" me back to a new mysql installation where the root user doesn't have a password?
Thanks!
-v |
|
Back to top |
|
|
zambizzi Guru
Joined: 28 Aug 2004 Posts: 581 Location: Boise Idaho
|
Posted: Fri Sep 03, 2004 2:14 am Post subject: solved the problem... |
|
|
Nevermind, solved it by searching high and low through the forums.
I did an ugly brute-force method by deleting everything in /var/lib/mysql/mysql
Code: |
rm -rf /var/lib/mysql/mysql/*
|
...and then starting mysql & re-running the mysql_install_db script
Code: |
/etc/init.d/mysql start
/usr/bin/mysql_install_db
|
Just in case anyone else runs into a scenario where they can't root-login to their mysql server!
-v |
|
Back to top |
|
|
|