mysql80源码安装

## 下载源码
    mysql官网

MySQL :: Download MySQL Community Server

## cmake

 cmake版本大于2.8，gcc版本大于7.1
cd到源码目录，创建build目录，在buid目录下执行下面命令
  cmake .. \
-DCMAKE_INSTALL_PREFIX=/home/zxchh/mysql80 \
-DWITH_BOOST=/home/zxchh/mysql80/mysql-8.0.27/boost/boost_1_73_0  \
-DWITH_EXTRA_CHARSETS:STRING=all \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_NDBCLUSTER_STORAGE_ENGINE=0 \
-DENABLED_LOCAL_INFILE=1  \
-DWITH_DEBUG=1

## 编译
make -j32 && make install

## 配置文件
[client]
port=5518
socket=/home/zxchh/mysql80/bin/mysql.sock
default-character-set=utf8

[mysqld]
default_authentication_plugin=mysql_native_password //不指定插件的话，创建连接的时候会报错“ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded”
port=5518

socket=/home/zxchh/mysql80/bin/mysql.sock
pid-file=/home/zxchh/mysql80/bin/mysql.pid
basedir=/home/zxchh/mysql80
datadir=/home/zxchh/mysql80/data
tmpdir=/home/zxchh/mysql80/tmp
character-set-server=utf8
log_error=/home/zxchh/mysql80/log/mysql.err
 
server-id=2
log_bin=/home/zxchh/mysql80/data/binlog
 
general_log_file=/home/zxchh/mysql80/log/general_log
 
slow_query_log=ON
long_query_time=2
slow_query_log_file=/home/zxchh/mysql80/log/query_log
log_queries_not_using_indexes=ON

## 初始化
在bin目录下执行：
./mysqld --defaults-file=/home/zxchh/mysql80/etc/my.cnf --initialize-insecure --user=root --basedir=/home/zxchh/mysql80/ --datadir=/home/zxchh/mysql80/data

## 启动
./mysqld_safe --defaults-file=/home/zxchh/mysql80/etc/my.cnf &

## 连接
mysql -h127.0.0.1 -uroot -P5518

## 创建账号
create user 'zxc'@'%' identified by '123';
grant all privileges on *.* to 'zxc'@'%';
flush privileges;

## 重新连接
mysql -h127.0.0.1 -uzxc  -p123 -P5518