When attempting to create a user or restore a backup you may see this error: This system already has a database owner named___ To fix this, edit the following files on the system and remove entries for the user in question: /var/cpanel/databases/users.db /etc/dbowners
This system already has a database owner named X Read Post »
Years ago, MySQL started allowing InnoDB to possess separate tablespace per table instead of a massive unified ibdata1 file. Tablespace is basically a logical storage area that contains table information – references, if you will. Every table, regardless of the storage engine, has one, and without it the table will be unrecognizable to MySQL. MyISAM stores
How to Convert InnoDB to innodb_file_per_table and Shrink ibdata1 Read Post »
There may be some situations where you have to move the location of MySQL, for example, if you’re out of disk space or perhaps looking to host it on another device to increase performance. Whatever the reason, moving MySQL is simple and has no impact ct on cPanel’s functionality. 1) Create a backup
How to Change the Location of MySQL on cPanel Read Post »
Update: Please be advised that this post does not apply to you if you’re running EasyApache 4, because EA4 uses PHP RPMs and MySQL client compatibility libraries. Please make sure you are following the instructions below that pertain to your system! There’s a dilemma among system administrators of high-traffic servers when it comes to doing
Upgrading MySQL Without Breaking PHP Read Post »
I’ve seen several cases in the last few months where database users seemingly “disappear” or privileges appear to become invalid when restoring MySQL data or an entire server from raw backups. This may commonly be attributed to a MySQL version mismatch, for example, when a server is running MySQL 5.0 and then is suddenly running
Restoring Database Privileges Read Post »
Update 2/14/14: These instructions have been updated to apply to 11.36+. If at all possible, you should use WHM to install MySQL, however, if you need a version of MySQL outside of what they are offering in current cPanel versions, it is possible to install your own versions. These instructions can also be used to
Installing Custom MySQL Versions Read Post »
We’ve developed our first cPanel 11.25 cheat sheet, now available for your downloading pleasure. The sheet is comprised of common file, script, and configuration locations for help at a quick glance. [dm]1[/dm] More cheat sheets will be available soon! Check back on our Cheat Sheets page for more.
cPanel 11.25 Cheat Sheet Read Post »
Update: As of cPanel 11.4x, Roundcube only supports SQLite. cPanel 11.25 introduces a new feature: The ability to have RoundCube use SQLite instead of MySQL. After benchmarking resource usage and performance, I’ve come to the conclusion that SQLite is definitely the best way to go for Roundcube. Having trou Duplicate File Cleaner ble making the
Roundcube: MySQL or SQLite? Read Post »
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 »
