MySQL Forums :: Newbie :: Password reset

Advanced Search

Password reset
Posted by: Shuja Khan ()
Date: May 27, 2008 09:06AM

1. root password to mysql db is lost

MYSQL info:
1. I am using mysql db as an RPM based install (during OS install).
2. version: mysql Ver 14.12 Distrib 5.0.54, for redhat-linux-gnu (x86_64) using readline 5.1
3. OS version: #1 SMP Wed Dec 26 08:30:41 EST 2007 x86_64 x86_64 x86_64 GNU/Linux

Recovery attempts:
1. we have tried the following method to recover mysql password.

a. stoped mysql, /etc/init.d/mysqld stop
b. create a text file abc.txt with following contents

UPDATE mysql.user SET Password=PASSWORD('1234') WHERE User='root';

c. mysqld_safe --init-file=/root/abc.txt &
d. When executed following is printed on screen

--->Start of output
[root@server ~]# mysqld_safe --init-file=/root/abc.txt &
[1] 20454
[root@server ~]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/
080527 15:20:48 mysqld ended

[1]+ Done mysqld_safe --init-file=/root/abc.txt
[root@server ~]#
--->>> end of output

Still we are unable to logon to our mysql as root. We cannot create tables, users, etc, but standard users can logon using their username & password but not the root.

Please help recover lost root password for mysqldb

Thanks in advance for your kind help


Edited 2 time(s). Last edit at 05/27/2008 09:09AM by Shuja Khan.

Options: ReplyQuote

Subject Written By Posted
Password reset Shuja Khan 05/27/2008 09:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.