How do I create databases and manage them? Print

Creating and managing MySQL databases in cPanel is easy. Just follow these steps:

Create a New Database

1. Log in to cPanel, then click on "MySQL Databases" under the Databases section.
2. Under "Create New Database", enter a name for your database (e.g., store, forum, etc.).
3. Click "Create Database" to add it.

Create a New Database User

1. Scroll to the "MySQL Users" section.
2. Enter a username and password.
3. Click "Create User".

You can reuse the same user credentials for multiple databases if needed.

Assign User to Database

1. In the "Add User to Database" section: Select the user from the left dropdown. / Select the database from the right dropdown.
2. Click "Add" and assign the necessary privileges (usually All Privileges).

Manage the Database

Scroll down to the bottom of the MySQL Databases page and click phpMyAdmin to manage your database contents, import/export SQL files, or run queries.