安裝前工作
1、下載源碼
下載mysql、boost壓縮包
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28.tar.gz
wget https://gigenet.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
2、安裝依賴(lài)
yum -y install cmake ncurses-devel gcc gcc-c++ pcre pcre-devel openssl openssl-devel
3、解壓
tar -zxvf mysql-5.7.28.tar.gz -C /opt
tar -zxvf boost_1_59_0.tar.gz -C /opt
4、編譯安裝mysql
cd /opt/mysql-5.7.28
cmake -DCMAKE_INSTALL_PREFIX=/data/mysql \
-DWITH_BOOST=/opt/boost_1_59_0 \
-DMYSQL_UNIX_ADDR=/data/mysql/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql/data \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DWITH_INNODB_MEMCACHED=1 \
-DWITH_DEBUG=OFF \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DENABLED_PROFILING=ON \
-DMYSQL_MAINTAINER_MODE=OFF \
-DMYSQL_TCP_PORT=3306
5、配置
配置環(huán)境變量
vim /etc/profile
export PATH=/data/mysql/bin:$PATH
export PATH=/data/mysql/bin:/data/mysql/lib:$PATH
source /etc/profile
6、創(chuàng)建mysql用戶(hù)和data目錄
cd /data/mysql
mkdir -p /data/mysql/{tmp,logs,pids,share,data}
touch /data/mysql/logs/mysqld.log
touch /data/mysql/pids/mysqld.pid
useradd -s /sbin/nologin -M mysql
chown -R mysql:mysql /data/mysql
7、修改my.cnf配置文件
[mysqld]
[mysqld_safe]
[client]
8、假如守護(hù)進(jìn)程
cd /opt/mysql-5.7.28
cp support-files/mysql.server /etc/init.d/mysql
chmod a+x /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
9、初始化數(shù)據(jù)庫(kù)
mysqld --initialize-insecure --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data
10、啟動(dòng)mysql
service mysql start
11、登錄mysql ，修改密碼
mysql -u root -p #第一次登陸不需要密碼，回車(chē)即可
set password for root@localhost = password('123456'); #修改密碼
flush privileges;
搭建完成
