mysql源码5.6编译安装，最后启动错误原因总结

过程来源于另一位优秀的运维工程师的笔稿
1.yum -y install gcc gcc-c++ autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake

2.cd /
mkdir /opt/mysql mkdir /opt/mysql/data/ mkdir/opt/mysql/etc
groupadd mysql
useradd mysql -g mysql -M -s /sbin/nologin

3. 在/下
   导入源码压缩包

4. 在/下
   tar -zxf mysql-5.6.24.tar

5.cd mysql-5.6.24

6.cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql/ -DMYSQL_DATADIR=/opt/mysql/data/ -DSYSCONFDIR=/opt/mysql/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/opt/mysql/etc/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make -j6
make install

7. cd /opt/mysql
   chown -R mysql.mysql /opt/mysql
   cp /opt/mysql/support-files/my-default.cnf /etc/my.cnf
   cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
   chmod 755 /etc/init.d/mysqld

8. vi /opt/mysql/etc/my.cnf
   [mysqld]
   basedir = /opt/mysql
   datadir = /opt/mysql/data
   port = 3306
   # server_id = …
   socket = /opt/mysql/etc/mysql.sock #这一行指定了mysql启动后sock文件的位置，登录本机的mysql时若报错没有发现该文件则将路径改为报错时的路径即可
   sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES11.

9./opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data
或cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld

10.rm -f /etc/my.cnf
rm -f /opt/mysql/my.cnf

11. /etc/init.d/mysqld start

12. cat /var/log/mysqld.log

13. [root@localhost mysql-5.6.24]# /etc/init.d/mysqld start
    Starting MySQL… ERROR! The server quit without updating PID file (/opt/mysql/data/localhost.localdomain.pid).

14.mysql> set password=password(‘yang123’);

原因：
重装之前没关掉原来的mysql，导致3306端口被占用
解决方法：
netstat -antup
kill …
/etc/init.d/mysqld start