downgrading mysql in laravel homestead

Level 75

@automica just curious, why not mysql 8?

Level 54

@jlrdw its a 6 year Drupal 7 site. Alas no mysql8 support as this version is EOL.

Due to Covid Drupal moved the sunsetting date to next year which meant our client batted off upgrading.

jlrdw

Level 75

Look at this: https://stackoverflow.com/questions/61189727/laravel-homestead-downgrade-to-mysql-5-7

Will probably have to "play with" options.

Level 54

I tried that and it didn't work.

I think I just needed to add

features:
  - mariadb: false
  - ohmyzsh: false
  - webdriver: false
  - mysql8: false
  - mysql: true

I also dropped back to v9.6.0 (from v10) which is currently passing my tests.

I will need to work out how to install only version 9.* rather than 10.* which seems to be versioned outside of my composer.json

I'll report back after my upgrade to v9.7.2 - currently taunting me (even though I'm on 200Mbps connection)

Progress: 1% (Rate: 70420/s, Estimated time remaining: 6:58:08)

Level 4

Homestead v10 no longer includes MySQL 5.7; instead MySQL 8 is installed by default.

The feature script "mysql8" has been removed in Homestead version 10.0.0 as well.

The solution I found was to downgrade to Homestead 9 for any projects requiring MySQL 5.7. The alternative is to use Homestead 10 and manually install MySQL 5.7.

Level 54

@mrbretts aha, I removed homestead version 10 and it rebuilt the vagrant box using the 9.6 version I also had on my Mac.

I ran the following to remove v10

vagrant box remove laravel/homestead --box-version 10.0.0

Do you know what command Id run to install the latest 9.* which supports MySQL 5? That’s the last piece in the puzzle to get this working on my colleagues local dev environment

Level 4

I found the easiest way for me to update was to open my homestead folder in terminal (cd ~/Homestead) and then run "vagrant box update". After the update is downloaded I like to run "vagrant box prune" to remove any older versions of Homestead.

To see what version of Homestead you have installed, run "vagrant box list" from within the Homestead folder.

// update the box
vagrant box update

// list all versions of box
vagrant box list

// remove old versions of a box
vagrant box prune

Level 54

I had 3 releases of version 9 and 1 of version 10 (that I’ve removed).

Wondering what command I would be able to do to get the most recent 9 version.

Is there a flag for vagrant box update to specify a particular version? My colleague will have version 10 and needs 9

Best Answer

Level 4

When you start the box, "vagrant box up", the terminal will tell you if you are using an outdated version. I don't like keeping old version of a box around so i like to run "vagrant box update" to download the latest copy of 9 (version 9.7.2 / (https://app.vagrantup.com/laravel/boxes/homestead) and then i run "vagrant box prune" to remove those any old versions from my machine.

To install/update a specific version of a box you can use the Vagrant box add option "--box-version VALUE". Here is an example.

 vagrant box add laravel/homestead --box-version 9.7.2

To learn more about that option and other commands i mentioned please checkout the Vagrant Box document here: https://www.vagrantup.com/docs/cli/box

As for your colleague i would run the command to remove version 10 and then use the box-version command above to install version 9.7.2 (https://app.vagrantup.com/laravel/boxes/homestead/versions/9.7.2). You could try just running vagrant box add laravel/homestead, but that may install version 10.

2 likes

Level 54

@mrbretts thanks. that's sorted our problem, and I learnt some stuff in the process.