mariadb 5.5 to mysql 5.6 update failed

vacancy

Verified User
Joined
Jul 5, 2019
Messages
30
Since I want to use mysql 5.7, first I want to upgrade mariadb to 5.6, then I will upgrade to 5.7, but update fails when I want to upgrade to mysql 5.6.

Last week, this process was completed without error.

***

Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

***

mysql error log

2019-09-06 20:18:13 16332 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50563, now running 50642. Please use mys$
2019-09-06 20:18:13 16332 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50563, now running 50642. Please use mys$
2019-09-06 20:18:13 16332 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50563, now running 50642. Please us$
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position $
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50563, now running 50642. Please us$
2019-09-06 20:18:13 16332 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50563, now running 50642. Please use $
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigi$
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have ty$
2019-09-06 20:18:13 16332 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2019-09-06 20:18:13 16332 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT
 
You should try mariadb 5.5 -> mysql 5.5 and then upgrade mysql upwards.
 
Back
Top