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 MariaDB databases when the service allows it. Access-host…

Assigning a database user and choosing its privileges in cPanel A database user needs an explicit assignment to the database it will access. Privileges determine whether it can read rows, change data or alter table…

Assigning a database user only the privileges an application needs A database user should have the permissions its application actually needs on the intended database. Separating application identities makes credential…

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 imported before running it again. A browser's upload-complete…

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 database itself is supported. Choose an import method that…

Creating a MySQL or MariaDB database in cPanel Create a database through cPanel so the hosting account owns and tracks it correctly. The database stores application data; it is separate from the…

Creating a database user in cPanel A database user is an application credential, not a cPanel login. Creating a separate user for each application makes it easier to control access and…

Deleting an unused database from cPanel Delete a database only after confirming that no live website, staging site, scheduled task or reporting integration still uses it. Removing it destroys…

Diagnosing database access denied after a hosting migration An access-denied database error after migration usually points to the connection identity, password, host or grants. It differs from a timeout, missing…

Renaming a cPanel database without losing the application connection Renaming a database changes the identifier an application uses to connect. It does not automatically update every configuration file, scheduled command…

Rotating a database password without losing the application connection Rotating a database password requires updating both the database identity and every application that uses it. Plan the switch so a changed credential…

Understanding cPanel database names and account prefixes cPanel often prefixes database and database-user names with the hosting account identity. Applications need the full names shown by the panel, not just…