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 1030 times since Sun, Sep 27, 2020
Your Password does not satisfy the Current Policy Requirements
Viewed 592 times since Sat, Sep 19, 2020
How do I disable Strict Mode in MySQL?
Viewed 665 times since Mon, Sep 28, 2020
MySQL-PHP get and echo NOW() value?
Viewed 623 times since Mon, Sep 28, 2020
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
Viewed 1997 times since Sun, Sep 27, 2020
SHOW VARIABLES Statement
Viewed 653 times since Sun, Sep 27, 2020
How can I disable MySQL Strict Mode?
Viewed 766 times since Mon, Sep 28, 2020
|