1.登录
mysql -uroot -p
2.授权,赋予任何主机上以root身份密码为123456访问数据的权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
授权远程访问mysql -uroot -p mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION; //赋予任何主机上以root身份访问数据的权限 mysql>FLUSH PRIVILEGES; 重启mysql服务防火墙查看状态 : iptables -L 关闭防火墙:iptables -F