How to create a MySQL database

Creating a MySQL Database

To create a new database and user:

1. Log in to cPanel
2. Go to Databases > MySQL Databases
3. Under Create New Database, enter a database name
4. Click Create Database
5. Scroll to MySQL Users > Add New User
6. Enter a username and strong password
7. Click Create User
8. Scroll to Add User to Database
9. Select the user and database, click Add
10. Select the privileges (ALL PRIVILEGES for full access)
11. Click Make Changes

Remote Access: To allow remote database connections, add your IP address under Remote MySQL.