OpenPanel allows you to control which MySQL version is used per user by setting the MYSQL_VERSIONvariable. This is useful for compatibility reasons (e.g. older applications requiring MySQL 5.7 instead of 8.x).
Each user environment runs MySQL inside a container, and the version is defined using:
MYSQL_VERSION=<version>
Examples:
MYSQL_VERSION=5.7
MYSQL_VERSION=8.0
To set MySQL version you can do the following:
For NEW users (default setting)
Go to:
OpenAdmin → Settings → Edit User Defaults → Advanced
And here you set the desired version of mysql.
This will apply to all newly created users.
For EXISTING users:
Go to:
Users → <username> → Services → Edit Services
- Find MYSQL_VERSION
- Change it to the desired version (e.g. 5.7 or 8.0)
- Save changes
After updating the version, restart the user’s services. This will recreate the MySQL container with the selected version.