Skip to content

Knowledgebase

MySQL databases and phpMyAdmin Print

  • 0

Every dynamic site has a database. In cPanel you can create and manage one without touching the command line.

Creating a database

  1. In cPanel open Databases → MySQL Database Wizard.
  2. Give the database a name. The system prefixes it with your username — that is normal and cannot be changed.
  3. Create a user with a strong password.
  4. Assign the user to the database and tick ALL PRIVILEGES.

Those four details — database name, username, password and localhost as the host — are what you enter in your site's configuration file (in WordPress: wp-config.php).

phpMyAdmin

Under Databases → phpMyAdmin you can browse tables, run queries and export or import a database. Exporting before any significant change is a habit that saves sites.

Common mistakes

  • Forgetting the prefix in the database or user name, which produces a connection error.
  • Entering an external host name instead of localhost.
  • Importing a large file through phpMyAdmin and hitting the size limit — in that case open a ticket and we will import it directly on the server.

Was this answer helpful?

« Back