CNDBA社区
新搭建的MySQL 环境，之前已经搭建了HAProxy，所以不想铲掉，就重新换了个目录进行初始，结果异常，初始化很快结束，并且没有日志，也没有密码：
[dave@www.cndba.cn data]$ mysqld --initialize --defaults-file=/data/mysql/3406/my3406.cnf --datadir=/data/mysql/3406/data
[dave@www.cndba.cn data]$ ls
因为我们使用的是 —initialize，正常会在当前命令行输出相关命令和密码。 这里直接返回，并且生成的DB文件也不对：
[dave@www.cndba.cn data]$ ls
ib_buffer_pool ibdata1 ib_logfile0 ib_logfile1
[dave@www.cndba.cn data]$ ll
total 110596
-rw-r----- 1 mysql mysql 347 May 28 22:13 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 May 28 22:13 ibdata1
-rw-r----- 1 mysql mysql 50331648 May 28 22:13 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 May 28 22:13 ib_logfile1
[dave@www.cndba.cn data]$
折腾了半天，想到可能是/etc/my.cnf 参数的问题。将该文件mv 之后，恢复正常：
[dave@www.cndba.cn 3406]$ mysqld --initialize --datadir=/data/mysql/3406/data
2022-05-28T14:17:33.385137Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-05-28T14:17:33.655595Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-05-28T14:17:33.793640Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-05-28T14:17:33.861802Z 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: eadc7c4e-de90-11ec-a79a-fa163e7035c7.
2022-05-28T14:17:33.865055Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-05-28T14:17:34.751131Z 0 [Warning] CA certificate ca.pem is self signed.
2022-05-28T14:17:35.059294Z 1 [Note] A temporary password is generated for root@localhost: GeUhuPG5n=F%
[dave@www.cndba.cn 3406]$
[dave@www.cndba.cn 3406]$ cd data/
[dave@www.cndba.cn data]$ ll
total 110660
-rw-r----- 1 mysql mysql 56 May 28 22:17 auto.cnf
-rw------- 1 mysql mysql 1676 May 28 22:17 ca-key.pem
-rw-r--r-- 1 mysql mysql 1112 May 28 22:17 ca.pem
-rw-r--r-- 1 mysql mysql 1112 May 28 22:17 client-cert.pem
-rw------- 1 mysql mysql 1680 May 28 22:17 client-key.pem
-rw-r----- 1 mysql mysql 436 May 28 22:17 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 May 28 22:17 ibdata1
-rw-r----- 1 mysql mysql 50331648 May 28 22:17 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 May 28 22:17 ib_logfile1
drwxr-x--- 2 mysql mysql 4096 May 28 22:17 mysql
drwxr-x--- 2 mysql mysql 8192 May 28 22:17 performance_schema
-rw------- 1 mysql mysql 1676 May 28 22:17 private_key.pem
-rw-r--r-- 1 mysql mysql 452 May 28 22:17 public_key.pem
-rw-r--r-- 1 mysql mysql 1112 May 28 22:17 server-cert.pem
-rw------- 1 mysql mysql 1680 May 28 22:17 server-key.pem
drwxr-x--- 2 mysql mysql 8192 May 28 22:17 sys
[dave@www.cndba.cn data]$
版权声明：本文为博主原创文章，未经博主允许不得转载。
