1、权限问题导致的
解决办法:
>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mima' WITH GRANT OPTION;
>flush privileges;
2、本地和远程的密码设置的不一样
解决办法:
>update mysql.user set authentication_string=PASSWORD('你的密码') where USER='root';
>flush privileges;
1、权限问题导致的
解决办法:
>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mima' WITH GRANT OPTION;
>flush privileges;
2、本地和远程的密码设置的不一样
解决办法:
>update mysql.user set authentication_string=PASSWORD('你的密码') where USER='root';
>flush privileges;