MariaDb오늘 아침 FreeBSD 10.3에서 11.1로 업그레이드하는 과정에서 내 서버에서 제거된 것을 발견했습니다 . 데이터베이스 엔진을 다시 설치하고 비호환성 문제를 해결한 후 마침내 작업을 my.cnf시작했습니다 .MariaDb모든사용자(루트 제외)는 데이터베이스에 대한 액세스가 거부되었습니다.
임의의 사용자에 대해 비밀번호를 재설정해 보았으나 아무런 변화가 없었습니다.
여기서 무엇이 잘못되고 있는지에 대한 유용한 정보는 어디에 있습니까? 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
이것이 내 문제의 근원인가? 그렇다면 어떻게 수정합니까?