centos7安装好mysql5.7好连接报ERROR 1045 (28000): Unknown error 1045

 

首先先把mysql服务关闭

service mysqld stop

 

然后输入 重置root密码

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

 

 设置root密码

UPDATE user SET PASSWORD=PASSWORD('root') where USER='root';FLUSH PRIVILEGES;

 

添加远程登录用户

grant all privileges on *.* to 'pigs'@'%' identified by 'pigsroot' with grant option;

 

禁用root远程登录

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

 

连接测试

mysql -upigs -p