Linux-Noob Forums › Linux Server Administration › LAMP v
How to reset mysql root password

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode
How to reset mysql root password
alan Offline
Junior Member
**
Posts: 13
Threads: 6
Joined: Jun 2004
Reputation: 0
#1
2004-06-03, 11:09 PM (This post was last modified: 2012-01-08, 02:15 PM by Dungeon-Dave.)
I just set it awhile ago, and now I forgot it. Is there a way to retrieve it back?
Find
Reply
anyweb Offline
Administrator
*******
Posts: 3,631
Threads: 899
Joined: Dec 2003
Reputation: 0
#2
2004-06-04, 06:15 AM

try this

 



Code:
./mysqladmin -u root password new-password




 

cheers

 

anyweb

Find
Reply
LilGemi Offline
Junior Member
**
Posts: 2
Threads: 1
Joined: Jun 2004
Reputation: 0
#3
2004-07-01, 08:54 AM

I had the same problems but was getting some funny error messages with anywebs command so I used this reference :

 

[/url][url=http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html]http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

 

Its was really good however where it says this:

 

shell> kill `cat /mysql-data-directory/host_name.pid`

 

I did this:

 

kill cat '/urs/local/mydsql/data/linux.domain.com.pid'

 

to get the process id to stop mysql. The rest worked fine and was a great help.

Find
Reply
znx Offline
Posting Freak
*****
Posts: 1,229
Threads: 45
Joined: Mar 2005
Reputation: 0
#4
2006-01-13, 08:33 PM (This post was last modified: 2012-01-08, 02:08 PM by Dungeon-Dave.)

Never forgotten a password, then you must be in the minority. All is not lost however there is a way of starting MySQL and then accessing it without a password.

 



Code:
# /etc/init.d/mysql stop
# killall mysqld
# mysqld --skip-grant-tables --user=root &
# mysql
mysql> use mysql;
mysql> update user set password=password("newpassword") where user="root";
mysql> flush privileges;
mysql> exit
# killall mysqld
# /etc/init.d/mysql start




 

Thats it.. a quick and easy way to recover your mysql database password [img]<___base_url___>/public/style_emoticons/default/happy.gif[/img]

Find
Reply
anyweb Offline
Administrator
*******
Posts: 3,631
Threads: 899
Joined: Dec 2003
Reputation: 0
#5
2006-01-13, 08:56 PM

pinned

 

thanks znx !

Find
Reply
xDamox Offline
Senior Member
****
Posts: 383
Threads: 63
Joined: Dec 2004
Reputation: 0
#6
2006-01-14, 12:31 PM
Nice one znx :)
Find
Reply
znx Offline
Posting Freak
*****
Posts: 1,229
Threads: 45
Joined: Mar 2005
Reputation: 0
#7
2006-03-18, 11:39 PM (This post was last modified: 2006-06-14, 08:10 PM by znx.)

Some more notes..

 

If you see this complaint:



Code:
# mysqld --skip-grant-tables --user=root &
# 060318 16:31:10 [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line




 

Then its most likely still running, you can confirm with:



Code:
# netstat -tlp | grep mysql
tcp  0  0  host.domain:mysql  *:*  LISTEN  20310/mysqld
# killall mysqld
# netstat -tlp | grep mysql
#




 

And then you can continue to the next step...

Find
Reply
znx Offline
Posting Freak
*****
Posts: 1,229
Threads: 45
Joined: Mar 2005
Reputation: 0
#8
2006-08-28, 09:20 PM

If you find that you can't execute mysqld .. then it could be that the mysql server is hidden, so you can use:

 



Code:
/usr/libexec/mysqld --skip-grant-tables --user=root &




 

Instead :)

Find
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)