Follow steps below 1.Start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) $ mysqld --skip-grant-tables 2.Then Execute these statements. $ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES; 3.Finally, restart the instance/daemon without the --skip-grant-tables option. $ /etc/init.d/mysql restart 4.You should be able to connect with your new password. $ mysql -u root -p Enter password: my_password
1.Start the mysql server instance or daemon with the
--skip-grant-tables
option. (security setting)$ mysqld --skip-grant-tables
2.Then Execute these statements.$ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES;
3.Finally, restart the instance/daemon without the
--skip-grant-tables
option.$ /etc/init.d/mysql restart
4.You should be able to connect with your new password.
$ mysql -u root -p
Enter password:
my_password