Identify MySQL Version
First, connect to the database server by running the following command. The below command will connect to the MySQL database server running on localhost. Enter the MySQL root account password to authenticate. Once the authentications are successful, You will find a database server prompt like mysql>. In the case of MariaDB, the prompt will little differ. Here you run the SQL statement to identify the MySQL version. The above output shows that you are running MySQL server version 5.7.34.
Change MySQL User Password
You have the version of the running MySQL server. Use one of the following commands to change the MySQL user password as per of database server version running on your system. In the below SQL statements, make sure to change dbuser with your databsae user and localhost with the users host.
Use the ALTER USER to change MySQL user password for the mysql database server version 5.7.6 or newer versions:mysql> ALTER USER ‘dbuser’@’localhost’ IDENTIFIED BY ’new-password’; For the MySQL database server version 5.7.5 or older version, Use “SET PASSWORD” statement” to change a MySQL user password using SQL queries.mysql> SET PASSWORD FOR ‘dbuser’@’localhost’ = PASSWORD(’new-password’);
Conclusion
In this quick write-up, you will find a solution to change a MySQL user password using SQL queries.
