Can I use MYSQL8.0 in bitnami 5.7.1-2

Keywords: WordPress - Virtual Machines - Technical issue - Other

bnsupport ID: 2a1b4e19-2049-4e21-a94d-de3e179c63e2

bndiagnostic output:

? Mariadb: Found possible issues
? Connectivity: Found possible issues
? Resources: Found possible issues
https://docs.bitnami.com/general/how-to/troubleshoot-permission-issues/
https://docs.bitnami.com/general/faq/administration/use-firewall/
https://docs.bitnami.com/installer/faq/linux-faq/administration/increase-memory-linux/

bndiagnostic failure reason: The suggested guides are not related with my issue

Description:
I have been using external MYSQL8.0 on the bitnami5.5

Recently I plan to upgrade bitnami to 5.7.1-2, I noticed the database changed to maria.

The “db_version” value in the new version.php will be 49752, but the “$wp_db_version” in our bitnami database is still 48748.

Is MYSQL8.0 still working fir the bitnami 5.7.1-2

Is it OK to modify the “$wp_db_version” in our bitnami database, to get it through the db version validation?

Hi @NanyinK

Thanks for using Bitnami WordPress!

Recently I plan to upgrade bitnami to 5.7.1-2, I noticed the database changed to maria.

Yes, the Bitnami WordPress stack is now shipping MariaDB instead of MySQL. Nevertheless, you can still use an external database as you were doing until now. As per MySQL8.0, the official WordPress page does not mention any incompatibilities:

https://wordpress.org/about/requirements/

The “db_version” value in the new version.php will be 49752, but the “$wp_db_version” in our bitnami database is still 48748.

Hmm in not really sure you should be updating those values by hand. In order to migrate to the new instance and using the same external DB I’d say you should need to do the following instead:

  1. Perform a backup of your current instance. We highly encourage this to ensure you have a point of return in case anything goes wrong. We have some guides on this that you may find helpful:

https://docs.bitnami.com/virtual-machine/apps/wordpress/administration/backup-restore-jetpack/
https://docs.bitnami.com/virtual-machine/apps/wordpress/administration/backup-restore-mysql-mariadb/

  1. Update your current bitnami 5.5 instance: It might be possible that the database structure needs to be mgirated between versions. Triggering this process will instruct Wordpress to update the database structure if needed. You mentioned bitnami 5.7.1-2, but the most recent version of WordPress is 5.8.1. Is there any reason to upgrade to that specific version? Should you want to upgrade to latest one, you can follow this tutorial:

https://docs.bitnami.com/virtual-machine/apps/wordpress/administration/upgrade/

  1. Once the upgrade is done, create a new instance of bitnami 5.8.1 and configure it to use the external DB as well.

Some notes on this:

  • Do I need to create a new instance if I have already upgraded my old one to the latest version following step 2?
    You technically don’t need to as your old instance would be running the latest version of WordPress. However, the rest of components (such as PHP-FPM or Apache) will NOT be updated. Creating a new instance will ensure that all of the components, including WordPress, are up-to-date.

  • I’m not really comfortable performing changes in my old instance. Can I follow another process?
    Although the process should be mostly risk-free performing a backup before, if you’d like to keep your older instance intact you could also import that backup in the new instance following the same tutorial (restoration process). Bear in mind that for this you will need to create a new database for your application in your MySQL 8.0 server.

Hope it helps!
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

1 Like

Hi @jcarmona

Thank you a lot for the advice!very detailed.

For the value

The “db_version” value in the new version.php will be 49752, but the “$wp_db_version” in our bitnami database is still 48748.

why I need to do this, is that if I dont update the value, I will be asked to do an upgrade for the database when I access the wordpress web page, and I dont know what will happen & if this will impact my data.

For the version 5.7.1-2
The reason why I dont use the latest version is that, I m using the external database on the AWS(RDS). I chose to use mariadb10.4.18 and this version matched that in bitnami 5.7.1-2

What I concerned is all about the database, it will take very big efforts to do the test if I upgrade the database, and there will be a downtime.
If I don’t do the upgrade, the values in the configuration file and in the database will not match, then I will be asked to upgrade on the website. or I can modify the value to get it through the validation. I dont know if this is appropriate as well.