Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save richardsonlima/be3889a0058c1f37a4da85ea50125af5 to your computer and use it in GitHub Desktop.
Save richardsonlima/be3889a0058c1f37a4da85ea50125af5 to your computer and use it in GitHub Desktop.
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