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 mysq