Jump to content

Recommended Posts

Hello metin2 dev.

I have problem with mysql. 

Run first time the server and all works fine but i have this problem and i cant connect

 

Spoiler

220325 14:51:40 mysqld_safe Logging to '/var/db/mysql/metin2neosis.err'.
220325 14:51:40 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-03-25 14:51:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-03-25 14:51:41 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 666 ...
2022-03-25 14:51:41 666 [Note] Plugin 'FEDERATED' is disabled.
2022-03-25 14:51:41 666 [Note] InnoDB: Using atomics to ref count buffer pool pages
2022-03-25 14:51:41 666 [Note] InnoDB: The InnoDB memory heap is disabled
2022-03-25 14:51:41 666 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-03-25 14:51:41 666 [Note] InnoDB: Memory barrier is not used
2022-03-25 14:51:41 666 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-25 14:51:41 666 [Note] InnoDB: Not using CPU crc32 instructions
2022-03-25 14:51:41 666 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2022-03-25 14:51:41 666 [Note] InnoDB: Completed initialization of buffer pool
2022-03-25 14:51:41 666 [Note] InnoDB: Highest supported file format is Barracuda.
2022-03-25 14:51:41 666 [Note] InnoDB: The log sequence numbers 1600319 and 1600319 in ibdata files do not match the log sequence number 1600349 in the ib_logfiles!
2022-03-25 14:51:41 666 [Note] InnoDB: Database was not shutdown normally!
2022-03-25 14:51:41 666 [Note] InnoDB: Starting crash recovery.
2022-03-25 14:51:41 666 [Note] InnoDB: Reading tablespace information from the .ibd files...
2022-03-25 14:51:41 666 [Note] InnoDB: Restoring possible half-written data pages 
2022-03-25 14:51:41 666 [Note] InnoDB: from the doublewrite buffer...
2022-03-25 14:51:41 666 [Note] InnoDB: 128 rollback segment(s) are active.
2022-03-25 14:51:41 666 [Note] InnoDB: Waiting for purge to start
2022-03-25 14:51:41 666 [Note] InnoDB: 5.6.51 started; log sequence number 1600349
2022-03-25 14:51:41 666 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2022-03-25 14:51:41 666 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2022-03-25 14:51:41 666 [Note] Server hostname (bind-address): '*'; port: 3306
2022-03-25 14:51:41 666 [Note] IPv6 is available.
2022-03-25 14:51:41 666 [Note]   - '::' resolves to '::';
2022-03-25 14:51:41 666 [Note] Server socket created on IP: '::'.
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [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).
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2022-03-25 14:51:41 666 [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).
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2022-03-25 14:51:41 666 [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).
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2022-03-25 14:51:41 666 [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.
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2022-03-25 14:51:41 666 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2022-03-25 14:51:41 666 [Note] Event Scheduler: Loaded 0 events
2022-03-25 14:51:41 666 [Note] /usr/local/libexec/mysqld: ready for connections.

Thank you and i will wait your help

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.