How to update MySQL password?

Steps to update the MySQL Password -

1. First stop MySQL service by following command.
    #service msyqld stop
    OR
   #service mysql stop

2. Then we need to start up MySQL in safe mode, so we will skip the privileges table:
   #mysqld_safe --skip-grant-tables 

3. Now, Login with root:
   #mysql -uroot

4. Assign the DB that needs to be used:
   #use mysql;

5. Now all we have to do is reset your root password of the MySQL user and restart the MySQL service:
   update user set password=PASSWORD("YOURPASSWORDHERE") where User='root';
   flush privileges;
   quit and restart MySQL:

6. Now, start the MySQL
   #/etc/init.d/mysql start

7. Now, we are able to access MySQL by using reset password.
   #mysql -u root -p

Was this answer helpful?

 Print this Article

Also Read

How to perform the Linux Sever Hardening?

1. Check the hostname is setup or not - hostname 2. Check the IP address is assigned to hostname...

Disk Usage Useful Command

Note - You can replace /home with correct '/' drive on your server. 1. Checking the disk usage -...

How to change the port number of Apache Web Server?

Default port to access the Apache is 80. Secure port for communicating with world for Apache is...

Daily Useful Linux Commands

Finding the username from provided hosting service name - /script/whoowns domain_name Finding...

How to install MariaDB on CentOS 7?

1. Insatll MariaDB on server -  #yum install mariadb-server OR #yum install -y mariadb...

Powered by WHMCompleteSolution