安装Mysql服务端
[root@node01 ~]# yum install mysql-server -y
[root@node01 ~]# yum install mysql-server -y
Complete!
[root@node01 ~]# service mysqld start
[root@node01 ~]# service mysqld start
[ OK ]
Starting mysqld: [ OK ]
进入Mysql(不需要密码)
对Mysql进行设置
允许所有主机访问(ip)mysql中的所有库和表
mysql> use mysql;
mysql> select host,user,password from user;
//赋予所有的权限允许所有主机远程访问
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//删除多余会对权限造成影响的数据
mysql> delete from user where host!='%';
mysql> flush privileges;