How to reset the MySQL 5.7 root password in Ubuntu 16.04 LTS

In case you forgot your MySQL root password, there’s a way to reset it. Here are some terminal commands to help you out!

Terminal commands:

# 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

SQL commands:

Update the password for the root user.

UPDATE mysql.user SET authentication_string=PASSWORD('ENTER_YOUR_PASSWORD_HERE'), plugin='mysql_native_password' WHERE User='root';
EXIT;

Terminal commands:

# Turn off MySQL.

sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown

# Start the MySQL service normally.

sudo service mysql start

And it’s done! I hope this short guide will help you out!