MySQL Reset root password

Tag: represents INIT.D It's str host ble blank SQL input

1. Reset the root password:

Service MySQL Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit

#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>

The 2.MySQL database uses Heidisql remote management:

mysql> use MySQL;

Mysql> selecthost,user from user;

See if the root user is allowed to log on locally (localhost) only, this is the case.

Yes, it is necessary to modify its host to%, which means that any IP address can be logged in.

3. The database permissions issue should be clear earlier:

After logging in with the root user:

Mysql>use MySQL; Using the MySQL Database

Mysql>use Zuker; Use Zuker this database

Mysql>select user (); View the user name of the current action

Mysql>show grants; Show all permissions for the current user

Mysql>flush privileges; To make the operation effective; After making any changes, it is recommended to use this directive

Mysql>grant all privileges in testdb.* to [email protected] identified ' 1234 '; Give the user all permissions to the operational database TestDB

MySQL Reset root password