安装前工作
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、安装依赖
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、配置
配置环境变量
vim /etc/profile
export PATH=/data/mysql/bin:$PATH
export PATH=/data/mysql/bin:/data/mysql/lib:$PATH
source /etc/profile
6、创建mysql用户和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、假如守护进程
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、初始化数据库
mysqld --initialize-insecure --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data
10、启动mysql
service mysql start
11、登录mysql ，修改密码
mysql -u root -p #第一次登陆不需要密码，回车即可
set password for root@localhost = password('123456'); #修改密码
flush privileges;
搭建完成
