Linux下安装mysql

1. 自动安装mysql所需软件及附属软件

   yum install -y mysql-server mysql mysql-devel

2. 首次设置mysql密码

   mysqladmin -u root -p ‘在此设置密码’

3. 开机自动启动mysql服务

   chkconfig mysqld on

4. 允许远程连接

   GRANT ALL PRIVILEGES ON . TO root@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;

5. 设置防火墙端口

   vi /etc/sysconfig/iptables

   在倒数第二行插入

   GRANT ALL PRIVILEGES ON . TO root@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;