Resetting the Root Password: Generic Instructions
The preceding sections provide password-resetting instructions specifically for Windows and Unix and Unix-like systems. Alternatively, on any platform, you can reset the password using the mysql client (but this approach is less secure):
- Stop the MySQL server if necessary, then restart it with the
--skip-grant-tablesoption. This enables anyone to connect without a password and with all privileges, and disables account-management statements such as
SET PASSWORD. Because this is insecure, if the server is started with the
--skip-grant-tablesoption, it also disables remote connections by enabling
- Connect to the MySQL server using the mysql client; no password is necessary because the server was started with
mysql client, tell the server to reload the grant tables so that account-management statements work:
mysql> FLUSH PRIVILEGES;
Then change the
'root'@'localhost' account password. Replace the password with the password that you want to use. To change the password for a
root account with a different host name part, modify the instructions to use that host name.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
You should now be able to connect to the MySQL server as
root using the new password. Stop the server and restart it normally (without the
--skip-grant-tables option and without enabling the
skip_networking system variable).
- How to disable MySQL Strict Mode?
- how to find size of the database via mysql console
- How to replace MySQL with Percona Server on Debian or Ubuntu
- howto upgrade mariadb 10.x to 10.3.x on Centos 7
- How to add remote MySQL database server VestaCP