Skip to main content
cPanel Help Center home page
Submit a Request
Sign in
  1. cPanel
  2. Support Topics
  3. Databases
  4. How-Tos

How-Tos

  • How To Configure PostgreSQL To Accept All Incoming Connections?
  • How to enable remote PostgreSQL access
  • How to manually reset the MySQL/MariaDB root users' password
  • 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 restart MySQL?
  • 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 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 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?
  • Next ›
  • Last »
cPanel