Lost MySQL password

JavaNinja · 01-28-2009, 10:00 AM

Ok, I managed to mess something up and I forgot or made a wrong entry somewhere for my MySQL password.

How can I uninstall MySQL and re-install a fresh copy?

I have tried this but got an error:

Code:

[root@localhost /]# rpm -e mysql
error: Failed dependencies:
        mysql = 5.0.67-2.fc10 is needed by (installed) mysql-server-5.0.67-2.fc10.i386
        mysql is needed by (installed) MySQL-python-1.2.2-7.fc10.i386

[SOLVED]

rpm -qa | grep -i mysql

then

rpm -e

in some order

[NOT SOLVED]
I uninstalled mysql and installed it again however when I try to login:

Code:

[root@localhost /]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost /]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

HELP!!!

auximini · 01-28-2009, 11:41 AM

I've used this method to reset some lost root passwords:

http://dev.mysql.com/doc/refman/5.0/...rmissions-unix

Step 2 can be replaced with

Code:

/etc/init.d/mysqld stop

Or whatever the init script is called.

Hope that helps.

r3sistance · 01-28-2009, 12:29 PM

Just incase you are having one that I have had before, sometimes on very brand new installs of MySQL their might not be any accounts at all! you have to start MySQL in a rescue/maintainance mode and actually create a brand new root account... unfortantly I don't have time right now to look up the link for that one that I had to use, it was on the official MySQL site tho.

JavaNinja · 01-28-2009, 02:40 PM

[SOLVED]

When you uninstall make sure you also remove any files left otherwise you will never have a fresh install of mysql.

I hope the above saves somebody a few hours of headache.