*Problemă/Întrebare: Cum as pute sa rezolv erorile astea de mai jos care imi apar in /var/db/mysql/localhost.err Tipologie server:- *Resursă folosită:- *ServerFiles utilizat:- *Syserr:
230131 07:31:51 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended
230131 07:32:21 mysqld_safe Logging to '/var/db/mysql/localhost.err'.
230131 07:32:21 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-01-31 07:32:21 0
!
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-01-31 07:32:21 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 850 ...
2023-01-31 07:32:21 850 [Note] Plugin 'FEDERATED' is disabled.
2023-01-31 07:32:21 850 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-01-31 07:32:21 850 [Note] InnoDB: The InnoDB memory heap is disabled
2023-01-31 07:32:21 850 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-01-31 07:32:21 850 [Note] InnoDB: Memory barrier is not used
2023-01-31 07:32:21 850 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-31 07:32:21 850 [Note] InnoDB: Not using CPU crc32 instructions
2023-01-31 07:32:21 850 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-01-31 07:32:21 850 [Note] InnoDB: Completed initialization of buffer pool
2023-01-31 07:32:21 850 [Note] InnoDB: Highest supported file format is Barracuda.
2023-01-31 07:32:21 850 [Note] InnoDB: 128 rollback segment(s) are active.
2023-01-31 07:32:21 850 [Note] InnoDB: Waiting for purge to start
2023-01-31 07:32:21 850 [Note] InnoDB: 5.6.51 started; log sequence number 2904300
2023-01-31 07:32:21 850 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-01-31 07:32:21 850 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-01-31 07:32:21 850 [Note] Server hostname (bind-address): '*'; port: 3306
2023-01-31 07:32:21 850 [Note] IPv6 is available.
2023-01-31 07:32:21 850 [Note] - '::' resolves to '::';
2023-01-31 07:32:21 850 [Note] Server socket created on IP: '::'.
2023-01-31 07:32:21 850
!
Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50562, now running 50651. Please use mysql_upgrade to fix this error.
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2023-01-31 07:32:21 850 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2023-01-31 07:32:21 850 [Note] Event Scheduler: Loaded 0 events
2023-01-31 07:32:21 850 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-31 07:32:52 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_shops" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_shop_items" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_offers" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_auctions" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:32:52 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_auction_offers" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:33:12 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:33:12 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_safebox_valutes" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2023-01-31 07:33:12 48d15400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2023-01-31 07:33:12 48d15400 InnoDB: Error: Fetch of persistent statistics requested for table "player"."offlineshop_safebox_items" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
s-a stricat, trb sa gasesti pe cnv asa ca mine sa ti-l reinstaleze clean, de preferat versiunea 57, cu creere de useri de la 0 si dupa decat mutat ce trebuie account,player,log,common si facut upgrade la ele. Marea greseala care se face in general e ca lumea da copy paste la tot folderul mysql si in timp se corup tabelele, in special cele innodb.
de 
de 
de 
de