MySQL Guide
Table of Contents
This guide will walk you through the steps you need to setup a MySQL Database, User, and Permissions. While this guide
is helpful, cPanel's new
MySQL Wizard will progress you through each step needed to setup a database for use. Feel free to either step through this guide or use the MySQL
Wizard located within your cPanel to setup your databases.
Setting up a MySQL Database |
1. Click on
( MySQL Databases ) in
cPanel.
Creating the MySQL Database |
2. Enter a MySQL database name
3. Click the
( create MySQL database )
button
Creating the MySQL User |
4. Enter a MySQL user name
5. Enter a MySQL user password
6. Click the
( create MySQL user ) button
Grant MySQL user permissions to the Database |
7. Select MySQL user
8. Select MySQL database
9. Check privileges "ALL"
10. Click the
( Grant permissions )
button
MySQL Database Connection Details |
| Host: | localhost |
| Database Name: | cpanelusername_databasename |
| Username: | cpanelusername_mysqlusername |
| Password: | mysqluserpassword |
Note that the MySQL user and database are preceeded by your cPanel username. If you are setting up a script, for example, and need to enter
your MySQL username and database, be sure to include the full username and database with the cPanel username appended to the beginning.
