![]() ![]() SHOW VARIABLES LIKE ‘validate_password%’ Īnd hopefully you will see validate_password_policy STRONG (or LOW, or whatever you have set in my.cnf) in the result set. ![]() Verify your password policy by running this command in the mysql command line (with root access): Enter the new password in that field and set the drop-down menu on the left of it to SHA1 or MD5, as required. Highlight the current password hash and delete. Find your user in the username column and click 'Edit' on the left side of the row. Then, on the Linux command line, type and execute:Īnd (hopefully) mysql will start without error. Open phpMyAdmin and click the admins table on the left. If you want to reset your MySQL root password then you should be able to run: mysqlsecureinstallation. Hopefully this will help someone, before you pull out all your hair: Then you already have access to MySQL, you will either not have a password set for the 'root' user (most likely) or you may have a password set in a configuration file for MySQL such as /etc/my.cnf. To change the password of another user account, run the passwd command, followed by the username. The following example assumes that you are logged in as a user with sudo privileges. I got the idea from this bug report: and it worked for me. Change Another User’s Password As we mentioned in the introduction, only the root user and users with sudo access can change the password of another user account. Then I added the plugin line (below) and restarted mysql, and it worked – my password policy changed on mysql startup. When restarting mysql, I kept getting “Job for rvice failed because the control process exited with error code.” error. (or 0 for LOW) to my /etc/mysql/my.cnf file, or to my /etc/mysql//mysql.cnf file alone did not work for me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |