Chat with us live!

To create a MySQL database:

- Go to MySQL Manager in your cPanel Control Panel
- Type the name you wish to give your database
- Click the Add Database button
- At the bottom of mySQL Manager under Users type a database user name and password
- Click the Add User button
- If you click the Refresh button on your browser toolbar to reload the mySQL Manager page at this point at the bottom of the "Databases" section you should see your new user listed in the dropdown menu after "User:" and your new database listed in the "DB:" dropdown menu. If you do just click the Add User to DB button to add your user to your database and you're done.

Now that you have created a database, created a database user and have granted that user access to the database you created you can begin using your database.

Make sure you are using the correct database name, database user name and password which you set in mySQL Manager. Note that a prefix consisting of your cPanel user name and an underscore will be automatically added to both your database and database user names.

Example:

If the user name for your cPanel account is "johndoe" and you have created a database named "phpbb" and a database user named "bbuser" then the correct database and database user names will be as follows:

database = johndoe_phpbb
database user = johndoe_bbuser

Here is a video tutorial on creating mySQL databases:

Add to Favourites
Print this Article