LinuxQuestions.org - MySQL Root Password Reset

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - MySQL Root Password Reset (https://www.linuxquestions.org/questions/linux-server-73/mysql-root-password-reset-656184/)

MySQL Root Password Reset

I am curentl trying to login to a really old version of MySQL:

Code:

[root@bugzilla root]# rpm -q mysql

mysql-3.23.58-1.73.6.legacy

I am using this link as a guide:

http://lists.mysql.com/mysql/171366

Now I am trying to login as root and am unable to so then wanted to reset the password:

1 - I stop mysql

Code:

[root@bugzilla root]# /etc/init.d/mysqld stop

Stopping MySQL:                                            [  OK  ]

2 - Run this command "mysqld_safe --skip-grant-tables &"

Code:

[root@bugzilla root]# mysqld_safe --skip-grant-tables &

[1] 4743

[root@bugzilla root]# bash: mysqld_safe: command not found

Anyone know what I am doing wrong?

Quote:

Originally Posted by Carlwill (Post 3216687)

I am curentl trying to login to a really old version of MySQL:

Code:

[root@bugzilla root]# rpm -q mysql

mysql-3.23.58-1.73.6.legacy

I am using this link as a guide:

http://lists.mysql.com/mysql/171366

Now I am trying to login as root and am unable to so then wanted to reset the password:

1 - I stop mysql

Code:

[root@bugzilla root]# /etc/init.d/mysqld stop

Stopping MySQL:                                            [  OK  ]

2 - Run this command "mysqld_safe --skip-grant-tables &"

Code:

[root@bugzilla root]# mysqld_safe --skip-grant-tables &

[1] 4743

[root@bugzilla root]# bash: mysqld_safe: command not found

Anyone know what I am doing wrong?

Command not found is that mysqld_safe isn't in your current path.

Do a locate for it and add the full path to launch it. The steps should be correct from that point in resetting the password.

locate mysqld_safe # run updatedb if its not found, then run again

or

which mysqld_safe (might not work since it's not in your path)

I can't find it with your suggestions...

Code:

[root@bugzilla root]# locate mysqld_safe

[root@bugzilla root]# updatedb

[root@bugzilla root]# locate mysqld_safe

[root@bugzilla root]# which mysqld_safe

/usr/bin/which: no mysqld_safe in (/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin)

I believe back in 3.23 days it was called safe_mysqld. I don't have an install that old though to check if it had changed yet or not.

HTH

Forrest

You're correct. Thanks!

Quote:

Originally Posted by forrestt (Post 3216718)

I believe back in 3.23 days it was called safe_mysqld. I don't have an install that old though to check if it had changed yet or not.

HTH

Forrest

Ah yeah, it's been awhile for me as well. Ah memories of MySQL 3.23 are now haunting me.. ;)

If you're going to be working on that for a while, here's the manual: http://dev.mysql.com/doc/refman/4.1/en/index.html. Ignore the name, it actually covers 3.23, 4.0, 4.1