编译安装mysql

安装要用的插件

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

创建用户和用户组
groupadd -r mysql
useradd -r -g mysql -s /sbin/nologin mysql

 

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/home/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

 

mkdir -p /usr/local/mysql

make && make install

 

mkdir -p /home/mysql/data
chown -R mysql:mysql /home/mysql/data
进入到mysql-5.6.29下面
cd scripts/
chmod +x mysql_install_db
./mysql_install_db --user=mysql --datadir=/home/mysql/data --basedir=/usr/local/mysql

报错
FATAL ERROR: please install the following Perl modules before executing ./mysql_install_db:
解决方法：yum -y install autoconf

cd /usr/local/mysql/support-files/

vim mysql.server
basedir=/usr/local/mysql
datadir=/home/mysql/data
这个添加上

cp mysql.server /etc/init.d/mysql

chmod 755 /etc/init.d/

去/etc/my.cnf设置里面的

basedir = /usr/local/mysql

datadir = /home/mysql/data

 

需要全局设置的话可以把/usr/local/mysql/bin加到/etc/profile中最后一行加入

export PATH=/usr/local/mysql/bin

就可以mysql试一下了