How-Tos
- 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 that 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?
- MySQL - Locking and Unlocking users
- How to DROP MySQL users manually
- How to install MySQL Governor
- How to Enable the Slow Query Log in MySQL® or MariaDB
- How to restore MySQL grants
- How to remove MySQL Governor