[ERROR] Can‘t find error-message file ‘/usr/local/mysql/share/errmsg.sys‘.

数据库初始化遇到过的那些坑.
[ERROR] Can’t find error-message file ‘/usr/local/mysql/share/errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive.

[root@localhost ~]# /opt/server/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/opt/data/
2021-01-21T01:27:11.134607Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-21T01:27:11.134803Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2021-01-21T01:27:14.243535Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-01-21T01:27:14.480270Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-01-21T01:27:14.549530Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cac41e79-5b87-11eb-b5d3-000c298aaed4.
2021-01-21T01:27:14.567964Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-01-21T01:27:16.051819Z 0 [Warning] CA certificate ca.pem is self signed.
2021-01-21T01:27:16.342662Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

可以尝试下在初始化是加上 --basedir=

[root@localhost ~]# /opt/server/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/server/mysql --datadir=/opt/data/
2021-01-21T01:31:38.160910Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-21T01:31:41.635516Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-01-21T01:31:41.881108Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-01-21T01:31:41.951589Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 6a266e3c-5b88-11eb-bb49-000c298aaed4.
2021-01-21T01:31:41.955403Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-01-21T01:31:43.779301Z 0 [Warning] CA certificate ca.pem is self signed.
2021-01-21T01:31:44.300397Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
  • 3
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值