MySQL Guide - Setting up a MySQL Database

1. Click on( MySQL Databases ) in cPanel.

MySQL Guide - Creating the MySQL Database

2. Enter a MySQL database name

3. Click the ( create MySQL database ) button

MySQL Guide - Creating the MySQL User

4. Enter a MySQL user name

5. Enter a MySQL user password

6. Click the ( create MySQL user ) button

MySQL Guide - Grant MySQL user permissions to MySQL database

7. Select MySQL user

8. Select MySQL database

9. Check privileges "ALL"

10. Click the ( Grant permissions ) button

MySQL Guide - MySQL Database Connection Details

Host:

localhost

Database Name:

cpanelusername_databasename

Username:

cpanelusername_mysqlusername

Password:

mysqluserpassword