Here I’ll show you How to reset/change MySql root password command line in ubuntu linux, Using some mysql CLI commands you can easily recover your mysql administrative password. As I forgot to my mysql root password then i use below commands to reset my mysql root password and it works like charm.



Step-1: First login to your ubuntu server using ssh and stop mysql server.

sudo /etc/init.d/mysql stop

OR

sudo service mysql stop

Step-2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.

 sudo mysqld_safe --skip-grant-tables &




Step-3: Connect with mysql server as root user by running below command on terminal.

sudo mysql -u root

Step-4: Set new mysql root user password.Just replace “NewPassword” with your desired password in below command.

UPDATE user SET Password=PASSWORD('NewPassword') WHERE User='root'; FLUSH PRIVILEGES; exit;

Step-5: All done now restart mysql server.

sudo /etc/init.d/mysql start

OR

sudo service mysql start

See below image with details.
reset-mysql-password-cli-1

If you like this post please don’t forget to subscribe my public notebook for more useful stuff