Soft2Hosting
How to Create and Manage MySQL Databases in cPanel Shared Hosting
Direct answer: cPanel provides database tools for creating MySQL/MariaDB databases, creating users and assigning privileges. For a first database, cPanel recommends the Database Wizard because it walks through the database, user and privilege steps in order. phpMyAdmin is then used for database-level operations such as inspecting tables or importing SQL.
Understand the three parts
A normal application database setup has three separate pieces:
- Database: the schema/data container.
- Database user: credentials the application uses.
- Privileges: what that user may do inside that database.
Creating only the database is not enough; the application needs a user with the correct privileges.
Use Database Wizard for the first setup
cPanel’s current Database Wizard guides users through creating a MySQL/MariaDB database, user and privileges. The provider may rename interfaces across cPanel versions—for example, “Manage My Databases” is the current name in newer versions.
Step 1: create the database
Open Database Wizard (or Manage My Databases), enter a clear database name and continue. cPanel may automatically prefix the database name with the hosting account username. Use the complete generated name in application configuration.
Step 2: create a dedicated database user
Create a strong unique password and store it securely. Do not reuse the cPanel account password or email password as a database credential.
Step 3: grant only the required privileges
Many CMS applications need broad privileges on their own database, but they should not receive access to unrelated databases. Keep application users separate when practical.
Step 4: configure the application
Applications normally need:
- database host (often localhost on shared hosting);
- database name;
- database username;
- database password.
Use the values shown by the hosting account rather than guessing prefixes or hostnames.
phpMyAdmin: use it for data, not account provisioning
phpMyAdmin is useful for viewing tables, running queries and importing/exporting SQL. Database-user creation and cPanel account privileges should be managed through the cPanel database interfaces, not by trying to bypass account-level controls.
Importing an existing database
- Create the destination database/user first.
- Take a verified copy of the source database.
- Import via phpMyAdmin or the provider-supported method.
- Update application configuration with the new credentials.
- Test reads and writes.
- Check character set/collation if text appears incorrectly.
Large imports
Browser/phpMyAdmin uploads can have size/time limits. If a database is larger than the shared-hosting interface allows, ask support for the recommended import process. Do not split SQL arbitrarily without understanding transaction/order dependencies.
Backups
Before plugin updates, migrations or bulk changes, keep a database backup outside the live site. cPanel backup tools can help export account/database data when enabled by the provider. A backup should be tested by restoring it into a safe environment.
Security checklist
- Use unique credentials per application/database where practical.
- Do not expose remote database access unless needed and allowed.
- Keep application config files unreadable to the public web.
- Do not email/plain-text database passwords unnecessarily.
- Remove unused users/databases.
- Keep the application updated to reduce SQL injection risk.
Shared hosting vs VPS database control
On shared hosting, the provider controls the server-wide database engine version and settings. That is simpler operationally but limits custom tuning. If an application requires server-wide MySQL configuration, unusual plugins or dedicated database resources, shared hosting may not fit.
Bottom line
cPanel database management is straightforward when you keep the database, user and privileges separate in your mental model. Use Database Wizard for initial setup, phpMyAdmin for data operations, strong credentials for the application and independent backups before risky changes.
Next step: compare Soft2Hosting cPanel shared-hosting plans by website/database needs and backup frequency.
Frequently asked questions about cPanel databases
Why does my database name have a prefix?
cPanel can prefix database and user names with the account username to keep shared-server names unique. Use the complete name displayed in cPanel inside the application configuration.
Can I change the MySQL server version from cPanel?
No. cPanel’s database documentation states that server-wide MySQL/MariaDB version changes are administrator/provider responsibilities. Shared-hosting users manage their own databases and users within the provided platform.
Can I connect remotely to the database?
Only if the hosting provider enables remote database access and the account/security rules allow the source. Avoid exposing databases publicly unless the application genuinely requires remote access.
What should I do before a bulk SQL import?
Take a verified backup, confirm character set/collation, check available storage and use the provider-supported import path. After import, test application reads and writes before discarding the old copy.
Operational tip
Keep a short inventory mapping each website to its database name and database user. This makes migrations, password rotations and incident recovery much faster.