It was announced by cPanel on April 14, 2010 that cPanel 11.25.1 will include a new database mapping feature that’s been long requested: the removal of cPanel username prefixes from the database names. This is a non-reversible, opt-in feature that some hosts may find very valuable. But is it a feature that you need? Who […]
New cPanel Database Mapping Feature: Is it for You? Read Post »
When you upgrade from cPanel 11.24 to 11.25, your users may notice that in cPanel, their MySQL databases show 0MB of disk space used, when they know their databases are much larger. This is due to an option in cPanel that you specifically have to enable. To enable MySQL disk usage tracking: 1) Edit /var/cpanel/cpanel.config
Disk Space for MySQL Databases in cPanel Show as 0MB Read Post »
Cpanel has a lot of supporting software that you may be using on your server. In case something goes amiss, here is a list of scripts that reinstall cpanel-provided software on your system. For most all of these, you can pass a –force as an argument to force a reinstall of the application. Update: Most
Re-Installing Auxiliary cPanel Software Read Post »
From time to time I’ve had users ask me to install an SSL certificate for their MySQL server. Currently this support is not enabled in cPanel automatically, nor is there an option to use it in WHM > Manage Service SSL Certificates at the time this article was written. However, you can install a certificate manually by following a few simple steps.
Installing an SSL Certificate for MySQL Read Post »
PostgreSQL is an open-source database server similar (but different) than MySQL. cPanel has a built-in installer for setting up PostgreSQL easily. Keep in mind that the actual version of PostgreSQL you get depends on your OS version. For instance, CentOS 4 users will likely get version 7, CentOS 5 will get version 8. First, run
Installing PostgreSQL Read Post »
Update 2/15/14: These instructions have been updated for cPanel 11.36+. You can easily change the major version of MySQL running on your server, keeping in mind that the actual version will be dependent on what cPanel has released in their repository and what cPanel version you’re running. For example, if you’re running cPanel 11.40, you
Upgrading or Downgrading MySQL Read Post »
