This tutorial is going to show you how to change a MySQL user password via command line. If you are not familiar with command line, you may use the GUI application such as MySQL Workbench (free) or Navicat premium (commercial). Changing MySQL user’s password via Terminal actually not complicated. With few commands, we can easily change the user’s password.
On this example, I want to change my root password. Please note that root here is not the system root user. This is the MySQL root user.
Steps to change MySQL user’s password via Terminal
First, login to MySQL
mysql -u root -p
You will be asked to enter the root’s password. Next, we need to switch to mysql database inside the MySQL console.
Now its time to update the root password
update user set password=PASSWORD(‘your_new_password’) where User=’root’;
You can change the user with any of your MySQL user. Simply modify the command above.
Now flush the privileges
Thank you for coming. Please leave us comment if you need any assistance.