stop:

service mysql stop 

mysqld_safe login:

mysqld_safe –skip-grant-tables &
mysql -u root

load plugin:

use mysql;
update user set password=PASSWORD(“123456”) where User=’root’;
update user set plugin=”mysql_native_password“;
quit;

start:

service mysql start 

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code