CentOS modifies the root password of MySQL

1, know the password

First time login (no password)

Changed password

' OldPassword ' ' NewPassword '

2. Forgot password

Edit MySQL configuration file my.cnf

Vi

#编辑文件, find [mysqld], add a line below Skip-grant-tables

[Mysqld]skip-grant-tables

Restart Service

Service mysqld Restart

Go to MySQL console and change your password

Mysql-uroot-p

Update Mysql.user set Password=password ('123123') where user="root  "and host="localhost"; flush privileges; #刷新系统授权表

Cancel Skip-grant-tables in/etc/my.cnf and restart MySQL

3. Open Remote access permission

Go to MySQL Console

' Root '@'192.168.0.1'password ' with grant option; Flush privileges; Exit

Above is the open IP 192.168.0.1, if you want to open all, use% instead of IP

# #取消授权等操作 View

CentOS modifies the root password of MySQL