MariaDb 升级后所有用户访问被拒绝

MariaDb 升级后所有用户访问被拒绝

今天早上我发现,MariaDb在从 FreeBSD 10.3 升级到 11.1 的过程中,该库已被从我的服务器中删除。在重新安装数据库引擎并解决my.cnf不兼容问题后,我终于可以MariaDb工作了——但现在每一个用户(非 root)被拒绝访问其数据库。

我尝试为随机用户重置密码,但没有任何作用。

server.err关于这里出了什么问题的有用信息在哪里?这是重新启动数据库后的所有信息:

2018-03-10 11:45:00 34424848384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Uses event mutexes
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Number of pools: 1
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Using SSE2 crc32 instructions
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Completed initialization of buffer pool
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-10 11:45:00 34424848384 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: 5.7.21 started; log sequence number 25246709
2018-03-10 11:45:00 37094309376 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2018-03-10 11:45:00 34424848384 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-10 11:45:00 37094309376 [Note] InnoDB: Buffer pool(s) load completed at 180310 11:45:00
2018-03-10 11:45:00 34424848384 [Note] Server socket created on IP: '::'.
2018-03-10 11:45:00 34424848384 [Note] Reading of all Master_info entries succeded
2018-03-10 11:45:00 34424848384 [Note] Added new Master_info '' to hash table
2018-03-10 11:45:00 34424848384 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.2.13-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD Ports
2018-03-10 11:45:12 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)
2018-03-10 11:45:17 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)
2018-03-10 11:46:27 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)

在我开始升级 FreeBSD 之前,这是一个可以正常工作的服务器。我没有做任何事情来更改任何数据库或文件的权限,事实上,我唯一做的事情做过改变的是操作系统和数据库引擎——我会预期的对数据透明的“升级”!


编辑

我检查了输出mysql_upgrade,发现有很多与系統数据库。我不知道这些是否相关,或者我可以或应该对它们做什么:

Phase 3/7: Fixing views from mysql
sys.host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
status   : Operation failed
sys.host_summary_by_file_io
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.host_summary_by_file_io_type
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.host_summary_by_stages
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.host_summary_by_statement_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.host_summary_by_statement_type
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.innodb_buffer_stats_by_schema
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.innodb_buffer_stats_by_table
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.innodb_lock_waits
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.io_by_thread_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.io_global_by_file_by_bytes
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.io_global_by_file_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.io_global_by_wait_by_bytes
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.io_global_by_wait_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.latest_file_io
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.memory_by_host_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.memory_by_thread_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
status   : Operation failed
sys.memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
status   : Operation failed
sys.memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
status   : Operation failed
sys.memory_global_total
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.metrics
Error    : Table 'performance_schema.global_status' doesn't exist
status   : Operation failed
sys.processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
status   : Operation failed
sys.ps_check_lost_instrumentation
Error    : Table 'performance_schema.global_status' doesn't exist
Error    : View 'sys.ps_check_lost_instrumentation' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.schema_index_statistics
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.schema_table_lock_waits
Error    : Table 'performance_schema.metadata_locks' doesn't exist
status   : Operation failed
sys.schema_table_statistics
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.schema_table_statistics_with_buffer
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.schema_tables_with_full_table_scans
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.session
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.session_ssl_status
Error    : Table 'performance_schema.status_by_thread' doesn't exist
status   : Operation failed
sys.statement_analysis
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.statements_with_errors_or_warnings
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.statements_with_full_table_scans
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.statements_with_runtimes_in_95th_percentile
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.statements_with_sorting
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.statements_with_temp_tables
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.user_summary
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.user_summary_by_file_io
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.user_summary_by_file_io_type
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.user_summary_by_stages
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.user_summary_by_statement_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.user_summary_by_statement_type
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.wait_classes_global_by_avg_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.wait_classes_global_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.waits_by_host_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.waits_by_user_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.waits_global_by_latency
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.x$host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.x$host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$memory_by_host_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$memory_by_thread_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.x$memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$memory_global_total
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.x$memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.x$processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$ps_schema_table_statistics_io
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.x$schema_table_lock_waits
Error    : Table 'performance_schema.metadata_locks' doesn't exist
Error    : View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$schema_table_statistics
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.x$schema_table_statistics_with_buffer
Error    : Cannot load from mysql.proc. The table is probably corrupted
Error    : Corrupt
sys.x$session
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.x$session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt
sys.x$user_summary
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.x$user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error    : Corrupt

编辑2

注意:在这两个编辑中,“OK”表都被删除了,以减少问题中文本的大小。

我再次重新运行mysql_upgrade,因为我找到的搜索结果是“mysql_upgrade 无法从 mysql.proc 加载。表可能已损坏“所有迹象表明,这些问题可以通过运行来解决mysql_upgrade。(我不得不运行,mysql_upgrade -p --force因为没有--force参数,它只是说”此安装的 MySQL 已升级至 10.2.13-MariaDB“)

现在我得到了一组同样不透明的错误消息。(下面每种情况下的序列invalid table(s) ... to use them都可以扩展为invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them- 我必须进行这些替换才能适应 30000 个字符的问题长度限制。)

Phase 3/7: Fixing views
sys.host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.host_summary' references invalid table(s) ... to use them
Error    : Corrupt
sys.host_summary_by_file_io
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.host_summary_by_file_io' references invalid table(s) ... to use them
Error    : Corrupt
sys.host_summary_by_file_io_type
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.host_summary_by_file_io_type' references invalid table(s) ... to use them
Error    : Corrupt
sys.host_summary_by_stages
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.host_summary_by_stages' references invalid table(s) ... to use them
Error    : Corrupt
sys.host_summary_by_statement_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.host_summary_by_statement_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.host_summary_by_statement_type
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.host_summary_by_statement_type' references invalid table(s) ... to use them
Error    : Corrupt
sys.innodb_buffer_stats_by_schema
Error    : FUNCTION sys.format_bytes does not exist
Error    : View 'sys.innodb_buffer_stats_by_schema' references invalid table(s) ... to use them
Error    : Corrupt
sys.innodb_buffer_stats_by_table
Error    : FUNCTION sys.format_bytes does not exist
Error    : View 'sys.innodb_buffer_stats_by_table' references invalid table(s) ... to use them
Error    : Corrupt
sys.innodb_lock_waits
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.innodb_lock_waits' references invalid table(s) ... to use them
Error    : Corrupt
sys.io_by_thread_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.io_by_thread_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.io_global_by_file_by_bytes
Error    : FUNCTION sys.format_path does not exist
Error    : View 'sys.io_global_by_file_by_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.io_global_by_file_by_latency
Error    : FUNCTION sys.format_path does not exist
Error    : View 'sys.io_global_by_file_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.io_global_by_wait_by_bytes
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.io_global_by_wait_by_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.io_global_by_wait_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.io_global_by_wait_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.latest_file_io
Error    : FUNCTION sys.format_path does not exist
Error    : View 'sys.latest_file_io' references invalid table(s) ... to use them
Error    : Corrupt
sys.memory_by_host_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.memory_by_host_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.memory_by_thread_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error    : View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.memory_by_user_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.memory_global_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.memory_global_total
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.memory_global_total' references invalid table(s) ... to use them
Error    : Corrupt
sys.metrics
Error    : Table 'performance_schema.global_status' doesn't exist
Error    : View 'sys.metrics' references invalid table(s) ... to use them
Error    : Corrupt
sys.processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.processlist' references invalid table(s) ... to use them
Error    : Corrupt
sys.ps_check_lost_instrumentation
Error    : Table 'performance_schema.global_status' doesn't exist
Error    : View 'sys.ps_check_lost_instrumentation' references invalid table(s) ... to use them
Error    : Corrupt
sys.schema_index_statistics
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.schema_index_statistics' references invalid table(s) ... to use them
Error    : Corrupt
sys.schema_table_lock_waits
Error    : Table 'performance_schema.metadata_locks' doesn't exist
Error    : View 'sys.schema_table_lock_waits' references invalid table(s) ... to use them
Error    : Corrupt
sys.schema_table_statistics
Error    : FUNCTION sys.extract_schema_from_file_name does not exist
Error    : View 'sys.schema_table_statistics' references invalid table(s) ... to use them
Error    : Corrupt
sys.schema_table_statistics_with_buffer
Error    : FUNCTION sys.extract_schema_from_file_name does not exist
Error    : View 'sys.schema_table_statistics_with_buffer' references invalid table(s) ... to use them
Error    : Corrupt
sys.schema_tables_with_full_table_scans
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.schema_tables_with_full_table_scans' references invalid table(s) ... to use them
Error    : Corrupt
sys.session
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.session' references invalid table(s) ... to use them
Error    : Corrupt
sys.session_ssl_status
Error    : Table 'performance_schema.status_by_thread' doesn't exist
Error    : View 'sys.session_ssl_status' references invalid table(s) ... to use them
Error    : Corrupt
sys.statement_analysis
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statement_analysis' references invalid table(s) ... to use them
Error    : Corrupt
sys.statements_with_errors_or_warnings
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statements_with_errors_or_warnings' references invalid table(s) ... to use them
Error    : Corrupt
sys.statements_with_full_table_scans
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statements_with_full_table_scans' references invalid table(s) ... to use them
Error    : Corrupt
sys.statements_with_runtimes_in_95th_percentile
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statements_with_runtimes_in_95th_percentile' references invalid table(s) ... to use them
Error    : Corrupt
sys.statements_with_sorting
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statements_with_sorting' references invalid table(s) ... to use them
Error    : Corrupt
sys.statements_with_temp_tables
Error    : FUNCTION sys.format_statement does not exist
Error    : View 'sys.statements_with_temp_tables' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.user_summary' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary_by_file_io
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.user_summary_by_file_io' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary_by_file_io_type
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.user_summary_by_file_io_type' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary_by_stages
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.user_summary_by_stages' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary_by_statement_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.user_summary_by_statement_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.user_summary_by_statement_type
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.user_summary_by_statement_type' references invalid table(s) ... to use them
Error    : Corrupt
sys.wait_classes_global_by_avg_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.wait_classes_global_by_avg_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.wait_classes_global_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.wait_classes_global_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.waits_by_host_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.waits_by_host_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.waits_by_user_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.waits_by_user_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.waits_global_by_latency
Error    : FUNCTION sys.format_time does not exist
Error    : View 'sys.waits_global_by_latency' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.x$host_summary' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$memory_by_host_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_host_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$memory_by_thread_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_thread_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.x$memory_by_user_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.x$memory_global_by_current_bytes' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$memory_global_total
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error    : View 'sys.x$memory_global_total' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.x$processlist' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$ps_schema_table_statistics_io
Error    : FUNCTION sys.extract_schema_from_file_name does not exist
Error    : View 'sys.x$ps_schema_table_statistics_io' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$schema_table_lock_waits
Error    : Table 'performance_schema.metadata_locks' doesn't exist
Error    : View 'sys.x$schema_table_lock_waits' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$schema_table_statistics
Error    : FUNCTION sys.extract_schema_from_file_name does not exist
Error    : View 'sys.x$schema_table_statistics' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$schema_table_statistics_with_buffer
Error    : FUNCTION sys.extract_schema_from_file_name does not exist
Error    : View 'sys.x$schema_table_statistics_with_buffer' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$session
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
Error    : View 'sys.x$session' references invalid table(s) ... to use them
Error    : Corrupt
sys.x$user_summary
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error    : View 'sys.x$user_summary' references invalid table(s) ... to use them
Error    : Corrupt

我尝试运行mysqlcheck -r sys -p -v它告诉我

Enter password:
Processing databases
sys
sys.sys_config
Error    : Table '    sys.sys_config' doesn't exist in engine
status   : Operation failed

这是我的问题的根源吗?如果是,我该如何解决?

相关内容