Installing MySql 8.0 on Ubuntu 18.04

SYSTEM INFORMATION
OS type and version Ubuntu 18.04
Webmin version 2.001
Virtualmin version 7.2-1 Pro
Related packages SUGGESTED

I have Ubuntu 18.04 installed on my server which is using Virtualmin. Just recently I purchased a script that requires MySql 6.0 and above. I currently have MySQL version 5.7.39-0ubuntu0.18.04.2 which has been on there since I installed the server a couple years ago.

I would like to upgrade the MySql server to 8.0, but I have a bunch of databases and I don’t want to cause a problem with them or the rest of the system.

So here is my question…

  1. what is the best way to upgrade from MySql 5.7 to 8.0?
  2. Will it cause problems with Virtualmin 7.2 pro
  3. Can I revert back to MySql 5.7 if 8.0 causes unforseen problems?
  4. Is MySql 8.0 backwardly compatible with MySql 5.7?

I’ll look forward to your response!

Dan Lewis

Hello,

If you know how to upgrade MySQL to 8 on your Ubuntu 18.04, Virtualmin will work just fine with it.

Although, you should most probably re-configure it additionally after upgrade by running virtualmin-config-system -i=MySQL and re-running Virtualmin wizard to force-reset MySQL root password.