Centos6.5安装Mysql在线安装

安装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;