Menu

Replace MySQL with MariaDB in cpanel

cPanel 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.

MariaDB 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 MySQL, who forked it due to concerns over its acquisition by Oracle.







Make sure to save all existing data just in case there are any issues.
cp -Rf /var/lib/mysql /var/lib/mysql-old
mv /etc/my.cnf /etc/my.cnf-old
Disable the targets so cPanel no longer handles MySQL updates


The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel/WHM
/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
Remove existing MySQL RPM’s so theres a clean slate for MariaDB


The below command will uninstall the MySQL RPM’s!
/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55
Create a yum repository for MariaDB
vi /etc/yum.repos.d/MariaDB.repo
Place the following inside of it depending on the DISTRO or you can download the repo details from this bellow link - 
(https://downloads.mariadb.org/mariadb/repositories/):
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5.29/centos6-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Remove php from the /etc/yum.conf file then run the following commands
yum install MariaDB-server MariaDB-client MariaDB-devel
/etc/init.d/mysql start
mysql_upgrade
/etc/init.d/mysql restart
Add php back to the /etc/yum.conf file to ensure future php updates don't get clobbered


Rebuild easyapache/php to ensure modules are intact/working
/scripts/easyapache –build

#hackthesec,#cPanel

About Author:


I am a Linux Administrator and Security Expert with this site i can help lot's of people about linux knowladge and as per security expert i also intersted about hacking related news.TwitterFacebook

Next
This is the most recent post.
Previous
Older Post

0 comments:

Post a Comment

 
Top