Thursday, July 10, 2014

Change-set-reset password of mysql using ubuntu

Open terminal and follow below instructions :

1.) Stop the MySQL Server.
sudo /etc/init.d/mysql stop
2.) Start the mysqld configuration.
sudo mysqld --skip-grant-tables &
then press enter

3.) Login with MySQL as root.
mysql -u root mysql
4.) Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; 
5.) Refresh MySQL:
FLUSH PRIVILEGES; 
6.) Exit
exit;

0 comments:

Post a Comment