How to MySQL change user password

In this tutorial, How do i use MySQL change user password. MySQL and MariaDB are the popular open source Database for Linux Opearating System.

 

Mysql change root password

Note: MySQL default root password is empty when you installed Mysql or MariaDB.
Now, How to reset Mysql root or other users password on linux.

For MySQL 5.7 or above version

Step 1: Open the command terminal.
sudo mysql -u root
Step 2: select the database.
use mysql;
Step 3: Change the root password.
UPDATE mysql.user SET authentication_string=PASSWORD('YOUR_NEW_PASSWORD') WHERE USER='root';
FLUSH PRIVILEGES;
exit

For MySQL 5.7 version or older version

Step 1: Open the command terminal.
sudo mysql -u root
Step 2: select the database.
use mysql;
Step 3: To change the MySQL root user password.
update user set password=PASSWORD("YOUR_NEW_PASSWORD") where User='root';
FLUSH PRIVILEGES;
exit
 Step 4: restart the MySQL service
systemctl restart mysql

MySQL command to change a user password

MySQL show users
SELECT User FROM mysql.user;
Step 1: Open the command terminal
sudo mysql -u root  -p
Step 2: Switch to MySQL database
use mysql;
Step 3: Change the USER password
MySQL database server version 5.7.5 or older versions
SET PASSWORD FOR 'YOUR_USER_NAME'@'localhost' = PASSWORD('NEW_PASSWORD');
MySQL database server version 5.7.6 or above.
ALTER USER 'YOUR_USER_NAME'@'localhost' IDENTIFIED BY 'NEW_PASSWORD';

Comments

Popular posts from this blog

zimbra some services are not running [Solve problem]

Bash script list all IP addresses connected to Server

How to install php7 on centos 6