mysql编译安装

# 使用源码包编译mysql

官网下载源码包:https://dev.mysql.com/downloads/mysql/

yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make cmake

cmake . \
-DWITH_BOOST=boost/ \  # 使用mysql与boost一体包直接写这个即可，如果不是一体包需要指定boost目录
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DINSTALL_MANDIR=/usr/share/man \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_COLLATION=utf8 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1

make && make install

# 开始部署mysql

groupadd mysql
useradd -r -g mysql -s /bin/nologin mysql

cd /usr/local/mysql/
mkdir mysql-files
chown -R mysql.mysql /usr/local/mysql/
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --character-set-server=utf8 --collation-server=utf8_unicode_ci
/usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data/

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start

 

vim /etc/my.conf

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data