j9btlg
Last Updated: September 29, 2018
·
50.95K
· fluxsauce

Reset the MySQL 5.7 root password in Ubuntu 16.04 LTS

This is a bit gnarly. If you have a better method of updating the password without triggering a warning about PASSWORD being deprecated, I'm all ears.

# 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 &
# Log in without a password.
mysql -uroot mysql

Update the password for the root user.

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

8 Responses
Add your response

29190

Thousand thanks!!! It really helped me!

over 1 year ago ·
29280

Hey,

just signed up here to be able to comment here.

Thanks for the post, this really saved me today. I only had to replace '%' with 'localhost' because I only had the root created with "localhost" ability. After that, I could login and add the root-user as well for "%" (any host) and now I can connect easily and add other users.
Thanks again, I already gist'ed it ;)

over 1 year ago ·
29664

I could get in my precious MySQL after resetting this this command (for ubuntu 17.10 and mysql-5.7 the command on the post didn´ t work)

UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';
10 months ago ·
29696

Saved the day!
Thanks @morhook, mine couldn't recognize '%' too

10 months ago ·
29731

I accept that your probably a lot smarter than me so have no problem with it but I always strive to write code like other people are going to read it. Part of that is not writing cleverly so much as writing clearly.

Free online games: happy wheels: https://happywhels.net/

9 months ago ·
29848

@moelha @morhook @ebumstengel @Jan Sarman could have used `UPDATE mysql.user SET authenticationstring=PASSWORD('YOURNEWPASSWORD'), plugin='mysqlnativepassword' WHERE User='root'` to update all root passwords regardless of their host.

7 months ago ·
30773

https://quickensupports.org/quicken-canada-support/ visit here for more details about quicken software.

2 months ago ·
30844

I have recently downloaded Ubuntu on my pc but after that, my printer doesn't work. it shows no printer driver installed. I uninstalled the driver and again install the driver on my pc. then I visit https://www.canonprintersupportnumbers.com/blog/how-to-fix-canon-printer-error-code-b200/ and found the solution.

2 months ago ·
Filed Under