Database Wizard: create a database and a dedicated application user

A database and a database user are separate objects. An application needs both a database to store data and credentials authorised to access it.

Create and connect

1. Open Database Wizard or Manage My Databases and choose a clear project-specific name.
2. Record the complete name shown by cPanel, including any account prefix.
3. Create a dedicated user with a unique password saved privately.
4. Add that user to the intended database and grant the privileges the application requires. Separate runtime and migration permissions where the deployment supports it.
5. Enter the supplied host, database and username into the application’s private configuration.
6. Run the supported connection or migration check and verify a normal application operation.

Avoid shared credentials

Using one user for every project increases the impact of a leaked password. Do not use a database administrator account for a public website’s routine requests. Keep configuration outside the public root wherever the framework allows.

Changing a database user password can immediately break every application using it. Inventory consumers first and deploy the configuration change together. Never publish a database export as a convenient download link. Use the hosting provider’s support process if the correct host or permission set is unclear.