mysql 8.0编译_MySQL 8.0 编译安装

0. 安装依赖

yum install -y libaio-devel libaio necurses-devel necurses readline-devel.x86_64 readline.x86_64 openssl openssl-devel

1. 安装 gcc

yum install -y centos-release-scl

yum install -y devtoolset-8-gcc.x86_64 devtoolset-8-gcc-c++.x86_64 devtoolset-8-gdb.x86_64 cmake

source /opt/rh/devtoolset-8/enable

gcc -v

2. 安装 cmake

./cmake-3.16.4-Linux-x86_64.sh --prefix=/usr/local

echo "export PATH=$PATH:/usr/local/cmake-3.16.4-Linux-x86_64/bin" >>/etc/profile & source /etc/profile

cmake --version

3. 下载源码包

4. 测试编译环境

cd /root/mysql-8.0.19

mkdir build

cd build

cmake ../ -DWITH_BOOST=../boost/

5. 编译MySQL

cd ..

rm -rf build

mkdir build

cmake ../

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql8

-DWITH_BOOST=../boost/

DEBUG 方式

cmake ../ \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql8 \

-DWITH_DEBUG=1 \

-DCMAKE_BUILD_TYPE=Debug \

-DWITH_BOOST=../boost/

6. 安装

make install

7. 建用户及实例目录

mkdir -p /data/mysql/mysql3306/{data,logs,tmp}

上传配置文件到/data/mysql/mysql3306/

groupadd mysql

useradd -g mysql -s /sbin/nologin -d /usr/local/mysql8 -MN mysql

chown -R mysql:mysql /usr/local/mysql8/

chown -R mysql:mysql /data/mysql/mysql3306/

8. 初始化database:

/usr/local/mysql8/bin/mysqld --defaults-file=/data/mysql/mysql3306/my3306.cnf --initialize

echo "export PATH=$PATH:/usr/local/mysql8/bin" >>/etc/profile & source /etc/profile

9. 启动MySQL Server:

/usr/local/mysql8/bin/mysqld_safe --defaults-file=/data/mysql/mysql3306/my3306.cnf &

10. 登录mysql

mysql -S /tmp/mysql3306.sock -p

11、改密码

cat /data/mysql/mysql3306/data/error.log | grep passwor

mysql -S /tmp/mysql3306.sock -p

mysql>alter user current_user() identified by 'abc123';