Lost MySQL Admin Password

by on March 17, 2009 · 2 comments· LAST UPDATED March 25, 2010

in

I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?

Type the following commands. First, stop current MySQL database server:
/etc/init.d/mysql stop
OR
/etc/init.d/mysqld stop
OR
/usr/local/etc/rc.d/mysql-server stop

Now, start mysql server without password so that you can restart the password:
mysqld_safe --skip-grant-tables &
Login without a password, enter:
mysql -u root
Finally, setup a new MySQL root user password, enter::

USE mysql;
UPDATE user SET password=PASSWORD("NEW-ROOT-PASSWORD") WHERE User='root';
FLUSH privileges;
quit
 

Replace NEW-ROOT-PASSWORD with actual password you want to use. Restart running mysql server:
/etc/init.d/mysql restart
Test it:
mysql -u root -p

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 2 comments… read them below or add one }

1 santosamaru April 13, 2010 at 4:26 pm

sir would you help me sir , i have problem with using ubuntu
its my brother 6years old have changing my user privileges and set its none , i also cant goes as a root ,(crying)ehm i dont know how to set it back also i cant us my password in terminal to sudo su , its wont work did you know how i can get its back without reinstalling ?
please help me sir
thanks

Reply

2 niro January 4, 2012 at 10:53 am

Thanks alot!

Reply

Leave a Comment

Tagged as: , , , , , , , , , , , , ,

Previous Faq:

Next Faq: