cPanel includes MySQL Database Wizard and phpMyAdmin for creating and managing databases.
Creating a Database
- In cPanel, go to MySQL Databases
- Under Create New Database, enter a name (it will be prefixed with your username)
- Click Create Database
- Under Add New User, create a database user with a strong password
- Under Add User To Database, select the user and database, then click Add
- Check ALL PRIVILEGES and click Make Changes
Using phpMyAdmin
Click phpMyAdmin to manage your databases in a web interface. You can:
- Run SQL queries
- Import/export databases
- Create tables and edit data
When configuring applications (e.g. WordPress), use the full database name (username_dbname), the database user, and the password you set.
