err file
2022-04-03T06:42:01.074860Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220403 6:42:01
2022-04-03T06:42:02.581252Z 0 [Note] InnoDB: Shutdown completed; log sequence number 31285446801
2022-04-03T06:42:02.584941Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-04-03T06:42:02.584981Z 0 [Note] Shutting down plugin 'MEMORY'
2022-04-03T06:42:02.584998Z 0 [Note] Shutting down plugin 'CSV'
2022-04-03T06:42:02.585013Z 0 [Note] Shutting down plugin 'sha256_password'
2022-04-03T06:42:02.585024Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-04-03T06:42:02.585347Z 0 [Note] Shutting down plugin 'binlog'
2022-04-03T06:42:02.586675Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
systemctl status mysqld.service Eror:
The server quit without updating PID file
logfile
2022-04-03T07:35:41.738746Z 0 [Warning] option 'max_allowed_packet': unsigned value 10737418240 adjusted to 1073741824
2022-04-03T07:35:41.738916Z 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.
2022-04-03T07:35:41.738925Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-04-03T07:35:41.738950Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-04-03T07:35:41.738973Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.31-log) starting as process 12132 ...
2022-04-03T07:35:41.783020Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-04-03T07:35:41.783071Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-03T07:35:41.783079Z 0 [Note] InnoDB: Uses event mutexes
2022-04-03T07:35:41.783086Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-04-03T07:35:41.783093Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-03T07:35:41.783471Z 0 [Note] InnoDB: Number of pools: 1
2022-04-03T07:35:41.783624Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-04-03T07:35:41.784927Z 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
2022-04-03T07:35:41.818647Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-03T07:35:41.824655Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-03T07:35:41.839559Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-03T07:35:41.958613Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-03T07:35:41.958717Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-03T07:35:42.161697Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-04-03T07:35:42.163797Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-04-03T07:35:42.163832Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-04-03T07:35:42.164671Z 0 [Note] InnoDB: Waiting for purge to start
2022-04-03T07:35:42.214955Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 31285447227
2022-04-03T07:35:42.215610Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-04-03T07:35:42.215973Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2022-04-03T07:35:42.216236Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2022-04-03T07:35:42.217216Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220403 7:35:42
2022-04-03T07:35:42.224446Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-04-03T07:35:42.224559Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-04-03T07:35:42.225947Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-03T07:35:42.226015Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-04-03T07:35:42.226191Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-04-03T07:35:42.226304Z 0 [Note] IPv6 is available.
2022-04-03T07:35:42.226327Z 0 [Note] - '::' resolves to '::';
2022-04-03T07:35:42.226367Z 0 [Note] Server socket created on IP: '::'.
2022-04-03T07:35:42.227950Z 0 [Warning] Failed to open optimizer cost constant tables
2022-04-03T07:35:42.229222Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2022-04-03T07:35:42.229269Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2022-04-03T07:35:42.229420Z 0 [ERROR] Aborting
2022-04-03T07:35:42.229509Z 0 [Note] Binlog end
2022-04-03T07:35:42.229656Z 0 [Note] Shutting down plugin 'ngram'
2022-04-03T07:35:42.229678Z 0 [Note] Shutting down plugin 'partition'
2022-04-03T07:35:42.229688Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-04-03T07:35:42.229699Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-04-03T07:35:42.229708Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-04-03T07:35:42.229817Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-04-03T07:35:42.229832Z 0 [Note] Shutting down plugin 'MyISAM'
2022-04-03T07:35:42.229876Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-04-03T07:35:42.229890Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-04-03T07:35:42.229900Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-04-03T07:35:42.229909Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-04-03T07:35:42.229918Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-04-03T07:35:42.229927Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-04-03T07:35:42.229935Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-04-03T07:35:42.229959Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-04-03T07:35:42.229970Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-04-03T07:35:42.229978Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-04-03T07:35:42.229987Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-04-03T07:35:42.229996Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-04-03T07:35:42.230004Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-04-03T07:35:42.230013Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-04-03T07:35:42.230033Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-04-03T07:35:42.230047Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-04-03T07:35:42.230056Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-04-03T07:35:42.230065Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-04-03T07:35:42.230074Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-04-03T07:35:42.230082Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-04-03T07:35:42.230091Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-04-03T07:35:42.230099Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-04-03T07:35:42.230138Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-04-03T07:35:42.230149Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-04-03T07:35:42.230159Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-04-03T07:35:42.230168Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-04-03T07:35:42.230176Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-04-03T07:35:42.230185Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-04-03T07:35:42.230194Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-04-03T07:35:42.230203Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-04-03T07:35:42.230211Z 0 [Note] Shutting down plugin 'InnoDB'
2022-04-03T07:35:42.230374Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-03T07:35:42.230556Z 0 [Note] InnoDB: Starting shutdown...
2022-04-03T07:35:42.331099Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2022-04-03T07:35:42.331464Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220403 7:35:42
2022-04-03T07:35:43.659504Z 0 [Note] InnoDB: Shutdown completed; log sequence number 31285447246
2022-04-03T07:35:43.663182Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-04-03T07:35:43.663219Z 0 [Note] Shutting down plugin 'MEMORY'
2022-04-03T07:35:43.663233Z 0 [Note] Shutting down plugin 'CSV'
2022-04-03T07:35:43.663247Z 0 [Note] Shutting down plugin 'sha256_password'
2022-04-03T07:35:43.663256Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-04-03T07:35:43.663535Z 0 [Note] Shutting down plugin 'binlog'
2022-04-03T07:35:43.668407Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete