- Apr 24, 2016
- cPanel Access Level
- Root Administrator
<redacted by user>
Last edited by a moderator:
Obtained version information from cpanel.config. Beginning “MariaDB 10.3” upgrade... nsuring the “MariaDB103” repository is available and working. Disabling package module mysql Disabling package module mariadb checkyum version 22.3 (excludes: bind-chroot) .,.... more autoscroll items Dependencies resolved. Nothing to do. Complete! MariaDB installed from official repository. Building configuration. mysql restarted successfully. MariaDB upgrade completed successfully
Updated the password for the active MySQL profile. Applications using MySQL will now be updated. Updating “DBcache” configuration … Success …Done Updating “Roundcube” configuration … Roundcube is configured to use SQLite. This update is for Roundcube using MySQL. Running /usr/local/cpanel/bin/update-roundcube-sqlite-db. Success …Done Updating “phpMyAdmin” configuration … Success …Done You have successfully changed “root”’s MySQL password.
This was very helpful and should be in the official docs.Tried, tested, works..
Glad you found it helpful, It sure helped me to figure this out, I have used this now twice since then during a reload of a server after a team colleague forgot the initial settings before launching the installer. Glad it helps someone elseThis was very helpful and should be in the official docs.
Other users please note - this should only be done on clean install, not where there are existing databases
Great addition to this thread, I somehow didn't end up not being able to do it, maybe they added something later? At least at the time I used this I didn't have to do this but its good to have nontheles =)FYI this method still more or less works, but after you do a yum remove of mysql, and update the cpanel.config file, the MySQL/MariaDB Upgrade section in WHM no longer gives you the option to install MariaDB. The way around this is to perform that step using the API instead. ie from the command line run:
whmapi1 --output=jsonpretty start_background_mysql_upgrade version='10.3'
|Thread starter||Similar threads||Forum||Replies||Date|
|D||Can we downgrade upgrade schedule via cpupdate.conf||Installation & Updates||1|
|1||Downgrade cpanel v98 to v48||Installation & Updates||1|
|How to downgrade from Mariadb 10.3.26 to 10.3.25 ?||Installation & Updates||2|
|S||Downgrade from EDGE to RELEASE or STABLE||Installation & Updates||4|
|W||Downgrade cPanel v74 to any version where no API is changed||Installation & Updates||3|