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 install MariaDB on CentOS 7?

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

How to run the backup process which is stuck using rsync?

While running the backup process, I was getting the error message as - /usr/bin/rsync -rlptD...

How to setup the email alert for low disk space?

If you don't want to setup to a full monitoring solution such as Nagios you can create your own...

How to backup and restore large MySQL databases using mysqldump?

1. Backup database: #mysqldump -u username -p[username_password] databasename >...

How to setup PPTP VPN?

A Point-To-Point Tunneling Protocol (PPTP) allows you to implement your own VPN very quickly, and...

Powered by WHMCompleteSolution