急！！！The server quit without updating PID file (/usr/local/mysql/var/localhost.lo

张卫星

2018-09-21T08:56:02.276035Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-09-21T08:56:02.276161Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.22) starting as process 30237 ...
2018-09-21T08:56:02.306404Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2018-09-21T08:56:02.319543Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-09-21T08:56:02.319581Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-21T08:56:02.319585Z 0 [Note] InnoDB: Uses event mutexes
2018-09-21T08:56:02.319588Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-09-21T08:56:02.319593Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-21T08:56:02.319596Z 0 [Note] InnoDB: Using Linux native AIO
2018-09-21T08:56:02.320071Z 0 [Note] InnoDB: Number of pools: 1
2018-09-21T08:56:02.320194Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-09-21T08:56:02.322141Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2018-09-21T08:56:02.362613Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-09-21T08:56:02.370168Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-09-21T08:56:02.382272Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-21T08:56:02.421868Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-09-21T08:56:02.421957Z 0 [Note] InnoDB: Setting file '/usr/local/mysql/var/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-09-21T08:56:02.515258Z 0 [Note] InnoDB: File '/usr/local/mysql/var/ibtmp1' size is now 12 MB.
2018-09-21T08:56:02.516658Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-09-21T08:56:02.516669Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-09-21T08:56:02.518087Z 0 [Note] InnoDB: Waiting for purge to start
2018-09-21T08:56:02.568288Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 26274415
2018-09-21T08:56:02.568648Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/var/ib_buffer_pool
2018-09-21T08:56:02.568818Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2018-09-21T08:56:02.569020Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-09-21T08:56:02.569271Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180921 16:56:02
2018-09-21T08:56:02.569605Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-09-21T08:56:02.569670Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-09-21T08:56:02.569679Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-09-21T08:56:02.569716Z 0 [Note] IPv6 is available.
2018-09-21T08:56:02.569744Z 0 [Note]   - '::' resolves to '::';
2018-09-21T08:56:02.569824Z 0 [Note] Server socket created on IP: '::'.
2018-09-21T08:56:02.590677Z 0 [Warning] Failed to open optimizer cost constant tables

2018-09-21T08:56:02.591045Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-09-21T08:56:02.591140Z 0 [ERROR] Aborting

2018-09-21T08:56:02.591183Z 0 [Note] Binlog end
2018-09-21T08:56:02.591238Z 0 [Note] Shutting down plugin 'ngram'
2018-09-21T08:56:02.591246Z 0 [Note] Shutting down plugin 'partition'
2018-09-21T08:56:02.591250Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-09-21T08:56:02.591254Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-09-21T08:56:02.591258Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-09-21T08:56:02.591353Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-09-21T08:56:02.591360Z 0 [Note] Shutting down plugin 'MyISAM'
2018-09-21T08:56:02.591388Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-09-21T08:56:02.591393Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-09-21T08:56:02.591397Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-09-21T08:56:02.591408Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-09-21T08:56:02.591412Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-09-21T08:56:02.591415Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-09-21T08:56:02.591418Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

张卫星

接上面
2018-09-21T08:56:02.591415Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-09-21T08:56:02.591418Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-09-21T08:56:02.591422Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-09-21T08:56:02.591425Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-09-21T08:56:02.591428Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-09-21T08:56:02.591431Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-09-21T08:56:02.591435Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-09-21T08:56:02.591438Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-09-21T08:56:02.591441Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-09-21T08:56:02.591445Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-09-21T08:56:02.591449Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-09-21T08:56:02.591453Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-09-21T08:56:02.591457Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-09-21T08:56:02.591461Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-09-21T08:56:02.591465Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-09-21T08:56:02.591469Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-09-21T08:56:02.591472Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-09-21T08:56:02.591476Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-09-21T08:56:02.591480Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-09-21T08:56:02.591484Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-09-21T08:56:02.591487Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-09-21T08:56:02.591491Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-09-21T08:56:02.591495Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-09-21T08:56:02.591499Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-09-21T08:56:02.591503Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-09-21T08:56:02.591506Z 0 [Note] Shutting down plugin 'InnoDB'
2018-09-21T08:56:02.591662Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-09-21T08:56:02.591825Z 0 [Note] InnoDB: Starting shutdown...
2018-09-21T08:56:02.692107Z 0 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/var/ib_buffer_pool
2018-09-21T08:56:02.692410Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180921 16:56:02
2018-09-21T08:56:04.223983Z 0 [Note] InnoDB: Shutdown completed; log sequence number 26274434
2018-09-21T08:56:04.226419Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-09-21T08:56:04.226431Z 0 [Note] Shutting down plugin 'MEMORY'
2018-09-21T08:56:04.226438Z 0 [Note] Shutting down plugin 'CSV'
2018-09-21T08:56:04.226442Z 0 [Note] Shutting down plugin 'sha256_password'
2018-09-21T08:56:04.226444Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-09-21T08:56:04.226593Z 0 [Note] Shutting down plugin 'binlog'
2018-09-21T08:56:04.226630Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

张卫星

my.cnf

[client]
#password   = your_password
port        = 3306
socket      = /tmp/mysql.sock

[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 32M
thread_cache_size = 64
query_cache_size = 64M
tmp_table_size = 64M
performance_schema_max_table_instances = 4000

explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

#log-bin=mysql-bin
binlog_format=mixed
server-id   = 1
expire_logs_days = 10
early-plugin-load = ""

default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
[client]
#password   = your_password
port        = 3306
socket      = /tmp/mysql.sock

[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 32M
thread_cache_size = 64
query_cache_size = 64M
tmp_table_size = 64M
performance_schema_max_table_instances = 4000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

#log-bin=mysql-bin
binlog_format=mixed
server-id   = 1
expire_logs_days = 10
early-plugin-load = ""

default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
innodb_buffer_pool_size = 512M
innodb_log_file_size = 128M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 2M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
malloc-lib=/usr/lib/libjemalloc.so

licess

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

mysql数据库表丢失或者数据库目录权限有问题