How-Tos
- How to add global privileges for a MySQL user manually
- Can I install MongoDB on cPanel?
- How to manually reset the mysql root password with an init file.
- How to reset the postgres (admin database user) password for the PostgreSQL server on cPanel servers
- How to resolve "[mysqluserstore] Restarting MySQL due to my.cnf modifications."
- How to install the 'tablefunc' extension in a Postgresql database
- How to optimize a database and it's tables via phpMyAdmin in cPanel or WHM
- How to determine the size of a MySQL database via command-line
- How to backup MySQL databases before doing a MySQL upgrade
- How to increase open files limits for MariaDB
- How to restrict the number of MySQL connections by users
- How to configure MySQL / MariaDB to listen publicly so that remote connections will work
- How can I access phpMyAdmin without cPanel login?
- How to enable "Event scheduler" - Access denied when trying to toggle the switch
- How to increase max_input_vars for phpMyAdmin
- How to increase the PHP memory limit for phpMyAdmin
- How to disable MySQL Strict Mode
- How To Use The MySQLTuner Script?
- How to change the root MySQL user password
- How to use hostnames instead of IP addresses to allow authentication to mysql with the Remote MySQL icon in cPanel
- How Do I Change The Default Character Set in MySQL/MariaDB to utf8?
- How to change the collation or character set for your database in cPanel
- How to Move MySQL Datadir
- How to import and export databases via PHPMyAdmin
- How to create a database and database user in cPanel
- How to restore the Entire MySQL Directory from cPanel system backups
- How to Set a Default Storage Engine for MySQL/MariaDB
- How to Fix PHPPgAdmin cPanel Login Issues
- How to rename a database
- How to raise the max_allowed_packet limit for 'mysqldump'.