Overview
Content management systems such as WordPress, Joomla, and custom web applications store posts, user accounts, and settings inside a MySQL database.
Step 1: Create a New MySQL Database
-
Log in to your ClickHere2 Client Area and enter your hosting control panel.
-
Under the Web Tools / Databases section, select MySQL Databases.
-
Under Create a Database, enter a database name suffix (e.g.,
wp_data). -
Enter a strong database password (or generate one) and click Create Database.
-
Once created, make note of the generated details:
-
Database Name: (e.g.,
yourdomain_wp_data) -
Database Username: (matches your database name)
-
Database Host: In most cases, use
localhost(or the specific IP/hostname displayed on your database summary card). -
Database Port: Standard port
3306.
-
Step 2: Accessing phpMyAdmin
To inspect tables, run SQL queries, or import/export .sql database dumps:
-
In the MySQL Databases screen, find your database in the list.
-
Click the phpMyAdmin button directly next to the database name.
-
You will be logged in automatically without needing to re-enter credentials.
-
Use the Import tab to restore database backups, or the Export tab to download a full
.sqlbackup to your local computer.
