错误提示:
报错:error no. 1045 access denied for user 'root'@'x.x.x.x' (using password:YES)
或者:1045 - Access denied for user 'root'@'x.x.x.x'(using password:YES)
登录到mysql主机:mysql -u root -p
连接到mysql:use mysql;
查询用户表命令:select User,Host from user
授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'
%是所有的机器都可以访问,如果只是新增自己的,就开成自己的IP就可以了,123456改成root密码
重新加载权限数据:flush privileges;
查询用户表命令:select User,Host from user
有了自己添加的就可以登录了。