Linux CentOS7源码编译安装MySQL8.0.21

准备

CentOS版本：最小化安装，CentOS7.8，硬盘至少40G，内存至少3G，SWAP3G
MYSQL版本：mysql-boost-8.0.21

安装必要的依赖

yum -y install gcc-c++ pcre pcre-devel zlib zlib-devel openssl openssl-devel mlocate bzip2 lrzsz ncurses-devel       

updatedb    ----更新数据库

安装cmake, mysql8需要cmake3以上, cdrom的版本太低

下载：http://cmake.org/files/v3.18/cmake-3.18.0.tar.gz
放在cd /usr/local/src/
解压 tar -xzvf cmake-3.18.0.tar.gz

mkdir -p /usr/local/cmake                               ----创建cmake安装目录

cd /usr/local/src/cmake-3.18.0
./configure --prefix=/usr/local/cmake   				----prefix设置安装到哪
make -j4
make install
ln -s /usr/local/cmake/bin/cmake /usr/bin       		----创建软链接

升级gcc, 为什么升级, 因为自带版本太低不能编译MySql8

1. yum升级gcc

升级到gcc 9.3
yum -y install centos-release-scl devtoolset-9-gcc devtoolset-9-gcc-c++ devtoolset-9-binutils
scl enable devtoolset-9 bash
echo "source /opt/rh/devtoolset-9/enable" >>/etc/profile
source /etc/profile

2. 源码编译升级gcc (不推荐)

cd /usr/local/src
下载：https://mirrors.ustc.edu.cn/gnu/gcc/gcc-10.1.0/gcc-10.1.0.tar.gz
解压：tar -xzvf gcc-10.1.0.tar.gz

下载四个文件（./contrib/download_prerequisites里面有四个文件版本）
http://gcc.gnu.org/pub/gcc/infrastructure/gmp-6.1.0.tar.bz2
http://gcc.gnu.org/pub/gcc/infrastructure/mpfr-3.1.4.tar.bz2
http://gcc.gnu.org/pub/gcc/infrastructure/mpc-1.0.3.tar.gz
http://gcc.gnu.org/pub/gcc/infrastructure/isl-0.18.tar.bz2
上传四个文件到gcc解压目录

mkdir -p /usr/local/gcc     		   创建gcc安装目录

cd /usr/src/gcc-10.1.0/
./contrib/download_prerequisites       提示四个确定即可
./configure --prefix=/usr/local/gcc -enable-checking=release -enable-languages=c,c++ -disable-multilib 
make -j4  (两小时左右)
make install

删除以前版本：yum -y remove gcc
设置环境变量：echo "export PATH=/usr/local/gcc/bin:$PATH" >> /etc/profile.d/gcc.sh
加载环境变量：source /etc/profile.d/gcc.sh
找动态库：   find / -name libstdc++.so.6
出现的目录复制下来替换掉：
rm -rf /usr/lib64/libstdc++.so.6
cp /usr/local/gcc/lib64/libstdc++.so.6 /usr/lib64/

查看版本  gcc -v

安装MySql8

1. 删除mariadb，下载mysql

yum -y remove mari*

2. 解压，编辑源码

cd /usr/local/src
tar -xzvf mysql-boost-8.0.21.tar.gz

locate terminal.c    ----显示出目录 编辑terminal.c文件
vim /usr/local/src/mysql-8.0.21/extra/libedit/libedit-20190324-3.1/src/terminal.c

3. 创建目录

mkdir -p /usr/local/mysql
cd /usr/local/mysql
mkdir -p data boost run tmp myconfig log
mkdir -p /usr/local/mysql/log/mysqlbin/mysql-bin

4. 创建专用mysql账户，并设置所属主

useradd mysql -s /sbin/nologin
chown -R mysql:mysql /usr/local/mysql/

5. 下载boost

https://dl.bintray.com/boostorg/release/1.72.0/source/boost_1_72_0.tar.gz
放在刚才创建的boost目录解压

6. 设置安装参数，参数详解看这篇https://www.cnblogs.com/martinzhang/p/3455681.html

cd /usr/local/src/mysql-8.0.21/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/usr/local/mysql/myconfig -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/mysql/boost -DFORCE_INSOURCE_BUILD=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock -DWITH_ZLIB=system -DWITH_SSL=system         

7. 编译

vim storage/innobase/buf/buf0buf.cc    ----编辑，在开头添加 #include "sys/syscall.h"
make -j4
make install

MySQL初始化操作

1. 第一步：初始化

cd /usr/local/mysql/bin
./mysqld --initialize--insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --log-bin=/usr/local/mysql/log/mysqlbin/mysql-bin   

2. 添加到系统服务，添加可读执行权限

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

3. 编辑vim /etc/init.d/mysqld

46 basedir=/usr/local/mysql 
47 datadir=/usr/local/mysql/data

4. 编写配置文件vim /usr/local/mysql/myconfig/my.cnf

[client]
default-character-set=utf8
  #password = your_password
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock

#服务端配置
[mysqld]
character-set-server=utf8mb4
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M

# 主从配置
server-id = 1

# Innodb配置
innodb_data_home_dir = /usr/local/mysql/data
innodb_log_group_home_dir = /usr/local/mysql/data
innodb_buffer_pool_size = 129M

# 慢日志设置
slow_query_log=1
long_query_time=2
slow_query_log_file=/usr/local/mysql/log/slow_query.log

# bin-log二进制日志设置
log-bin=/usr/local/mysql/log/mysqlbin/mysql-bin
binlog_format=statement

#其他配置
[mysqldump]
quick

[mysql]
auto-rehash

[mysqld_safe]
open-files-limit = 8192

5. 添加环境变量

vim /etc/profile     ----第74行添加如下
export PATH=$PATH:/usr/local/mysql/bin

6. 使环境变量重启后也生效

vim ~/.bashrc			  ----最后一行添加 source /etc/profile

7. 开启mysql服务

service mysqld start		----开启服务
service mysqld restart		----重启服务
service mysqld stop			----停止服务
service mysqld status		----服务状态

chkconfig mysqld on         ----mysql服务加入开机自启

8. 设置密码，设置远程可登录

没有密码，直接回车登录
mysql -uroot -p

修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '12345@Root';  
exit;

mysql -uroot -p12345@Root

修改远程可登录
use mysql;
update user set host ='%' where user ='root';   
flush privileges;

my.cnf 配置参数可以看这篇https://www.cnblogs.com/panwenbin-logs/p/8360703.html