Centos下mysql5.6编译安装

|

安装目录：/usr/local/mysql
数据库目录：/usr/local/mysql/data
一、安装前面

1
2
3
添加用户
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
1
2
yum安装依赖包
yum -y install gcc* ncurses-devel cmake bison
1
2
3
4
解压创建目录
tar zxf mysql-5.6.13.tar.gz 
cd mysql-5.6.13
mkdir -p /usr/local/mysql/data
1
2
3
cmake配置以及编译安装mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGING=1 -DWITH_INNOBASE_STORAGE_ENGING=1 -DWITH_MEMORY_STORAGE_ENGING=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306
make && make install
1
2
3
4
5
6
拷贝配置文件
cp support-files/my-default.cnf /usr/local/mysql/my.cnf
初始化数据库
cd /usr/local/mysql/scripts/
./mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/ --basedir=/usr/local/mysql/
`
1
chown -R mysql:mysql /usr/local/mysql/
1
2
3
4
5
6
7
8
9
修改my.cnf配置
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/mysql_error.log
pid-file = /usr/local/mysql/mysql.pid
user = mysql
tmpdir = /tmp
`
1
2
3
4
5
6
拷贝启动文件配置安全启动向导初始化
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +X  /etc/init.d/mysqld
ln -s /usr/local/mysql/my.cnf /etc
bin/mysql_secure_installation 
`
1
2
3
4
5
设置软连接
ln -s /usr/local/mysql/bin/* /usr/local/bin/
ln -s /usr/local/mysql/include/mysql/* /usr/include/
ln -s /usr/local/mysql/lib/* /usr/lib/
`
1
2
启动 
/etc/init.d/mysqld start