How to change the password of MySQLroot in VPS

Modify the password of MySQLroot in VPS. For more information, see.

You can change the password of the MySQL root User in VPS. For more information, see.

1. Stop the running MySQL process
In Linux, run killall-TERM mysqld
In Windows, if it is written as a service, you can run: net stop mysql. If it is not loaded as a service, you can directly close it in the Process Manager.

2. Start MySQL in Safe Mode
Run/usr/local/mysql/bin/mysqld_safe-skip-grant-tables &
In Windows, run X:/MySQL/bin/mysqld-nt.exe-skip-grant-tables on the command line

3. You will be able to access MySQL without a password.
In Linux, run/usr/local/mysql/bin/mysql-u root-p to enter
In Windows, run X:/MySQL/bin/mysql-u root-p to enter

4. Change the password
> Use mysql
> Update user set password = password ("new password") where user = "root ";
> Flush privileges;