源码编译 安装mysql5.5.50

1.下载5.5.50源码 tar.gz
2. /usr/local/mysql55_50

3.下载cmake

4.

cd  cmake
./configure
make && make install

5.安装make的依赖

yum install ncurses-devel

yum install bison

1. cd mysql源码目录

7.

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55_50 \
-DMYSQL_UNIX_ADDR=/tmp/mysql7778.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data1/mysql7778 \
-DMYSQL_USER=mysql

make

make install

8.建数据目录并授权

mkdir /data/mysql7778/
groupadd mysql
useradd -g mysql my7778
chown my7778.mysql -R /data/mysql7778/
确保每一级都授权

9.拖mysql库到端口中

10.初始化实例

/usr/local/mysql55_50/scripts/mysql_install_db \
--basedir=/usr/local/mysql55_50 \
--datadir=/data1/mysql7778 \
--user=mysql

11.启动实例

cd /usr/local/mysql55_50 ;  ./bin/mysqld_safe --defaults-file=/data1/mysql7778/my7778.cnf >/dev/null 2>&1 &