LinuxQuestions.org

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

carlosinfl 07-16-2008 02:20 PM

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?

trickykid 07-16-2008 02:23 PM

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)

carlosinfl 07-16-2008 02:29 PM

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)


forrestt 07-16-2008 02:56 PM

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

carlosinfl 07-16-2008 02:57 PM

You're correct. Thanks!

trickykid 07-16-2008 03:32 PM

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.. ;)

chrism01 07-18-2008 04:58 AM

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


All times are GMT -5. The time now is 11:32 AM.