出现场景:虚拟机与本机的交互或者本机与远程的Mysql连接。
问题缘由:
1.地址正确但账户或密码有误;
2.mysql在默认配置下,root用户是不允许远程连接的,即使新创建的user默认也不允许远程连接。
解决方法:
1.指定IP(192.168.1.101)授权:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.101' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
注:myuser为要分配的账户,mypassword为授权地址登录密码;
2.给所有IP授权(把原IP改为%):
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;