A guide to creating and modifying MySQL databases in cPanel
You can create and manage MySQL databases from cPanel.
- Log in to cPanel.
- In the Databases section, click Manage My Databases (called MySQL Databases in some versions).
- Under Create New Database, type a name and click Create Database.
- Under Add New User, create a database user with a strong password.
- Under Add User To Database, pick the user and the database, click Add, then tick ALL PRIVILEGES and click Make Changes.
Your database name and username start with your cPanel username (for example username_shop). Use those full names, with localhost as the host, in your website's configuration.
To rename or delete a database, or change a user's password, use the same page. To browse or edit the data itself, see Using phpMyAdmin to Manage Databases.