How-Tos
- How to upgrade MySQL/MariaDB on the command line
- How to manually reset the MySQL/MariaDB root users' password
- How to view the currently running MySQL queries
- How to locate the MySQL or MariaDB log
- How to reinstall phpMyAdmin
- How to change Wordpress User's password with phpMyAdmin
- How do I enable event_scheduler by default in MySQL?
- How to manually dump a non-user MySQL database and copy it to another server
- How to change MySQL Port?
- How to set up the RocksDB storage engine with MySQL and MariaDB
- How to add Routines (Stored Procedures / Functions) via PHPMyAdmin in cPanel
- How can I change the values of optimizer_switch variables for MySQL?
- How to enable/disable username prefixes for databases and database usernames.
- How-To remove a users MySQL database using the cPanel interface
- How To Increase max_open_files for MySQL
- How to delete a database from the command line.
- How to add global privileges for a MySQL user manually
- Can I install MongoDB on cPanel?
- 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 its 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