[VIDEO] How to Create a MySQL Database in cPanel




Description : How to Create a MySQL Database in cPanel.


Note : This tutorial will teach you how to create a database and how to add an authorized user to it. Also, your database name along with your username will always include your cpanel account username and it should be taken into consideration when using the database (cpanelusername_mydatabasename is the right name to use to populate the configuration of a CMS)


1) Login to your cPanel account (mydomain.com/cpanel)

2) Click on the MySQL Databases icon within your control panel.

3) In the New Database filed, type the name of the database you want and hit Create Database.
Your database is now created.

4) Now, we will create a new user, in the Username / Password fields, type the username and the password you want. You can use the password generator for a more secured password. Hit create user.
Your user is now created.

5) We need to allow the user to interact with the database. At the bottom of your current screen you have the Add User to Database with 2 drop downs. You would need to select the database and the username you have just created and click submit.
Then, you can select the privileges of the user on the database. Generally, you would need to select all privileges and then hit the Make Changes button.

That's it, you have now created a database along with an authorized users. You can now use it in your web applications.
  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

[VIDEO] How to Create An Addon Domain

Description : Disclaimer : This how to assumes that you have changed your DNS settings at your...

Is the Shell Access Available on Shared Web Hosting Accounts?

Is the Shell Access (SSH) available on our Shared Web Hosting offers?Yes, we do offer a SSH...

How To Set Up A Cron Job with cPanel

All of our shared web hosting plans are coming with the possibility to set up cron...

[VIDEO] How to Perform a cPanel Backup

Description : Learn How to create your own Website BackupNote : With this tutorial you'll be...

[VIDEO] How to change your cPanel Layout

 Description : Learn how to change your cPanel layout1) Login to your cPanel web hosting...