mysql 启动报Initialization of the server's UUID failed because it could not be read from the auto.cnf

mysql启动报错

查看错误日志

 

2019-08-10T13:28:50.522771Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2019-08-10T13:28:50.523504Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2019-08-10T13:28:50.524591Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2019-08-10T13:28:50.525133Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.17-log) starting as process 9438 ... 2019-08-10T13:28:50.543141Z 0 [Note] InnoDB: PUNCH HOLE support not available 2019-08-10T13:28:50.543509Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-08-10T13:28:50.544403Z 0 [Note] InnoDB: Uses event mutexes 2019-08-10T13:28:50.544504Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2019-08-10T13:28:50.544590Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2019-08-10T13:28:50.544663Z 0 [Note] InnoDB: Using Linux native AIO 2019-08-10T13:28:50.545758Z 0 [Note] InnoDB: Number of pools: 1 2019-08-10T13:28:50.546309Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-08-10T13:28:50.553931Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-08-10T13:28:50.580544Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-08-10T13:28:50.589956Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-08-10T13:28:50.606495Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-08-10T13:28:50.641073Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-08-10T13:28:50.641503Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-08-10T13:28:50.663682Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-08-10T13:28:50.666438Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-08-10T13:28:50.666539Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-08-10T13:28:50.668088Z 0 [Note] InnoDB: Waiting for purge to start 2019-08-10T13:28:50.718743Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2534880 2019-08-10T13:28:50.720601Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-08-10T13:28:50.737946Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool 2019-08-10T13:28:50.745318Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190810 21:28:50 2019-08-10T13:28:50.749026Z 0 [ERROR] Garbage characters found at the end of the server_uuid value in auto.cnf file. It should be of length '36' (UUID_LENGTH). Clear it and restart the server.  2019-08-10T13:28:50.749136Z 0 [ERROR] Initialization of the server's UUID failed because it could not be read from the auto.cnf file. If this is a new server, the initialization failed because it was not possible to generate a new UUID. 2019-08-10T13:28:50.749219Z 0 [ERROR] Aborting

主要原因是auto.cnf的位数和值不相同造成的。

auto.cnf有2个位置

 

 

这2个文件中slave必须相同

 而且uuid的位置不能多也不能少必须是36位