Unable to install MySQL 5

Roberto

Verified User
Joined
Apr 6, 2013
Messages
126
Location
London
Hi

After my VPS providers migrated my VPS to a new node, there were issues and I have had to reinstall my VPS server software and DirectAdmin from scratch. I took the opportunity to install Centos 8, whereas before I was using Centos 7.

I selected the default install settings.

The default database is MariaDB 10.4. The server is giving an error that MySQL is not started. I tried to switch from MariaDB to MySQL 8. In CustomBuild 2 in the dropdown to select the database, only MySQL 8 is given as an option, When I build this, it fails and tells me I need to install version 5 first the upgrade

  • Executing /usr/local/directadmin/plugins/custombuild/admin/build mysql...
  • mysql_inst=mysql is set in the options.conf, but MariaDB is currently installed
  • If you wish to use MySQL, please install MySQL 5.5 first, and then you'd be able to upgrade to a newer version of it. Please note that MariaDB 10.x migration to MySQL is considered a downgrade and might not work.

  • Done!

however, when I try this from the command prompt, it also fails there:-

[root@server custombuild]# cd /usr/local/directadmin/custombuild
[root@server custombuild]# ./build set mysql_inst mysql
Changed mysql_inst option from mariadb to mysql
[root@server custombuild]# ./build set mysql 5.6
5.6 is not a valid setting for mysql option.

It seems impossible to install MySQL 5 then upgrade to 8 after. Please help?

I am not sure why MariaDB 104 service is not starting in the first place.

Regards
 
I have solved the issues myself, although the VPS is not responsive enough and CPU usage is very high, despite remove unnecessary services and removing several PHP extensions.
 
Last edited:
Back
Top