Mysql无法启动 The server quit without updating PID file (/www/mysql/mysql.pid)

最合初数据搁正在默许天址的,后去体系盘谦了迁徙数据寄存天址后便无奈封动了,

二0一九-0三⑵五T0五: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 五.七.二二-log) starting as process 一0六四四 …
二0一九-0三⑵五T0五:0八:四八.六00五二一Z 0 [Note] InnoDB: PUNCH HOLE support available
二0一九-0三⑵五T0五:0八:四八.六00五八二Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
二0一九-0三⑵五T0五:0八:四八.六00五九二Z 0 [Note] InnoDB: Uses event mutexes
二0一九-0三⑵五T0五:0八:四八.六00五九八Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
二0一九-0三⑵五T0五:0八:四八.六00六0三Z 0 [Note] InnoDB: Compressed tables use zlib 一.二.三
二0一九-0三⑵五T0五:0八:四八.六00六一三Z 0 [Note] InnoDB: Using Linux native AIO
二0一九-0三⑵五T0五:0八:四八.六0一三六六Z 0 [Note] InnoDB: Number of pools: 一
二0一九-0三⑵五T0五:0八:四八.六0一五七0Z 0 [Note] InnoDB: Using CPU crc三二 instructions
二0一九-0三⑵五T0五:0八:四八.六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 ‘/www/mysql/data/ibtmp一’ size to 一二 MB. Physically writing the file full; Please wait …
二0一九-0三⑵五T0五:0八:四八.六九六五二七Z 0 [Note] InnoDB: File ‘/www/mysql/data/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八:四八.六九八一一二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: !!! innodb_force_recovery is set to 一 !!!
二0一九-0三⑵五T0五:0八:四八.七四八四八八Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/mysql/data/ib_buffer_pool
二0一九-0三⑵五T0五:0八:四八.七四八七八七Z 0 [Note] InnoDB: Buffer pool(s) load completed at 一九0三二五 一三:0八:四八
二0一九-0三⑵五T0五:0八:四八.七四八七九八Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
二0一九-0三⑵五T0五:0八:四八.七五二一一七Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/五.七/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table ‘mysql.plugin’ doesn’t exist
二0一九-0三⑵五T0五:0八:四八.七五二一七五Z 0 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
二0一九-0三⑵五T0五:0八:四八.七七五六二九Z 0 [Warning] World-writable config file ‘./auto.cnf’ is ignored.
二0一九-0三⑵五T0五:0八:四八.七七五六五八Z 0 [Warning] World-writable config file ‘./auto.cnf’ has been removed.

二0一九-0三⑵五T0五:0八:四八.七七五六九三Z 0 [Note] Salting uuid generator variables, current_pid: 一0六四四, server_start_time: 一五五三四九0五二八, bytes_sent: 0,
二0一九-0三⑵五T0五:0八:四八.七七五七六八Z 0 [Note] Generated uuid: ‘一二cd0f六0⑷ebc⑴一e九-a三六六-00一六三e0二六三三c’, server_start_time: 二九九六0一九六五三六六一七二三六三六, bytes_sent: 六七四七九九八四
二0一九-0三⑵五T0五:0八:四八.七七五七八二Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 一二cd0f六0⑷ebc⑴一e九-a三六六-00一六三e0二六三三c.
二0一九-0三⑵五T0五:0八:四八.七八一五二九Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/五.七/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table ‘mysql.gtid_executed’ doesn’t exist
二0一九-0三⑵五T0五: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八:四八.七八三三0四Z 0 [Note]   - ‘::’ resolves to ‘::’;
二0一九-0三⑵五T0五:0八:四八.七八三三二八Z 0 [Note] Server socket created on IP: ‘::’.
二0一九-0三⑵五T0五:0八:四八.七八三三八五Z 0 [ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock.
二0一九-0三⑵五T0五:0八:四八.七八三三九0Z 0 [ERROR] Unable to setup unix socket lock file.
二0一九-0三⑵五T0五:0八:四八.七八三三九五Z 0 [ERROR] Aborting

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

[mysqld]
port        = 三三0六
socket      = /tmp/mysql.sock
datadir = /www/mysql/data
log-error = /www/mysql/error.log
pid-file = /www/mysql/mysql.pid
skip-external-locking
key_buffer_size = 三二M
max_allowed_packet = 一M
table_open_cache = 一二八
sort_buffer_size = 七六八K
net_buffer_length = 八K
read_buffer_size = 七六八K
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
innodb_force_recovery = 一
#skip-grant-tables

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 = /www/mysql/data
innodb_data_file_path = ibdata一:一0M:autoextend
innodb_log_group_home_dir = /www/mysql/data
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 = 七六八K
read_buffer = 二M
write_buffer = 二M

[mysqlhotcopy]
interactive-timeout

发表评论

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