centos7编译安装mysql-8.0.17

安装依赖

yum -y update
yum -y install epel-release
yum -y group install "Development Tools"
yum -y install ncurses-devel openssl openssl-devel bison

下载安装包

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.17.tar.gz

安装cmake3.17.0

wget https://cmake.org/files/v3.17/cmake-3.17.0.tar.gz

tar -zxvf cmake-3.17.0.tar.gz
cd cmake-3.17.0
./bootstrap
gmake
make install
cmake --version

安装GCC 9.2.0

wget https://mirrors.ustc.edu.cn/gnu/gcc/gcc-9.2.0/gcc-9.2.0.tar.gz

tar -zxvf gcc-9.2.0.tar.gz
cd gcc-9.2.0
./contrib/download_prerequisites
./configure --prefix=/usr/local/gcc  --enable-bootstrap --enable-checking=release --enable-languages=c,c++ --disable-multilib
time make -j4  //-j4的作用是利用多核，4代表4核cpu
make install –j4

备份旧 gcc 可执行文件

 mv /usr/bin/gcc /usr/bin/gcc.back
 mv /usr/bin/g++ /usr/bin/g++.back
 mv /usr/bin/c++ /usr/bin/c++.back
 mv /usr/bin/cpp /usr/bin/cpp.back
 mv /usr/bin/gcov /usr/bin/gcov.back
 ### 创建最新gcc 执行文件软链
 ln -sf /usr/local/gcc/bin/* /usr/bin/
 ### 删除lib64 目录下.py 文件不然ldconfig 报错
 rm -rf /usr/local/gcc/lib64/libstdc++.so.6.0.27-gdb.py
 echo /usr/local/gcc/lib64 >> /etc/ld.so.conf
ldconfig

### 复制libstdc++.so.6.0.27  /lib64/
cp /usr/local/gcc/lib64/libstdc++.so.6.0.27 /lib64/

### 创建软链 libstdc++.so.6
cd /lib64
ln  -sf libstdc++.so.6.0.27 libstdc++.so.6

### 查看是否最新版本
strings /usr/lib64/libstdc++.so.6 | grep GLIBCXX

解压并创建用户和目录

tar -zxvf mysql-boost-8.0.17.tar.gz
cd mysql-8.0.17/
useradd mysql
mkdir /data/mysql
chown -R mysql:mysql /data/mysql/
mkdir /usr/local/boost ###用来存放boost的

编译安装mysql

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EMBEDDED_SERVER=1 \
-DFORCE_INSOURCE_BUILD=1 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost

make -j4
make install -j4

复制启动文件

cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld

#添加开机自启动
chkconfig --add mysqld
chkconfig mysqld on

## 添加mysql 到环境变量
echo export PATH=$PATH:/usr/local/mysql/bin >>/etc/profile
source /etc/profile

添加配置文件

vim /etc/my.cnf
#将所有内容删除后，添加以下内容

[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8

[mysqld]
server-id=1
port=3306
user=mysql
max_connections=512
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/data/mysql
pid-file=/data/mysql/mysql.pid
character-set-server=utf8mb4
default-storage-engine=INNODB
log_error=/data/mysql/error.log
slow_query_log_file=/data/mysql/mysql-slow.log
#默认密码加密方式，防止一些管理工具不支持caching_sha2_password
default-authentication-plugin=mysql_native_password

max_allowed_packet=32M
#开启binlog日志
log-bin=/data/mysql/mysql-bin
binlog_format=ROW

[mysqldump]
quick
max_allowed_packet=2G

初始化数据库

mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

## 启动数据库
service mysqld start

#连接mysql客户端，默认密码为空
mysql -uroot

#修改所有用户的密码：
alter user user() identified by "123456"; 

#添加用户
create user 'root'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%';
flush privileges;