报错日志如下:
2019-08-16T06:10:30.156632Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/soft/src/mysql/mysql8/share/mysql-8.0/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
配置文件my.cnf如下:
[client]
port = 3303
socket = /soft/src/mysql/mysql8/sock/mysqlx.sock
max_allowed_packet = 48M
[mysql]
no-auto-rehash
socket = /soft/src/mysql/mysql8/sock/mysqlx.sock
[mysqldump]
quick
max_allowed_packet = 64M
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout=1800
[mysqld_safe]
open-files-limit = 8192
[mysqld]
server-id = 50
port = 3303
basedir = /soft/src/mysql/mysql8
datadir = /soft/src/mysql/mysql8/data
datadir = /soft/src/mysql/mysql8/data
socket = /soft/src/mysql/mysql8/sock/mysqlx.sock
pid-file = /soft/src/mysql/mysql8/mysql.pid
log-error = /soft/src/mysql/mysql8/logs/mysql.err
#default-character-set=utf8
character-set-server = utf8
back_log = 512
wait_timeout=1800
lock_wait_timeout=1800
interactive_timeout=1800
max_connections = 2048
connect_timeout = 20
max_connect_errors = 128
open_files_limit = 8192
table_open_cache = 2048
max_allowed_packet = 16M
read_buffer_size = 32M
sort_buffer_size = 32M
read_rnd_buffer_size = 16M
join_buffer_size = 32M
key_buffer_size = 1024M
bulk_insert_buffer_size = 64M
thread_cache_size = 8
thread_stack = 240K
ft_min_word_len = 4
default-storage-engine = INNODB
transaction_isolation = REPEATABLE-READ
tmp_table_size = 256M
max_heap_table_size = 64M
log-bin=/soft/src/mysql/mysql8/logs/mysql-bin
binlog_format=mixed
binlog_cache_size = 1M
expire_logs_days = 15
slow_query_log = ON
slow_launch_time = 2
slow_query_log_file = /soft/src/mysql/mysql8/logs/slow.log
long_query_time = 1
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 2G
myisam_repair_threads = 1
myisam-recover-options = BACKUP,FORCE
innodb_data_file_path = ibdata1:10M:autoextend
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
#memlock
innodb_buffer_pool_instances=4
innodb_buffer_pool_size = 1G
innodb_log_file_size = 512M
innodb_lock_wait_timeout = 60
innodb_flush_log_at_trx_commit = 0
### small swap / IO
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 8M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_file_per_table = 1
innodb_open_files = 2048
skip-external-locking
secure-file-priv=/soft/src/mysql/mysql8/tmp
log_queries_not_using_indexes = 0
解决:
[root@localhost share]# pwd
/usr/share
[root@localhost share]# cp -r mysql-8.0/ /soft/src/mysql/mysql8/share/
[root@localhost share]# systemctl restart mysqld
另一种方法:
直接修改配置文件my.cnf,在mysqld下面加入一条
lc-messages-dir = /usr/share/mysql-8.0/
然后报错就没了~不知道对不对坐等大神坐等~~等~