blic (default, active)
interfaces: eth0
sources:
services: dhcpv6-client ssh
ports: 3306/tcp 22/tcp
masquerade: no
forward-ports:
icmp-blocks:
rich rules:
六、问题整理
问题1:
$ sudo scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
sudo: unable to execute scripts/mysql_install_db: No such file or directory
解决:解决这个问题纯属巧合,去掉 sudo 提示 Perl 解析器有问题,重新安装下
$ sudo yum install perl
$ sudo yum install perl-Data-Dumper.x86_64
问题2:
$ sudo scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
Installing MySQL system tables.../usr/local/mysql//bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决:
$ sudo yum install libaio.x86_64
问题3:
$ sudo support-files/mysql.server start
Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/localhost.localdomain.pid).
解决:这个问题特别实在首次启动时会提示,简单说就是找不到 my.cnf 文件,将配置完毕 my.cnf 复制到 /etc/ 或 建立软连接到 /etc/ 目录下!
$ sudo cp my.cnf /etc/
这里我有点疑惑,表面现象 mysql 启动依赖 /etc/my.cnf 文件,但实际第一次正常启动 mysql 后可以删除 /etc/my.cnf 文件,第二次启动可以正常加载 /usr/local/mysql/my.cnf 文件!
参考文章:
Centos7 安装Mysql 5.6.19
CentOS 7.0编译安装Nginx1.6.0+MySQL5.6.19+PHP5.5.14方法分享
RHEL7中防火墙firewalld的配置(1)