Confirm the application database engine and supported version. This guide describes the MySQL or MariaDB workflow, not PostgreSQL or MongoDB. Check account allowances and decide the database name, username and required privileges before configuring the application.

1. Open Database > Database Wizard in the end-user panel. Create the application database and note the full resulting name, including any account prefix.
2. Create a dedicated database user with a unique strong password. Store it in your password manager or protected deployment secret store, not in a public file.
3. Add the user to the exact database. Select the privileges the application requires; an installer may require schema-changing permissions that a steady-state runtime does not need.
4. Enter the full database name, user, password and documented host in the application private configuration. Do not assume that the visible short name is the complete SQL identifier.
5. Run the application connection or installation test. Keep configuration files outside the document root where the application supports that arrangement.
6. If remote access is necessary, separately authorize the specific client host and secure the network path. Do not enable unrestricted remote database access merely to make a local application connect.

No. Complete the user-to-database assignment and privilege step. A valid credential without permission on the application database can still produce an access-denied error.

Confirm the application can read and perform an intended write in its own database. Verify that its user is not assigned to unrelated databases. Include the database in backups and test that its credentials are restored or rotated appropriately during recovery.

For access denied, compare the full username, host and password with the assigned database privileges. For unknown database, check the full prefixed name. Avoid resetting the global database root password or granting every server privilege to solve a single application credential error.

• Creating and storing a Webuzo account backup
• Restoring a Webuzo account from a backup
• Adding a domain and website in Webuzo
• Creating a Webuzo hosting package and user

• Webuzo: Database Wizard
• Webuzo: Add User To Database
• Webuzo: Add Database