···shell
下載下傳
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.12-macos10.13-x86_64.tar.gz
tar -xzvf mysql-8.0.12-macos10.13-x86_64.tar.gz
移動到合适的位置
mv mysql-8.0.12-macos10.13-x86_64 ../mysql8.0.12
cd ../mysql8.0.12/
建立資料目錄
mkdir data
cd data
mkdir binlog data innodb tmp
添加配置檔案
vi my8.cnf
初始化
bin/mysqld --defaults-file=/Users/liwenjie01/mysql8.0.12/my8.cnf --initialize-insecure --user=liwenjie01 --basedir=/Users/liwenjie01/mysql8.0.12 --datadir=/Users/liwenjie01/mysql8.0.12/data/data
啟動服務
bin/mysqld_safe --defaults-file=/Users/liwenjie01/mysql8.0.12/my8.cnf --user=liwenjie01 &
登入
bin/mysql -S /Users/liwenjie01/mysql8.0.12/data/mysql8.sock -uroot -p
設定新賬号後再登入
bin/mysql -S /Users/liwenjie01/mysql8.0.12/data/mysql8.sock -umysql -pmysql
···
配置參考
···mysql
client]
port = 3307
socket = /Users/liwenjie01/mysql8.0.12/data/mysql8.sock
[mysql]
default-character-set = utf8mb4
no-auto-rehash
[mysqld]
port=3307
server_id=8
max_connections=3000
datadir=/Users/liwenjie01/mysql8.0.12/data/data
tmpdir=/Users/liwenjie01/mysql8.0.12/data/tmp
socket =/Users/liwenjie01/mysql8.0.12/data/mysql8.sock
log-error =/Users/liwenjie01/mysql8.0.12/data/mysqld8.log
pid-file =/Users/liwenjie01/mysql8.0.12/data/mysqld8.pid
log_bin=/Users/liwenjie01/mysql8.0.12/data/binlog/jay-bin
log-bin-index=/Users/liwenjie01/mysql8.0.12/data/binlog/mysql-bin.index
relay-log=/Users/liwenjie01/mysql8.0.12/data/binlog/localhost-relay-bin
default_authentication_plugin=mysql_native_password #使用5.7以前的加密方式
default_storage_engine=Innodb
default_tmp_storage_engine=Innodb
core_file
general_log=OFF
slow_query_log=ON
long_query_time=2
sync_binlog=0
log_slave_updates=ON
slave_net_timeout=3600
binlog_format=ROW
binlog_row_image=FULL
relay_log_recovery=1
master_info_repository=TABLE
relay_log_info_repository=TABLE
slave_parallel_type=LOGICAL_CLOCK
slave_parallel_workers=8
innodb_io_capacity=2000
innodb_io_capacity_max=20000
innodb_write_io_threads=16
key_buffer_size=128M
myisam_mmap_size=12M
tmp_table_size=3M
sort_buffer_size=3M
max_heap_table_size=3M
join_buffer_size=3M
bulk_insert_buffer_size=3M
explicit_defaults_for_timestamp=ON
innodb_data_home_dir=/Users/liwenjie01/mysql8.0.12/data/innodb
innodb_file_per_table=ON
innodb_buffer_pool_size=32G
innodb_sort_buffer_size=32M
innodb_log_group_home_dir=/Users/liwenjie01/mysql8.0.12/data/innodb
innodb_log_files_in_group=3
innodb_log_file_size=128M
innodb_log_buffer_size=32M
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
innodb_print_all_deadlocks=ON
wait_timeout=604800
interactive_timeout=604800
···