Created
March 9, 2018 13:54
-
-
Save richardsonlima/be3889a0058c1f37a4da85ea50125af5 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
What worked for me (Ubuntu 16.04, mysql 5.7): | |
Stop MySQL | |
sudo service mysql stop | |
Make MySQL service directory. | |
sudo mkdir /var/run/mysqld | |
Give MySQL user permission to write to the service directory. | |
sudo chown mysql: /var/run/mysqld | |
Start MySQL manually, without permission checks or networking. | |
sudo mysqld_safe --skip-grant-tables --skip-networking & | |
On another console, log in without a password. | |
mysql -uroot mysql | |
Then: | |
UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='%'; | |
EXIT; | |
Turn off MySQL. | |
sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown | |
Start the MySQL service normally. | |
sudo service mysql start |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment