当前位置:论坛首页 > Linux面板 > 求助

MySQL AliSQL 编译安装是错误的 快速安装是可以的 错误日志...

发表在 Linux面板2018-5-2 23:29 [复制链接] 6 3209

180502 23:10:43 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2018-05-02 23:10:43 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2018-05-02 23:10:43 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.6.32-log) starting as process 29004 ...
2018-05-02 23:10:43 29004 [Note] Plugin 'FEDERATED' is disabled.
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
2018-05-02 23:10:43 29004 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:10:43 29004 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-05-02 23:10:43 29004 [Note] InnoDB: The InnoDB memory heap is disabled
2018-05-02 23:10:43 29004 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-02 23:10:43 29004 [Note] InnoDB: Memory barrier is not used
2018-05-02 23:10:43 29004 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-02 23:10:43 29004 [Note] InnoDB: Using Linux native AIO
2018-05-02 23:10:43 29004 [Note] InnoDB: Using CPU crc32 instructions
2018-05-02 23:10:43 29004 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-05-02 23:10:43 29004 [Note] InnoDB: Completed initialization of buffer pool
2018-05-02 23:10:43 29004 [Note] InnoDB: The first specified data file /www/server/data/ibdata1 did not exist: a new database to be created!
2018-05-02 23:10:43 29004 [Note] InnoDB: Setting file /www/server/data/ibdata1 size to 10 MB
2018-05-02 23:10:43 29004 [Note] InnoDB: Database physically writes the file full: wait...
2018-05-02 23:10:43 29004 [Note] InnoDB: Setting log file /www/server/data/ib_logfile101 size to 32 MB
2018-05-02 23:10:44 29004 [Note] InnoDB: Setting log file /www/server/data/ib_logfile1 size to 32 MB
2018-05-02 23:10:44 29004 [Note] InnoDB: Renaming log file /www/server/data/ib_logfile101 to /www/server/data/ib_logfile0
2018-05-02 23:10:44 29004 [Warning] InnoDB: New log files created, LSN=45781
2018-05-02 23:10:44 29004 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-05-02 23:10:44 29004 [Note] InnoDB: Doublewrite buffer created
2018-05-02 23:10:46 29004 [Note] InnoDB: 128 rollback segment(s) are active.
2018-05-02 23:10:46 29004 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-05-02 23:10:46 29004 [Note] InnoDB: Foreign key constraint system tables created
2018-05-02 23:10:46 29004 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-05-02 23:10:46 29004 [Note] InnoDB: Tablespace and datafile system tables created.
2018-05-02 23:10:46 29004 [Note] InnoDB: Waiting for purge to start
2018-05-02 23:10:46 29004 [Note] InnoDB: 5.6.32 started; log sequence number 0
2018-05-02 23:10:46 29004 [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: fd5bad0d-4e1a-11e8-9ad6-00163e046ace.
2018-05-02 23:10:46 29004 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-02 23:10:46 29004 [Note] IPv6 is available.
2018-05-02 23:10:46 29004 [Note]   - '::' resolves to '::';
2018-05-02 23:10:46 29004 [Note] Server socket created on IP: '::'.
2018-05-02 23:10:46 29004 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
180502 23:10:46 mysqld_safe mysqld from pid file /www/server/data/iZuf6fuxiq5o2qfaukmwibZ.pid ended
180502 23:10:48 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2018-05-02 23:10:48 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2018-05-02 23:10:48 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.6.32-log) starting as process 29718 ...



使用道具 举报 只看该作者 回复
发表于 2018-5-2 23:30:05 | 显示全部楼层
2018-05-02 23:10:48 29718 [Note] Plugin 'FEDERATED' is disabled.

/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist

2018-05-02 23:10:48 29718 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2018-05-02 23:10:48 29718 [Note] InnoDB: Using atomics to ref count buffer pool pages

2018-05-02 23:10:48 29718 [Note] InnoDB: The InnoDB memory heap is disabled

2018-05-02 23:10:48 29718 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-02 23:10:48 29718 [Note] InnoDB: Memory barrier is not used

2018-05-02 23:10:48 29718 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-05-02 23:10:48 29718 [Note] InnoDB: Using Linux native AIO

2018-05-02 23:10:48 29718 [Note] InnoDB: Using CPU crc32 instructions

2018-05-02 23:10:48 29718 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2018-05-02 23:10:48 29718 [Note] InnoDB: Completed initialization of buffer pool

2018-05-02 23:10:48 29718 [Note] InnoDB: Highest supported file format is Barracuda.

2018-05-02 23:10:48 29718 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463

2018-05-02 23:10:48 29718 [Note] InnoDB: Database was not shutdown normally!

2018-05-02 23:10:48 29718 [Note] InnoDB: Starting crash recovery.

2018-05-02 23:10:48 29718 [Note] InnoDB: Reading tablespace information from the .ibd files...

2018-05-02 23:10:48 29718 [Note] InnoDB: Restoring possible half-written data pages

2018-05-02 23:10:48 29718 [Note] InnoDB: from the doublewrite buffer...

InnoDB: Doing recovery: scanned up to log sequence number 1600614

2018-05-02 23:10:48 29718 [Note] InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percent: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

2018-05-02 23:10:49 29718 [Note] InnoDB: 128 rollback segment(s) are active.

2018-05-02 23:10:49 29718 [Note] InnoDB: Waiting for purge to start

2018-05-02 23:10:49 29718 [Note] InnoDB: 5.6.32 started; log sequence number 1600614

2018-05-02 23:10:49 29718 [Note] Recovering after a crash using mysql-bin

2018-05-02 23:10:49 29718 [Note] Starting crash recovery...

2018-05-02 23:10:49 29718 [Note] Crash recovery finished.

2018-05-02 23:10:49 29718 [Note] Server hostname (bind-address): '*'; port: 3306

2018-05-02 23:10:49 29718 [Note] IPv6 is available.

2018-05-02 23:10:49 29718 [Note]   - '::' resolves to '::';

2018-05-02 23:10:49 29718 [Note] Server socket created on IP: '::'.

2018-05-02 23:10:49 29718 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

180502 23:10:49 mysqld_safe mysqld from pid file /www/server/data/iZuf6fuxiq5o2qfaukmwibZ.pid ended

180502 23:10:50 mysqld_safe Starting mysqld daemon with databases from /www/server/data

2018-05-02 23:10:50 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824

2018-05-02 23:10:50 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.6.32-log) starting as process 30357 ...

2018-05-02 23:10:50 30357 [Note] Plugin 'FEDERATED' is disabled.

2018-05-02 23:10:50 30357 [Note] InnoDB: Using atomics to ref count buffer pool pages

2018-05-02 23:10:50 30357 [Note] InnoDB: The InnoDB memory heap is disabled

2018-05-02 23:10:50 30357 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-02 23:10:50 30357 [Note] InnoDB: Memory barrier is not used

2018-05-02 23:10:50 30357 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-05-02 23:10:50 30357 [Note] InnoDB: Using Linux native AIO

2018-05-02 23:10:50 30357 [Note] InnoDB: Using CPU crc32 instructions

2018-05-02 23:10:50 30357 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2018-05-02 23:10:50 30357 [Note] InnoDB: Completed initialization of buffer pool

2018-05-02 23:10:50 30357 [Note] InnoDB: Highest supported file format is Barracuda.

2018-05-02 23:10:50 30357 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463

2018-05-02 23:10:50 30357 [Note] InnoDB: Database was not shutdown normally!

2018-05-02 23:10:50 30357 [Note] InnoDB: Starting crash recovery.

2018-05-02 23:10:50 30357 [Note] InnoDB: Reading tablespace information from the .ibd files...

2018-05-02 23:10:50 30357 [Note] InnoDB: Restoring possible half-written data pages

2018-05-02 23:10:50 30357 [Note] InnoDB: from the doublewrite buffer...

InnoDB: Doing recovery: scanned up to log sequence number 1600614

2018-05-02 23:10:50 30357 [Note] InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percent: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

2018-05-02 23:10:51 30357 [Note] InnoDB: 128 rollback segment(s) are active.

2018-05-02 23:10:51 30357 [Note] InnoDB: Waiting for purge to start

2018-05-02 23:10:51 30357 [Note] InnoDB: 5.6.32 started; log sequence number 1600614

2018-05-02 23:10:51 30357 [Note] Recovering after a crash using mysql-bin

2018-05-02 23:10:51 30357 [Note] Starting crash recovery...

2018-05-02 23:10:51 30357 [Note] Crash recovery finished.

2018-05-02 23:10:51 30357 [Note] Server hostname (bind-address): '*'; port: 3306

2018-05-02 23:10:51 30357 [Note] IPv6 is available.

2018-05-02 23:10:51 30357 [Note]   - '::' resolves to '::';

2018-05-02 23:10:51 30357 [Note] Server socket created on IP: '::'.

2018-05-02 23:10:51 30357 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them

2018-05-02 23:10:51 30357 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

2018-05-02 23:10:51 30357 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.

2018-05-02 23:10:51 30357 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure



使用道具 举报 回复 支持 反对
发表于 2018-5-2 23:30:27 | 显示全部楼层
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'users' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

2018-05-02 23:10:51 30357 [Note] [RDS Diagnose] /www/server/mysql/bin/mysqld is using 'system jemalloc' malloc library

2018-05-02 23:10:51 30357 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.6.32-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

2018-05-02 23:10:56 30357 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

2018-05-02 23:10:56 30357 [ERROR] Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

180502 23:10:58 mysqld_safe Starting mysqld daemon with databases from /www/server/data

2018-05-02 23:10:58 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure

2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2018-05-02 23:10:58 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.6.32-log) starting as process 31031 ...

2018-05-02 23:10:58 31031 [Note] Plugin 'FEDERATED' is disabled.

/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist

2018-05-02 23:10:58 31031 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2018-05-02 23:10:58 31031 [Note] InnoDB: Using atomics to ref count buffer pool pages

2018-05-02 23:10:58 31031 [Note] InnoDB: The InnoDB memory heap is disabled

2018-05-02 23:10:58 31031 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-02 23:10:58 31031 [Note] InnoDB: Memory barrier is not used

2018-05-02 23:10:58 31031 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-05-02 23:10:58 31031 [Note] InnoDB: Using Linux native AIO

2018-05-02 23:10:58 31031 [Note] InnoDB: Using CPU crc32 instructions

2018-05-02 23:10:58 31031 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2018-05-02 23:10:58 31031 [Note] InnoDB: Completed initialization of buffer pool

2018-05-02 23:10:58 31031 [Note] InnoDB: Highest supported file format is Barracuda.

2018-05-02 23:10:58 31031 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600624 in the ib_logfiles!

2018-05-02 23:10:58 31031 [Note] InnoDB: Database was not shutdown normally!

2018-05-02 23:10:58 31031 [Note] InnoDB: Starting crash recovery.

2018-05-02 23:10:58 31031 [Note] InnoDB: Reading tablespace information from the .ibd files...

2018-05-02 23:10:58 31031 [Note] InnoDB: Restoring possible half-written data pages

2018-05-02 23:10:58 31031 [Note] InnoDB: from the doublewrite buffer...

2018-05-02 23:10:59 31031 [Note] InnoDB: 128 rollback segment(s) are active.

2018-05-02 23:10:59 31031 [Note] InnoDB: Waiting for purge to start

2018-05-02 23:10:59 31031 [Note] InnoDB: 5.6.32 started; log sequence number 1600624

2018-05-02 23:10:59 31031 [Note] Recovering after a crash using mysql-bin

2018-05-02 23:10:59 31031 [Note] Starting crash recovery...

2018-05-02 23:10:59 31031 [Note] Crash recovery finished.

2018-05-02 23:10:59 31031 [Note] Server hostname (bind-address): '*'; port: 3306

2018-05-02 23:10:59 31031 [Note] IPv6 is available.

2018-05-02 23:10:59 31031 [Note]   - '::' resolves to '::';

2018-05-02 23:10:59 31031 [Note] Server socket created on IP: '::'.

2018-05-02 23:10:59 31031 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

180502 23:10:59 mysqld_safe mysqld from pid file /www/server/data/iZuf6fuxiq5o2qfaukmwibZ.pid ended
使用道具 举报 回复 支持 反对
发表于 2018-5-2 23:31:47 | 显示全部楼层
慢日志:
/www/server/mysql/bin/mysqld, Version: 5.6.32-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.6.32-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.6.32-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.6.32-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
使用道具 举报 回复 支持 反对
发表于 2018-5-2 23:32:24 | 显示全部楼层
编译安装永远是错误的 快速安装就是正常的
使用道具 举报 回复 支持 反对
发表于 2018-5-2 23:36:33 | 显示全部楼层
2018-05-02 23:35:19 (539 KB/s) - ‘sql-repair.sh’ saved [19399/19399]

MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.The server quit without updating PID file (/[FAILED]er/data/iZuf6fuxiq5o2qfaukmwibZ.pid).
==========================================================================================
2018-05-02 23:10:43 29004 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:10:46 29004 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:10:48 29718 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:10:49 29718 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:10:51 30357 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2018-05-02 23:10:51 30357 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2018-05-02 23:10:56 30357 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:10:56 30357 [ERROR] Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:10:58 31031 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:10:59 31031 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:32:33 15317 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:32:33 15317 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:33:05 16212 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:33:05 16212 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:33:31 17108 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:33:32 17108 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-05-02 23:35:19 18646 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-05-02 23:35:19 18646 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2018-05-02 23:35:19 18646 [ERROR] Plugin 'InnoDB' init function returned error.
2018-05-02 23:35:19 18646 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-05-02 23:35:19 18646 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-05-02 23:35:19 18646 [ERROR] Aborting
==========================================================================================
mysql start error.
mysql无法正常启动,请将以上错误信息截图发至论坛寻求帮助
使用道具 举报 回复 支持 反对
发表于 2018-5-2 23:37:31 | 显示全部楼层
执行 wget -O sql-repair.sh http://download.bt.cn/install/sql-repair.sh && sh sql-repair.sh  是上面的提示

全新的主机 全新安装 选编译安装
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表