yum -y install gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libmcrypt* libtool*
yum install bison
2、安装cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./bootstrap
gmake && gmake install
3、编译mysql
#首先得去下载5.7.9的源码包哇。。。
cmake -DCMAKE_INSTALL_PREFIX=/data/mysql/mysql_1 \
-DMYSQL_DATADIR=/data/mysql/data/mysql_1 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DMYSQL_UNIX_ADDR=/tmp/mysql_1.sock \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/data/boost
make && make install
4、创建用户和组
groupadd mysql
useradd -r -g mysql mysql
mkdir -r /data/mysql/mysql_1
mkdir -r /data/mysql/data/mysql_1
5、初始化权限管理数据
cd /data
chown -R mysql mysql
chgrp -R mysql mysql
./mysqld --initialize-insecure --user=mysql --basedir=/data/mysql/mysql_1 --datadir=/data/mysql/data/mysql_1
chown -R root mysql
cd /data/mysql/data
chown -R mysql mysql_1
6、配置服务和开机启动
cp /data/mysql/mysql_1/support-files/my-default.cnf /data/mysql/mysql_1/my.cnf
cp /data/mysql/mysql_1/support-files/mysql.server /etc/init.d/mysql3306
cd /data/mysql/mysql_1
mkdir log
vi /etc/init.d/mysql3306
设置:conf=/data/mysql/mysql_1/my.cnf
chmod 755 /etc/init.d/mysql3306
chkconfig --add mysql3306
chkconfig mysql3306 on
7、启动mysql
service mysql3306 start
8、修改root密码
update user set authentication_string = password('1qaz2wsx') where User='root';
flush privileges;
commit;
1
顶
2
踩
分享到:
2015-11-19 11:00
浏览 1589
评论