1、增加连接权限
grant all on . to “root”@“192.168.8.%” IDENTIFIED by ‘123456’;
flush PRIVILEGES;
2、修改mysql8以上版本的数据库密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘admin’;
mysql-version<8
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘admin’;