Home » Categories » MySQL » Configuration

How to change the MySQL root account password on CentOS7?

1. Stop mysql:
systemctl stop mysqld

2. Set the mySQL environment option
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

3. Start mysql usig the options you just set
systemctl start mysqld

4. Login as root
mysql -u root

5. Update the root user password with these mysql commands
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')
-> WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
mysql> quit

Or you'll get a warning

6. Stop mysql
systemctl stop mysqld

7. Unset the mySQL envitroment option so it starts normally next time
systemctl unset-environment MYSQLD_OPTS

8. Start mysql normally:
systemctl start mysqld

Try to login using your new password:
7. mysql -u root -p

 

Source:

https://stackoverflow.com/questions/33510184/how-to-change-the-mysql-root-account-password-on-centos7

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Comments Comments
There are no comments for this article. Be the first to post a comment.
Related Articles RSS Feed
How can I disable MySQL Strict Mode?
Viewed 843 times since Mon, Sep 28, 2020
How do I disable Strict Mode in MySQL?
Viewed 729 times since Mon, Sep 28, 2020
Your Password does not satisfy the Current Policy Requirements
Viewed 657 times since Sat, Sep 19, 2020
MySQL-PHP get and echo NOW() value?
Viewed 683 times since Mon, Sep 28, 2020