|OS type and version||Ubuntu 18.04|
|Virtualmin version||7.2-1 Pro|
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…
- what is the best way to upgrade from MySql 5.7 to 8.0?
- Will it cause problems with Virtualmin 7.2 pro
- Can I revert back to MySql 5.7 if 8.0 causes unforseen problems?
- Is MySql 8.0 backwardly compatible with MySql 5.7?
I’ll look forward to your response!