Issue
We've noticed that cPanel is installing MySQL 8 by-default on CloudLinux 8 installations. If you'd like to use MariaDB instead, this results in a conflict because migration from MySQL 8 to MariaDB 10.x is not supported/recommended due to a difference in system tables.
Official article here:
https://mariadb.com/kb/en/upgrading-from-mysql-to-mariadb/
Additional information about incompatibilities:
https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-105-and-mysql-80/#incompatibilities
Environment
- MySQL/MariaDB
- CloudLinux OS
- cPanel
Solution
For new servers, the best method would be to reinstall cPanel with MariaDB. To do so, proceed with the following steps:
1. Reinstall OS.
2. Create a file /root/cpanel_profile/cpanel.config
3. Add desired mariadb version to the file, for example:
mysql-version=10.3
4. Proceed with cPanel install:
cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest
Comments
0 comments
Please sign in to leave a comment.