You will need the MYSQL root password to run this.

mysqldump -u root -p –all-databases > /bsackup/all_dbs.sql

This code will drop it off in your /backup partition.

How to Find & Replace Data in MySQL

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

(Don’t forget to remove the [] bars!) You can run this from root, ssh, or in your phpmyadmin under the MYSQL tab.

This is under the “Security” tab in the “WHM Home » Server Configuration » Tweak Settings” if you decide that you do not want to register your applications:

“Allow apps that have not registered with AppConfig to be run when logged in as root or a reseller with the “all” ACL in WHM.”

This will do it.

This means your email provider requires authentication for sending emails. Just click the “my server requires authentication” and choose to use the same log in as the incoming mail.

Install Image magick on Cpanel

/scripts/installimagemagick

Starting and Stopping mysql-governor mysql_governor

To start: service db_governor start

To stop: service db_governor stop

Magic Quotes (which is a feature of PHP, not Apache) is no longer considered good practice, as it introduces some security problems. This feature is deprecated in PHP 5.3, and removed entirely from PHP 5.4 and later. For versions of PHP that do support it, it can only be enabled or disabled at the system level, not for individual users.

Here is the official documentation.

The Wikipedia entry includes a discussion of the problems with Magic Quotes.

You can restart SSH which will gives you command line access to update the cpanel server license.

You can do this:

http://$IPADDRESS:2086/scripts2/doautofixer?autofix=safesshrestart

Replace the IP with the server address, you will also need root access.

To install MySQL governor on your server:

yum remove db-governor db-governor-mysql # you can ignore errors if you don’t have those packages installed
yum install governor-mysql –enablerepo=cloudlinux-updates-testing
/usr/share/lve/dbgovernor/mysqlgovernor.py –install

* The installation currently supports only cPanel & DirectAdmin servers.

** Please, note that MySQL on cPanel servers will be updated from CloudLinux RPMs.

*** MySQL Governor is compatible only with MySQL 5.x

/usr/local/cpanel/bin/unregister_cpanelplugin /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/softaculous.cpanelplugin;

rm -rf /etc/cron.d/softaculous;

rm -rf /var/softaculous;

rm -rf /usr/local/cpanel/whostmgr/cgi/softaculous;

rm -rf /usr/local/cpanel/whostmgr/cgi/addon_softaculous.php;

rm -rf /usr/local/cpanel/whostmgr/cgi/addon_softaculous.cgi

rm -rf /usr/local/cpanel/base/frontend/x3/dynamicui/dynamicui_softicons.conf;