cPanel Databases

Practical setup, management and troubleshooting guides for cPanel Databases.

Articles

Allowing a trusted remote database connection in cPanel

Remote Database Access can permit a trusted external host to connect to an account’s MySQL or...

Assigning a database user and choosing its privileges in cPanel

A database user needs an explicit assignment to the database it will access. Privileges...

Assigning a database user only the privileges an application needs

A database user should have the permissions its application actually needs on the intended...

Check why a database content import has not changed the visible page

If an import finishes but a page still shows its old content, confirm what was actually...

Choosing a safe method for a database dump too large for phpMyAdmin

A database dump can exceed phpMyAdmin’s upload, memory or execution limits even when the...

Creating a MySQL or MariaDB database in cPanel

Create a database through cPanel so the hosting account owns and tracks it correctly. The...

Creating a database user in cPanel

A database user is an application credential, not a cPanel login. Creating a separate user for...

Deleting an unused database from cPanel

Delete a database only after confirming that no live website, staging site, scheduled task or...

Diagnosing database access denied after a hosting migration

An access-denied database error after migration usually points to the connection identity,...

Renaming a cPanel database without losing the application connection

Renaming a database changes the identifier an application uses to connect. It does not...

Rotating a database password without losing the application connection

Rotating a database password requires updating both the database identity and every application...

Understanding cPanel database names and account prefixes

cPanel often prefixes database and database-user names with the hosting account identity....

Powered by WHMCompleteSolution