/ var/log/mysqld.log 的日志
@
neighbads 不知道你指的是不是这个?
180415 10:39:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180415 10:49:22 mysqld_safe Logging to '/var/log/mysqld.log'.
180415 10:49:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180415 10:49:22 [Note] /usr/sbin/mysqld (mysqld 5.5.59) starting as process 13415 ...
180415 10:49:22 [Note] Plugin 'FEDERATED' is disabled.
180415 10:49:22 InnoDB: The InnoDB memory heap is disabled
180415 10:49:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180415 10:49:22 InnoDB: Compressed tables use zlib 1.2.3
180415 10:49:22 InnoDB: Using Linux native AIO
180415 10:49:22 InnoDB: Initializing buffer pool, size = 128.0M
180415 10:49:22 InnoDB: Completed initialization of buffer pool
180415 10:49:22 InnoDB: highest supported file format is Barracuda.
180415 10:49:22 InnoDB: Waiting for the background threads to start
180415 10:49:23 InnoDB: 5.5.59 started; log sequence number 1597945
180415 10:49:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180415 10:49:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180415 10:49:23 [Note] Server socket created on IP: '0.0.0.0'.
180415 10:49:23 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
180415 10:49:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
180415 10:49:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.59' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)