How-Tos
- 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 do I upgrade MySQL/MariaDB on my server?
- 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'.
- How to reset a database user password
- How To Determine What cPanel Account/User Owns A Particular MySQL Table?
- How to find where MySQL data is being stored
- How to turn off Event Scheduler in MySQL 8
- How to tell what version of MySQL® or MariaDB that is running
- How to Enable the Error Log in MySQL® or MariaDB
- How-To increase max_allowed_packet for MySQL?
- How to start MySQL with skip-grant-tables
- How to fix routines/stored procedures so they can be manipulated via PHPMyAdmin
- Create a bind-mount for MariaDB on existing installations
- Allow dynamic IP to connect to MySQL Remotely
- How do you create a MySQL user that can be connected to remotely using the cPanel interface?
- How do you convert database tables from InnoDB to MyISAM?