修改密码
SHOW DATABASES;
USE MYSQL;
SHOW TABLES;
UPDATE USER SET authentication_string=password('121122') WHERE USER='root'and HOST='localhost'
忘记密码
在配置文件(my.caf)最后一行加入 skip-grant-tables
重启mysql
链接mysql
修改密码
SHOW DATABASES;
USE MYSQL;
SHOW TABLES;
UPDATE USER SET authentication_string=password('121122') WHERE USER='root'and HOST='localhost'
忘记密码
在配置文件(my.caf)最后一行加入 skip-grant-tables
重启mysql
链接mysql