LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 07-16-2008, 02:20 PM   #1
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Arch
Posts: 2,905

Rep: Reputation: 73
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?
 
Old 07-16-2008, 02:23 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by Carlwill View Post
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)
 
Old 07-16-2008, 02:29 PM   #3
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Arch
Posts: 2,905

Original Poster
Rep: Reputation: 73
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)
 
Old 07-16-2008, 02:56 PM   #4
forrestt
Senior Member
 
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
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
 
Old 07-16-2008, 02:57 PM   #5
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Arch
Posts: 2,905

Original Poster
Rep: Reputation: 73
You're correct. Thanks!
 
Old 07-16-2008, 03:32 PM   #6
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by forrestt View Post
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..
 
Old 07-18-2008, 04:58 AM   #7
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql: still can't login after root password reset andredude Linux - Software 4 12-19-2014 07:30 PM
How to retrieve( or reset) root password in Mandrake Linux, as I forgot my password? Reghunath Linux - Software 4 05-08-2008 05:11 AM
Mysql password reset etch the_Case Debian 11 05-30-2007 05:08 AM
mysql root password reset. gtum5 LinuxQuestions.org Member Intro 0 03-08-2007 09:57 PM
MySQL - Canot reset password texmansru47 Linux - Software 1 10-10-2005 06:19 PM


All times are GMT -5. The time now is 04:31 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration