Unable to downgrade MySQL from version 8 to 5.6 nor start MySQL (MySQL Error Log Included)
1
vote
1
answer
2233
views
I run a Plesk VPS (**OS:** Centos 6/Linux (Final)), whereby I recently tried to upgrade the MySQL from version 5.5.55 to version 5.6.
Being relatively new to this area, I strictly followed this Plesk Article Specifically following the steps within the 'Plesk on CentOS 6' Tab.
Unfortunately, I made the mistake of assuming version 8 was disabled as default. As a result, MySQL version 8 was installed and is now causing me major issues. To the point, where I cannot start MySQL.
I have tried to downgrade, from version 8 to version 5.6, by opening the file
/etc/yum.repos.d/mysql-community.repo
Notepad++, where I ensured the below was entered:
# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-preview]
name=MySQL Tools Preview
baseurl=http://repo.mysql.com/yum/mysql-tools-preview/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-cluster-7.5-community]
name=MySQL Cluster 7.5 Community
baseurl=http://repo.mysql.com/yum/mysql-cluster-7.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-cluster-7.6-community]
name=MySQL Cluster 7.6 Community
baseurl=http://repo.mysql.com/yum/mysql-cluster-7.6-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Upon entering the command yum update mysql
, the following appeared on the screen:
Loaded plugins: fastestmirror, security
Setting up Update Process
Loading mirror speeds from cached hostfile
* atomic: www4.atomicorp.com
* epel: mirror.freethought-internet.co.uk
* remi-safe: mirror.netweaver.uk
Package(s) mysql available, but not installed.
No Packages marked for Update
I then continued with the steps, in the hope that the installation would still miraculously work somehow.
I got as far as service mysqld start
where I generated the same error as before, which was:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
I am not just absolutely stumped as to how to downgrade to MySQL version 5.6 and to start back up MySQL.
**MySQL Log:**
[Warning] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
[System] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 14057
[System] [Server] Starting upgrade of data directory.
[ERROR] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
[ERROR] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [Server] Failed to initialize DD Storage Engine.
[ERROR] [Server] Data Dictionary initialization failed.
[ERROR] [Server] Aborting
[System] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
**Additional Information:**
I am not sure if the below helps but after entering the command yum repolist all | grep mysql
, the following information appeared:
mysql-cluster-7.5-community MySQL Cluster 7.5 Community disabled
mysql-cluster-7.6-community MySQL Cluster 7.6 Community disabled
mysql-connectors-community MySQL Connectors Community enabled: 94
mysql-tools-community MySQL Tools Community enabled: 78
mysql-tools-preview MySQL Tools Preview disabled
mysql55-community MySQL 5.5 Community Server disabled
mysql56-community MySQL 5.6 Community Server enabled: 512
mysql57-community MySQL 5.7 Community Server disabled
mysql80-community MySQL 8.0 Community Server disabled
**Version 8 References**
As per the advise in the Comment section, I have performed the command yum list mysql*
as to generate the following results as to identify any relevant 'version 8 packages' to be removed. The only problem is, I am not sure which are 'version 8 packages':
Loaded plugins: fastestmirror, security
Determining fastest mirrors
epel/metalink | 30 kB 00:00
* atomic: www4.atomicorp.com
* epel: mirror.freethought-internet.co.uk
* remi-safe: mirror.netweaver.uk
PLESK_17_8_11-extras | 2.9 kB 00:00
PLESK_17_8_11-extras/primary_db | 32 kB 00:00
PLESK_17_PHP56 | 2.9 kB 00:00
PLESK_17_PHP56/primary_db | 14 kB 00:00
PLESK_17_PHP70 | 2.9 kB 00:00
PLESK_17_PHP70/primary_db | 15 kB 00:00
PLESK_17_PHP73 | 2.9 kB 00:00
PLESK_17_PHP73/primary_db | 17 kB 00:00
atomic | 3.4 kB 00:00
atomic/primary_db | 651 kB 00:00
epel | 5.3 kB 00:00
epel/primary_db | 6.1 MB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 37 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 50 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 261 kB 00:00
plesk-migrator | 2.9 kB 00:00
plesk-migrator/primary_db | 6.7 kB 00:00
plesk-migrator-tp | 2.9 kB 00:00
plesk-migrator-tp/primary_db | 1.2 kB 00:00
remi-safe | 3.0 kB 00:00
remi-safe/primary_db | 1.2 MB 00:00
Available Packages
mysql.i686 5.5.44-30.el6.art atomic
mysql.x86_64 5.5.55-1659.el6.art atomic
Asked by Craig
(119 rep)
Jun 13, 2019, 11:27 PM
Last activity: Mar 13, 2023, 05:03 AM
Last activity: Mar 13, 2023, 05:03 AM