MYSQL8.0.11二进制安装
Mysql8.0源码编译安装涉及包较多，推荐现在二进制包安装。
一、创建用户和组
groupadd mysql
useradd -g mysql mysql
echo "password" | passwd --stdin mysql
二、创建目录
mkdir -p /data/mysql/tmp
mkdir -p /data/mysql/data
mkdir -p /data/mysql/dumps
mkdir -p /data/mysql/log
mkdir -p /data/mysql/undo
mkdir -p /data/servers/mysql/etc
chown mysql.mysql -R /data/mysql
chown mysql.mysql -R /data/servers/mysql
三、下载二进制包
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
四、解压到指定目录
tar -zxvf/root/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz -C /data/servers/mysql
五、添加环境变量
sed -i '$a export PATH=$PATH:/data/servers/mysql/bin'/etc/profile; source /etc/profile
六、创建error.log（8.0版本在无error.log的情况下不会自动创建，会报错）
touch /data/mysql/log/error.log
chown mysql.mysql /data/mysql/log/error.log
七、初始化库表结构
mysqld --initialize --user=mysql --basedir=/data/servers/mysql/ --datadir=/data/mysql/data --innodb_undo_directory=/data/mysql/undo --innodb_undo_tablespaces=4 --socket=/data/mysql/tmp/mysql.socket --port=3358 --innodb_data_file_path=ibdata1:512M:autoextend --lower-case-table-names=1注意8.0初始化必须指定这些参数，不然会报错
2018-07-04T07:54:21.696764Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.2018-07-04T07:54:22.297200Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine2018-07-04T07:54:22.297359Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.2018-07-04T07:54:22.297381Z 0 [ERROR] [MY-010119] [Server] Aborting |
|---|
初始化产生的初始密码：
[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Jod6BHNlkd*8
八、添加配置文件(仅供参考)
vim /data/servers/mysql/etc/my.cnf
[client] | |
|---|---|
port | 3358 |
socket | /data/mysql/tmp/mysql.socket |
[mysqld] | |
innodb_undo_tablespaces | 4 |
innodb_undo_directory | /data/mysql/undo |
######MySQL8.0自适应参数###### | |
#innodb_log_file_size | 1363148800 |
innodb_data_file_path | ibdata1:512M:autoextend |
innodb_checksum_algorithm | crc32 |
explicit_defaults_for_timestamp | ON |
innodb_buffer_pool_load_at_startup | ON |
innodb_buffer_pool_dump_at_shutdown | ON |
read_only | 0 |
port | 3358 |
socket | /data/mysql/tmp/mysql.socket |
datadir | /data/mysql/data |
basedir | /data/servers/mysql |
user | mysql |
innodb_dedicated_server | 1 |
#---GLOBAL---# | |
#transaction-isolation | READ-COMMITTED |
sql_mode | NO_ENGINE_SUBSTITUTION |
default_authentication_plugin | mysql_native_password |
######在MySQL8.0中注释掉此参数，不然就会有警告信息###### | |
#secure_file_priv | |
default-storage-engine | INNODB |
character-set-server | utf8mb4 |
######mysql8.0要求设定为0###### | |
lower_case_table_names | 1 |
log-error | /data/mysql/log/error.log |
general_log | 0 |
general_log_file | /data/mysql/log/general.log |
pid-file | /data/mysql/data/mysql.pid |
slow-query-log | |
slow_query_log_file | /data/mysql/log/slow.log |
tmpdir | /data/mysql/tmp |
long_query_time | 0.1 |
#enableslaveslowlog | |
log_slow_slave_statements | 1 |
thread_cache_size | 512 |
table_open_cache | 16384 |
table_definition_cache | 16384 |
table_open_cache_instances | 8 |
######弃用###### | |
#metadata_locks_hash_instances | 256 |
sort_buffer_size | 256K |
join_buffer_size | 256K |
read_buffer_size | 256K |
read_rnd_buffer_size | 256K |
key_buffer_size | 64M |
myisam_sort_buffer_size | 64M |
tmp_table_size | 16M |
max_heap_table_size | 16M |
open_files_limit | 65535 |
######mysql8.0无此参数###### | |
#query_cache_size | 0 |
######mysql8.0无此参数###### | |
#query_cache_type | 0 |
log_bin_trust_function_creators | 1 |
#---NETWORK---# | |
back_log | 2000 |
max_allowed_packet | 64M |
interactive_timeout | 28800 |
wait_timeout | 28800 |
max-connections | 2000 |
#skip-name-resolve | |
#---REPL---# | |
server-id | 1234567 |
report_host | 192.168.1.1 |
#nogtidconfig | |
log-bin | mysql-bin |
binlog_format | row |
binlog_row_image | full |
######弃用###### | |
#expire_logs_days | 7 |
binlog_expire_logs_seconds | 604800 |
relay-log | relay-log |
log_slave_updates | |
slave_net_timeout | 30 |
skip-slave-start | |
slave-parallel-workers | 0 |
relay_log_info_repository | TABLE |
master_info_repository | TABLE |
sync_master_info | 0 |
sync_relay_log_info | 0 |
sync_binlog | 1 |
#flushdisk | |
sync_relay_log | 0 |
slave_rows_search_algorithms | INDEX_SCAN,HASH_SCAN |
#rpl_semi_sync_master_enabled | 1 |
#rpl_semi_sync_slave_enabled | 1 |
#rpl_semi_sync_master_timeout | 1000 |
relay_log_recovery | 1 |
#---INNODB---# | |
innodb_adaptive_flushing | ON |
innodb_adaptive_flushing_lwm | 15 |
innodb_flushing_avg_loops | 30 |
innodb_adaptive_hash_index | ON |
innodb_data_home_dir | /data/mysql/data |
innodb_file_per_table | ON |
innodb_log_group_home_dir | /data/mysql/data |
innodb_log_files_in_group | 3 |
innodb_log_buffer_size | 32M |
innodb_flush_log_at_trx_commit | 1 |
innodb_flush_log_at_timeout | 1 |
innodb_lock_wait_timeout | 30 |
######MySQL8.0自适应参数###### | |
#innodb_flush_method | O_DIRECT |
innodb_max_dirty_pages_pct | 75 |
innodb_max_dirty_pages_pct_lwm | 0 |
######MySQL8.0自适应参数###### | |
#innodb_buffer_pool_size | 100G |
innodb_buffer_pool_instances | 8 |
innodb_change_buffering | all |
innodb_change_buffer_max_size | 10 |
innodb_autoextend_increment | 64 |
innodb_thread_concurrency | 32 |
innodb_spin_wait_delay | 6 |
innodb_sync_spin_loops | 30 |
innodb_open_files | 65535 |
innodb_old_blocks_time | 30 |
innodb_online_alter_log_max_size | 512M |
innodb_write_io_threads | 8 |
innodb_read_io_threads | 8 |
innodb_flush_neighbors | 0 |
innodb_io_capacity | 3000 |
innodb_io_capacity_max | 16000 |
innodb_lru_scan_depth | 1024 |
innodb_purge_threads | 4 |
innodb_purge_batch_size | 400 |
######mysql8.0无此参数###### | |
#innodb_file_format | Barracuda |
######mysql8.0无此参数###### | |
#innodb_large_prefix | ON |
##innodb_force_load_corrupted | OFF |
#innodb_force_recovery | 0 |
#bufferpooldumpandload | |
innodb_buffer_pool_filename | ib_buffer_pool |
innodb_buffer_pool_load_abort | OFF |
innodb_buffer_pool_dump_now | OFF |
innodb_buffer_pool_load_now | OFF |
[mysqldump] | |
quick | |
max_allowed_packet | 64M |
[mysql] | |
no-auto-rehash | |
default-character-set | utf8mb4 |
prompt | (\u@\h)[\d]> |
[myisamchk] | |
key_buffer_size | 128M |
sort_buffer_size | 128M |
read_buffer | 2M |
write_buffer | 2M |
[mysqlhotcopy] | |
interactive-timeout | |
chown mysql.mysql -R /data/servers/mysql
九、启动
/data/servers/mysql/bin/mysqld_safe --defaults-file=/servers/mysql/etc/my.cnf &
十、登录（初始密码）
/data/servers/mysql/bin/mysql -uroot -p --socket=/data/mysql/tmp/mysql.socket
十一、修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY "123456";（默认采用新加密方式）
注意8.0 默认采用新的加密方式：caching_sha2_password，会导致8.0以下版本的客户端连接不上：
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /datatt/servers/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory |
|---|
解决：修改为老的加密方式：mysql_native_password
mysql> ALTER USER `test`@`%` IDENTIFIED WITH mysql_native_password BY "123456"; #修改加密规则
mysql> ALTER USER `test`@`%` IDENTIFIED BY "123456" PASSWORD EXPIRE NEVER; #永不过期
mysql> FLUSH PRIVILEGES; #刷新权限
或者在配置文件my.cnf修改参数采用老的加密方式
default_authentication_plugin = mysql_native_password
接下来可以自由发挥了~~~
腾讯云开发者
