当前位置:   article > 正文

MySQL8初始化报错 --Data Dictionary initialization failed

data dictionary initialization failed.

我使用的命令是:

/mysqld  --defaults-file=/etc/my.cnf  --basedir=/usr/local/mysql  --datadir=/data/mysql/mysql3306/   --user=mysql  

拷少参数了还找半天,,,,,,,,

[root@node02 bin]# 

./mysqld --initialize  --basedir=/usr/local/mysql --datadir=/data/mysql/data/ --user=mysql

改成这个就好了撒!

[root@node02 data]# cat /etc/my.cnf
[client]
port = 13306
socket = /data/mysql/data/mysql.sock
[mysqld]
character_set_server=UTF8MB4
init_connect='SET NAMES UTF8MB4'
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/data/mysql/data/mysql.sock
log-error=/data/mysql/data/mysqld.log
pid-file=/data/mysql/data/mysqld.pid
lower_case_table_names = 1
max_connections=5000
open_files_limit = 65535
max_connect_errors = 100000
default-time_zone = '+8:00'
max_binlog_size = 256M
sync_binlog = 0
gtid-mode = on
enforce-gtid-consistency=1
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 1
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 1024M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 50
innodb_file_per_table = 1
innodb_rollback_on_timeout
innodb_io_capacity = 2000
table_open_cache = 2048
table_definition_cache = 2048
table_open_cache = 2048
max_heap_table_size = 96M
sort_buffer_size = 128K
join_buffer_size = 128K
thread_cache_size = 200
thread_stack = 192K
tmp_table_size = 96M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/小蓝xlanll/article/detail/628216
推荐阅读
相关标签
  

闽ICP备14008679号