In short: Create the database and a separate database user in SiteWorx, grant only the permissions the application needs, and use phpMyAdmin for interactive administration—not as a substitute for backups.
Create a database and user
- Open Hosting Features > MySQL > Databases.
- Select Add a MySQL Database.
- Enter a short descriptive database name. SiteWorx normally adds the account prefix automatically.
- Select Create User, generate a strong password and record the final prefixed username.
- Grant the permissions required by the application and save.
Connect the application
Use the complete database name and username shown by SiteWorx. For applications on the same hosting account, the database host is normally localhost. Store the password in the application's protected configuration and never publish it in a repository or support screenshot.
Open phpMyAdmin
Go to Hosting Features > MySQL > phpMyAdmin. Use it to inspect tables, run carefully reviewed queries, and import or export manageable datasets.
Before destructive SQL: Export the affected database and verify the backup. Operations such as DROP, TRUNCATE and bulk UPDATE may be immediate and difficult to reverse.
Good database hygiene
- Use a different database user for unrelated applications.
- Do not grant remote access unless it is genuinely required and restricted.
- Remove users that are no longer used.
- Keep the application and database schema migrations in sync.
- Use SiteWorx backups or another tested backup process for recovery.
Further guidance
See the InterWorx database guide and the official phpMyAdmin documentation.
