[mysqld]
user=mysql
port=3306
datadir=/app/mysql/data
socket=/app/mysql/mysql.sock
log-error=/app/mysql/log/mysqld.log
pid-file=/app/mysql/mysqld.pid
[client]
socket=/app/mysql/mysql.sock

sudo mkdir /app/mysql/data /app/mysql/log -p
sudo chown mysql:mysql /app/mysql -R

sudo cat /app/mysql/log |grep root@localhost (做過第4步使用該命令)
sudo cat /var/log/mysqld.log|grep root@localhost (未做過第4步使用該命令)

alter user 'root'@'localhost' identified by '你的密碼';

tar cmake-3.16.1.tgz
cd cmake-3.16.1
sudo ./bootstrap 
sudo make 
sudo make check
sudo make install

tar -xzvf m4-latest.tar.gz
cd m4-1.4.17/
sudo ./configure --prefix=/usr/local(--prefix指定安裝路徑)
sudo make (編譯)
sudo make check (檢查編譯是否有錯,注意是否有Error,可以不做)
sudo make install (安裝)
m4 --version (查看m4版本)

sudo ln -s /usr/local/bin/m4 /usr/bin (把m4做一個軟連接到此路徑下,否則configure時會報錯:checking for suitable m4... configure: error: No usable m4 in $PATH or /usr/5bin (see config.log for reasons).)
tar -xvf gmp-6.2.0.tar.xz
cd gmp-6.2.0
sudo ./configure --prefix=/usr/local/gmp-6.2 (非管理員必須要sudo,否則會報錯:Permission denied)
sudo make
sudo make check
sudo make install

tar -xzvf mpfr-4.0.2.tar.gz 
cd mpfr-4.0.2 
sudo ./configure --prefix=/usr/local/mpfr-4.0 --with-gmp=/usr/local/gmp-6.2 (--with-gmp為gmp的安裝目錄)
sudo make
sudo make check
sudo make install

tar -xzvf mpc-1.1.0.tar.gz
cd mpc-1.1
sudo ./configure --prefix=/usr/local/mpc-1.1 --with-gmp=/usr/local/gmp-6.2 --with-mpfr=/usr/local/mpfr-4.0
sudo make
sduo make check
sudo make install

sudo vi /etc/ld.so.conf
 /usr/local/mpfr-4.0/lib/

 /usr/local/gmp-6.2/lib

 /usr/local/mpc-1.1/lib

sudo ldconfig (使上面的操作生效)

sudo ln -s /usr/local/mpfr-4.0/lib/libmpfr.so.6 /usr/bin

sudo cp /usr/local/mpfr-4.0/lib/libmpfr.so.6 /usr/bin/

tar -xzvf gcc-9.2.0.tar.gz
cd gcc-9.2.0
 sudo ./configure --prefix=/usr/local/gcc-9.2 \

 --enable-bootstrap\

 --enable-checking=release \

 --enable-languages=c,c++ \

 --enable-threads=posix \

 --disable-checking\

 --disable-multilib\

 --enable--long-long\

 --with-gmp=/usr/local/gmp-6.2\

 --with-mpfr=/usr/local/mpfr-4.0\

 --with-mpc=/usr/local/mpc-1.1
sudo make (編譯時間較長,1個小時的樣子)
sudo make check
sudo make install

sudo rpm -e gcc-c++
sudo rpm -e gcc
sudo vi /etc/profile export PATH=$PATH:/usr/local/gcc/bin 
　　source /etc/profile

tar -xzvf mysql-8.0.19.tar.gz
cd mysql-8.0.19
cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql\

 -DDEFAULT_CHARSET=utf8\

 -DDEFAULT_COLLATION=utf8_general_ci\

 -DENABLED_LOCAL_INFILE=ON\

 -DWITH_SSL=system\

 -DMYSQL_DATADIR=/app/mysql/data\

 -DSYSCONFDIR=/app/mysql/config\

 -DMYSQL_TCP_PORT=3306\

 -DMYSQL_UNIX_ADDR=/app/mysql/mysql.sock\

 -DWITH_BOOST=/home/mcbadm/mysql8/\

 -DFORCE_INSOURCE_BUILD=1

-DDEFAULT_CHARSET:設置字符集
-DDEFAULT_COLLATION:設置排序規則
-DENABLED_LOCAL_INFILE=ON:啟用本地數據導入支持
-DWITH_SSL=system:啟用ssl庫支持
-DMYSQL_DATADIR:數據文件目錄,可任意 
-DSYSCONFDIR:配置文件目錄,可任意 
-DMYSQL_TCP_PORT:mysql監聽的TCP端口
-DMYSQL_UNIX_ADDR:mysql.sock路徑,可任意 
-DWITH_BOOST:boost源碼包所在目錄 
-DFORCE_INSOURCE_BUILD:強制建立未存在的資源目錄
cmake若報錯,請找到原因解決后刪除CMakeCache.txt再次cmake

sudo rm -rf /usr/lib64/libstdc++.so.6* (刪掉所有低版本c++的庫文件)
sudo ln -s /usr/local/gcc-9.2/lib64 /usr/lib64 (把新安裝的高本版c++庫文件加入到系統庫文件中)
sudo make (需要大概1小時)
sudo make install

sudo mkdir /app/mysql/config
sudo cd /app/mysql
sudo vi config/my.cnf

[mysqld]
user=mysql
port=3306
datadir=/app/mysql/data
socket=/app/mysql/mysql.sock
[mysqld_safe]
log-error=/app/mysql/logs/mysql-err.log
pid-file=/app/mysql/mysql.pid
[client]
socket=/app/mysql/mysql.sock
sudo useradd mysql -s /sbin/nologin
sudo mkdir -p /app/mysql/logs
sudo touch /app/mysql/logs/mysql-err.log
sudo chown -R mysql.mysql /app/mysql

sudo /app/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/app/mysql/data --basedir=/app/mysql  (無初始密碼的，若想要初始密碼，使用--initialize)