How to replace MySQL with MariaDB in cpanel

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="text-align: center;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><b><u>Replace MySQL with MariaDB in cpanel</u></b></span></div> <div style="text-align: center;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><b><u><br /></u></b></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b><a href="http://www.hackthesec.co.in/search/label/cPanel">cPanel</a> </b>is a Linux-based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site.</span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s1600/MySQL-to-MariaDB.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s400/MySQL-to-MariaDB.jpg" width="400" /></a></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><a href="http://www.hackthesec.co.in/search/label/MariaDB"><b>MariaDB</b> </a>is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of <b><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a></b>, who forked it due to concerns over its acquisition by Oracle.</span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Make sure to save all existing data just in case there are any issues.</span></span></div> <div style="clear: both; margin: 10px 0;"> <center> <script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- linuxtutorial8 --> <ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center> </div> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">cp -Rf /var/lib/mysql /var/lib/mysql-old mv /etc/my.cnf /etc/my.cnf-old</span></span></pre> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>Disable the targets so cPanel no longer handles MySQL updates</u></span></span><br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span> <br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel/WHM</span></span><br /> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled /scripts/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled /scripts/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled</span></span></pre> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>Remove existing MySQL RPM’s so theres a clean slate for MariaDB</u></span></span><br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span> <br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">The below command will uninstall the MySQL RPM’s!</span></span><br /> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55</span></span></pre> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Create a yum repository for MariaDB</span></span></div> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">vi /etc/yum.repos.d/MariaDB.repo</span></span></pre> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Place the following inside of it depending on the DISTRO or you can download the repo details from this bellow link - </span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">(https://downloads.mariadb.org/mariadb/repositories/):</span></span></div> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/5.5.29/centos6-amd64/ gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1</span></span></pre> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Remove php from the /etc/yum.conf file then run the following commands</span></span></div> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">yum install MariaDB-server MariaDB-client MariaDB-devel /etc/init.d/mysql start mysql_upgrade /etc/init.d/mysql restart</span></span></pre> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Add php back to the /etc/yum.conf file to ensure future php updates don't get clobbered</span></span><br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span> <br /> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Rebuild easyapache/php to ensure modules are intact/working</span></span><br /> <pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/easyapache –build</span></span></pre> <div style="text-align: left;"> <br /></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div> <div style="text-align: left;"> <span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">#hackthesec,#cPanel</span></div> </div>

How to replace MySQL with MariaDB in cpanel

Replace MySQL with MariaDB in cpanel cPanel is a Linux-based web hosting control panel that provides a graphical interface and automa...

Read more »