Home » Categories » MySQL » Configuration | ||||
How to change the MySQL root account password on CentOS7? |
||||
Article Number: 13 | Rating: Unrated | Last Updated: Sat, Sep 5, 2020 at 5:36 PM
|
||||
1. Stop mysql: 2. Set the mySQL environment option 3. Start mysql usig the options you just set 4. Login as root 5. Update the root user password with these mysql commands Or you'll get a warning 6. Stop mysql 7. Unset the mySQL envitroment option so it starts normally next time 8. Start mysql normally: Try to login using your new password:
Source: https://stackoverflow.com/questions/33510184/how-to-change-the-mysql-root-account-password-on-centos7 |
||||
| ||||
Attachments
![]()
There are no attachments for this article.
| ||||
Comments ![]() There are no comments for this article. Be the first to post a comment. | ||||
How to enable explicit_defaults_for_timestamp?
Viewed 1069 times since Sun, Sep 27, 2020
Your Password does not satisfy the Current Policy Requirements
Viewed 622 times since Sat, Sep 19, 2020
MySQL-PHP get and echo NOW() value?
Viewed 654 times since Mon, Sep 28, 2020
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
Viewed 2035 times since Sun, Sep 27, 2020
MySQL/MariaDB error on the server with Plesk: Could not increase number of max_open_files to more than 16384
Viewed 20 times since Sun, Aug 24, 2025
How do I disable Strict Mode in MySQL?
Viewed 694 times since Mon, Sep 28, 2020
SHOW VARIABLES Statement
Viewed 676 times since Sun, Sep 27, 2020
How can I disable MySQL Strict Mode?
Viewed 799 times since Mon, Sep 28, 2020
|