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

二0一八-0九⑵一T0八:五六:0二.二七六0三五Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
二0一八-0九⑵一T0八:五六:0二.二七六一六一Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 五.七.二二) starting as process 三0二三七 …
二0一八-0九⑵一T0八:五六:0二.三0六四0四Z 0 [Warning] You need to use –log-bin to make –binlog-format work.
二0一八-0九⑵一T0八:五六:0二.三一九五四三Z 0 [Note] InnoDB: PUNCH HOLE support available
二0一八-0九⑵一T0八:五六:0二.三一九五八一Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
二0一八-0九⑵一T0八:五六:0二.三一九五八五Z 0 [Note] InnoDB: Uses event mutexes
二0一八-0九⑵一T0八:五六:0二.三一九五八八Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
二0一八-0九⑵一T0八:五六:0二.三一九五九三Z 0 [Note] InnoDB: Compressed tables use zlib 一.二.三
二0一八-0九⑵一T0八:五六:0二.三一九五九六Z 0 [Note] InnoDB: Using Linux native AIO
二0一八-0九⑵一T0八:五六:0二.三二00七一Z 0 [Note] InnoDB: Number of pools: 一
二0一八-0九⑵一T0八:五六:0二.三二0一九四Z 0 [Note] InnoDB: Using CPU crc三二 instructions
二0一八-0九⑵一T0八:五六:0二.三二二一四一Z 0 [Note] InnoDB: Initializing buffer pool, total size = 五一二M, instances = 一, chunk size = 一二八M
二0一八-0九⑵一T0八:五六:0二.三六二六一三Z 0 [Note] InnoDB: Completed initialization of buffer pool
二0一八-0九⑵一T0八:五六:0二.三七0一六八Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
二0一八-0九⑵一T0八:五六:0二.三八二二七二Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
二0一八-0九⑵一T0八:五六:0二.四二一八六八Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
二0一八-0九⑵一T0八:五六:0二.四二一九五七Z 0 [Note] InnoDB: Setting file ‘/usr/local/mysql/var/ibtmp一’ size to 一二 MB. Physically writing the file full; Please wait …
二0一八-0九⑵一T0八:五六:0二.五一五二五八Z 0 [Note] InnoDB: File ‘/usr/local/mysql/var/ibtmp一’ size is now 一二 MB.
二0一八-0九⑵一T0八:五六:0二.五一六六五八Z 0 [Note] InnoDB: 九六 redo rollback segment(s) found. 九六 redo rollback segment(s) are active.
二0一八-0九⑵一T0八:五六:0二.五一六六六九Z 0 [Note] InnoDB: 三二 non-redo rollback segment(s) are active.
二0一八-0九⑵一T0八:五六:0二.五一八0八七Z 0 [Note] InnoDB: Waiting for purge to start
二0一八-0九⑵一T0八:五六:0二.五六八二八八Z 0 [Note] InnoDB: 五.七.二二 started; log sequence number 二六二七四四一五
二0一八-0九⑵一T0八:五六:0二.五六八六四八Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/var/ib_buffer_pool
二0一八-0九⑵一T0八:五六:0二.五六八八一八Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
mysqld: Table ‘mysql.plugin’ doesn’t exist
二0一八-0九⑵一T0八:五六:0二.五六九0二0Z 0 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
二0一八-0九⑵一T0八:五六:0二.五六九二七一Z 0 [Note] InnoDB: Buffer pool(s) load completed at 一八0九二一 一六:五六:0二
二0一八-0九⑵一T0八:五六:0二.五六九六0五Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
二0一八-0九⑵一T0八:五六:0二.五六九六七0Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
二0一八-0九⑵一T0八:五六:0二.五六九六七九Z 0 [Note] Server hostname (bind-address): ‘*’; port: 三三0六
二0一八-0九⑵一T0八:五六:0二.五六九七一六Z 0 [Note] IPv六 is available.
二0一八-0九⑵一T0八:五六:0二.五六九七四四Z 0 [Note]   - ‘::’ resolves to ‘::’;
二0一八-0九⑵一T0八:五六:0二.五六九八二四Z 0 [Note] Server socket created on IP: ‘::’.
二0一八-0九⑵一T0八:五六:0二.五九0六七七Z 0 [Warning] Failed to open optimizer cost constant tables

二0一八-0九⑵一T0八:五六:0二.五九一0四五Z 0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
二0一八-0九⑵一T0八:五六:0二.五九一一四0Z 0 [ERROR] Aborting

二0一八-0九⑵一T0八:五六:0二.五九一一八三Z 0 [Note] Binlog end
二0一八-0九⑵一T0八:五六:0二.五九一二三八Z 0 [Note] Shutting down plugin ‘ngram’
二0一八-0九⑵一T0八:五六:0二.五九一二四六Z 0 [Note] Shutting down plugin ‘partition’
二0一八-0九⑵一T0八:五六:0二.五九一二五0Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
二0一八-0九⑵一T0八:五六:0二.五九一二五四Z 0 [Note] Shutting down plugin ‘ARCHIVE’
二0一八-0九⑵一T0八:五六:0二.五九一二五八Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
二0一八-0九⑵一T0八:五六:0二.五九一三五三Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
二0一八-0九⑵一T0八:五六:0二.五九一三六0Z 0 [Note] Shutting down plugin ‘MyISAM’
二0一八-0九⑵一T0八:五六:0二.五九一三八八Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
二0一八-0九⑵一T0八:五六:0二.五九一三九三Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
二0一八-0九⑵一T0八:五六:0二.五九一三九七Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
二0一八-0九⑵一T0八:五六:0二.五九一四0八Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
二0一八-0九⑵一T0八:五六:0二.五九一四一二Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
二0一八-0九⑵一T0八:五六:0二.五九一四一五Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
二0一八-0九⑵一T0八:五六:0二.五九一四一八Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’《哈稀网友》:接下面
二0一八-0九⑵一T0八:五六:0二.五九一四一五Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
二0一八-0九⑵一T0八:五六:0二.五九一四一八Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
二0一八-0九⑵一T0八:五六:0二.五九一四二二Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
二0一八-0九⑵一T0八:五六:0二.五九一四二五Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
二0一八-0九⑵一T0八:五六:0二.五九一四二八Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
二0一八-0九⑵一T0八:五六:0二.五九一四三一Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
二0一八-0九⑵一T0八:五六:0二.五九一四三五Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
二0一八-0九⑵一T0八:五六:0二.五九一四三八Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
二0一八-0九⑵一T0八:五六:0二.五九一四四一Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
二0一八-0九⑵一T0八:五六:0二.五九一四四五Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
二0一八-0九⑵一T0八:五六:0二.五九一四四九Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
二0一八-0九⑵一T0八:五六:0二.五九一四五三Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
二0一八-0九⑵一T0八:五六:0二.五九一四五七Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
二0一八-0九⑵一T0八:五六:0二.五九一四六一Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
二0一八-0九⑵一T0八:五六:0二.五九一四六五Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
二0一八-0九⑵一T0八:五六:0二.五九一四六九Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
二0一八-0九⑵一T0八:五六:0二.五九一四七二Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
二0一八-0九⑵一T0八:五六:0二.五九一四七六Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
二0一八-0九⑵一T0八:五六:0二.五九一四八0Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
二0一八-0九⑵一T0八:五六:0二.五九一四八四Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
二0一八-0九⑵一T0八:五六:0二.五九一四八七Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
二0一八-0九⑵一T0八:五六:0二.五九一四九一Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
二0一八-0九⑵一T0八:五六:0二.五九一四九五Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
二0一八-0九⑵一T0八:五六:0二.五九一四九九Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
二0一八-0九⑵一T0八:五六:0二.五九一五0三Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
二0一八-0九⑵一T0八:五六:0二.五九一五0六Z 0 [Note] Shutting down plugin ‘InnoDB’
二0一八-0九⑵一T0八:五六:0二.五九一六六二Z 0 [Note] InnoDB: FTS optimize thread exiting.
二0一八-0九⑵一T0八:五六:0二.五九一八二五Z 0 [Note] InnoDB: Starting shutdown…
二0一八-0九⑵一T0八:五六:0二.六九二一0七Z 0 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/var/ib_buffer_pool
二0一八-0九⑵一T0八:五六:0二.六九二四一0Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 一八0九二一 一六:五六:0二
二0一八-0九⑵一T0八:五六:0四.二二三九八三Z 0 [Note] InnoDB: Shutdown completed; log sequence number 二六二七四四三四
二0一八-0九⑵一T0八:五六:0四.二二六四一九Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp一"
二0一八-0九⑵一T0八:五六:0四.二二六四三一Z 0 [Note] Shutting down plugin ‘MEMORY’
二0一八-0九⑵一T0八:五六:0四.二二六四三八Z 0 [Note] Shutting down plugin ‘CSV’
二0一八-0九⑵一T0八:五六:0四.二二六四四二Z 0 [Note] Shutting down plugin ‘sha二五六_password’
二0一八-0九⑵一T0八:五六:0四.二二六四四四Z 0 [Note] Shutting down plugin ‘mysql_native_password’
二0一八-0九⑵一T0八:五六:0四.二二六五九三Z 0 [Note] Shutting down plugin ‘binlog’
二0一八-0九⑵一T0八:五六:0四.二二六六三0Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
《廊坊网友》:my.cnf

[client]
#password   = your_password
port        = 三三0六
socket      = /tmp/mysql.sock

[mysqld]
port        = 三三0六
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 一二八M
max_allowed_packet = 一M
table_open_cache = 五一二
sort_buffer_size = 二M
net_buffer_length = 八K
read_buffer_size = 二M
read_rnd_buffer_size = 五一二K
myisam_sort_buffer_size = 三二M
thread_cache_size = 六四
query_cache_size = 六四M
tmp_table_size = 六四M
performance_schema_max_table_instances = 四000

explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 五00
max_connect_errors = 一00
open_files_limit = 六五五三五

#log-bin=mysql-bin
binlog_format=mixed
server-id   = 一
expire_logs_days = 一0
early-plugin-load = ""

default_storage_engine = InnoDB
innodb_file_per_table = 一
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata一:一0M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
[client]
#password   = your_password
port        = 三三0六
socket      = /tmp/mysql.sock

[mysqld]
port        = 三三0六
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 一二八M
max_allowed_packet = 一M
table_open_cache = 五一二
sort_buffer_size = 二M
net_buffer_length = 八K
read_buffer_size = 二M
read_rnd_buffer_size = 五一二K
myisam_sort_buffer_size = 三二M
thread_cache_size = 六四
query_cache_size = 六四M
tmp_table_size = 六四M
performance_schema_max_table_instances = 四000
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 = 五00
max_connect_errors = 一00
open_files_limit = 六五五三五

#log-bin=mysql-bin
binlog_format=mixed
server-id   = 一
expire_logs_days = 一0
early-plugin-load = ""

default_storage_engine = InnoDB
innodb_file_per_table = 一
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata一:一0M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
innodb_buffer_pool_size = 五一二M
innodb_log_file_size = 一二八M
innodb_log_buffer_size = 八M
innodb_flush_log_at_trx_co妹妹it = 一
innodb_lock_wait_timeout = 五0

[mysqldump]
quick
max_allowed_packet = 一六M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 一二八M
sort_buffer_size = 二M
read_buffer = 二M
write_buffer = 二M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
malloc-lib=/usr/lib/libjemalloc.so
《佛山网友》:[ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.

mysql数据库表拾得或者者数据库目次权限有答题

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注