![]() 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): Then, on the Linux command line, type and execute:Īnd (hopefully) mysql will start without error. When a prompt appears, key in the admin password you created, and you will be all set to go. Hopefully this will help someone, before you pull out all your hair: At this point, you should be able to log into the MySQL command prompt using the newly set admin passcode by executing the command below: mysql -u root -p. I got the idea from this bug report: and it worked for me. After switching to root you can run the passwd command directly to change the root user. sudo passwd root sudo password for daygeek New password: Retype new password: passwd: all authentication tokens updated successfully. service mysqld stop then start mysql instance with the command below to change password. kill cat /mysql-data-directory/hostname.pid or. Then I added the plugin line (below) and restarted mysql, and it worked – my password policy changed on mysql startup. If you want to change the root user password directly from the sudo privilege user, use the following command format. ALTER USER 'root''localhost' IDENTIFIED BY 'MyNewPass' Caution Before going further stop your mysql instance. 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 |