编译安装MySQL 5.5.47遇到的问题

安装编译代码需要的包
yum -y install make gcc-c++ cmake bison-devel  ncurses-devel

下载MySQL 5.5.47
wget  http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.47.tar.gz
tar xvf mysql-5.5.47.tar.gz
cd mysql-5.5.47

编译安装  去掉 -DWITH_MEMORY_STORAGE_ENGINE=1 \
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/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 && make install

配置mysql 拷贝配置文件
# cp support-files/my-large.cnf /etc/my.cnf
拷贝启动脚本文件并修改其属性
# cp support-files/mysql.server /etc/init.d/mysqld
# chmod 755 /etc/init.d/mysqld

修改启动脚本 # vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

把启动脚本加入系统服务项，设定开机启动并启动mysql
# chkconfig --add mysqld
# chkconfig mysqld on
# service mysqld start


注意报错：Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost22.pid)

tail localhost22.err  socket: /var/lib/mysql/mysql.sock ?

vi /etc/my.cnf 修改如下：

[mysqld]
port            = 3306
socket         =/tmp/mysql.sock

/usr/local/mysql/bin/mysql:登录mysql报错
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
vi /etc/my.cnf 修改如下：
[client]
#password       = your_password
port            = 3306
socket         = /tmp/mysql.sock