Has anyone else run into the problem with trying to set up a Drupal 9.x site hosted on GoDaddy.com, but having the problem that Drupal 9 needs MySQL 5.7.8 and GoDaddy's default version is 5.6.x?

Their recommendation is to install Drupal 8.9.  I'm reluctant to do that knowing that I would be preventing me from taking advantage of any new enhancement or fix.  Am I missing something?

Have others faced this and found a workable solution?

Thanks!

Comments

vm’s picture

D9 requries MySQL 5.7.8 or Mariadb 10.3 per https://www.drupal.org/docs/system-requirements/database-server-requirem...

There is no workaround beyond finding a host that provides newer underlying software. If there was a workaround for the DB version requirement, it would likely remove any advantages being taken via new DB improvements.

poker.ca’s picture

Ran into the same problem after attempting to upgrade Drupal 8.9 to 9.1 on a Godaddy hosted site. Godaddy's support 'promises' that they're looking into upgrading MySQL on their shared servers "soon". In the meantime, this module may provide an interim workaround: https://www.drupal.org/project/mysql56 - - sounds good, but I haven't tried it yet...

poker.ca’s picture

Happy to report two sites now running D9 on Godaddy after installing this and editing settings.php to give the database 'namespace':

$databases['default']['default']['namespace'] = 'Drupal\\Driver\\Database\\mysql';

as per the project's page on this site.

fkelly12054@gmail.com’s picture

I just posted over at:

https://www.drupal.org/project/mysql56/issues/3199749

and won't repeat it all here.  The solution in the mysql56 "issue" works if you set it up right.  However, as I noted in my post:

https://www.drupal.org/project/mysql56/issues/3199749

the question of which MariaDB version to use does not have a clear answer.  To make it work with Drupal 9 you'll need to follow the instructions in the mysql56 project but if you look at:

https://downloads.mariadb.org/mariadb/+releases/

You'll be scratching your head. 

poker.ca’s picture

Goddady is still saying that an update to their shared hosting is "a few months" away. They suggested upgrading to a virtual private server where MySQL 5.7 is offered. No details on the cost of that.

slewazimuth’s picture

Its called separation of concerns. Godaddy is used as a domain registration service and the actual host provider is located elsewhere. Then if the host provider gives you any grief you can drop them like a stone and use someone else. Since you were pointing the domain from godaddy already, you just point to the new ip address of your new provider. Time wasted, less than 15 seconds.

brandonc503’s picture

Going to give it a try. I have minimal server experience. 

fkelly12054@gmail.com’s picture

The solution recommended in:

https://www.drupal.org/project/mysql56

worked for me to move to Drupal 9.  However, that project and its issue queue is not well-supported and you may need to "read between the lines".  You may have to experiment a bit to get the syntax for your new settings.php to work properly ... after you've set up the drivers in accord with the instructions. 

barnamah’s picture

I found that solution helpful. This video  show how to install Drupal 9 on on Hosting with MySQL 5.6.49 https://youtu.be/EiObpOgR_eo  I was struggling to move from Godaddy to other hosting provider. I installed Drupal 9.2.3. Thanks 

katekarpenko’s picture

I've encountered with the same issue when was trying to install Drupal from CPanel. Then I've checked version of MySQL from terminal and got next

 mysql  Ver 14.14 Distrib 5.6.51

First of all I've installed composer from Packagist for managing dependecies, and first part (how to install Drupal core from archive) I've perfomed according to the video, then I've used instructions from here https://www.drupal.org/project/mysql56 for installing with composer, and it helped me to install Drupal on my GoDaddy hosting