How to Change MySQL user passsword in linux
Step 1: Login MySQL Server
Use the mysql credentials to login in mysql server:
# mysql -u root -p
Step 2: Select the database
Select the database by using use command:
mysql> use mysql;
Step 3: Change MySQL user passsword
Change password for user test, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='test';
Step 4: Reload Privileges
Finally, reload the privileges:
mysql> flush privileges; mysql> quit