Site5 - Built For Designers & Developers MENU
Home  ›  Databases  ›  MySQL: Create a database

MySQL: Create a database

4 Comments

Databases allow you to store information in an easy to access manner. The databases themselves are not easily read by humans. MySQL databases are required by many web applications including many blogs, content management systems (CMS), forums, and others. To use a database, you’ll need to create it. Only MySQL Users (different than mail or other users) that have privileges to access a database can read from or write to that database.

If you would like instructions on to how add,remove or modify a MySQL user from within your SiteAdmin/cPanel, check out this guide here.



 

Create a MySQL database in SiteAdmin

This demo assumes you’ve already logged in to SiteAdmin

1) Click the Databases button from the left-hand menu, then click Manage Databases & Users

2) Enter the name you wish to use

3) Click Create Database and Add User
 

4) Enter the username you wish to create for this database

5) Enter a secure password for this user or click the Generate Password button.

Please take careful note of this password, as you can not retrieve it later. You can however change it at a later date if needed.

6) Click Finish
 

That’s it! You now know how to create a new MySQL database and user.



 

Create a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel

Now let’s learn how to create a MySQL database

1) Click MySQL Database Wizard 

2) Enter a name for the new database

3) Click Next Step

4) Now we have to create a user for this database… enter a username here

5) Then enter and confirm a password

6) When ready, click Create User

7) Check here to assign All Privileges to the user…

8) … then click Next Step

That’s it! The MySQL database has been created, and the new user added to the database. The database name, username and password will all be needed for scripts that need to connect to the database

This is the end of the tutorial. You now know how to create and setup MySQL databases

Still have a question? Or need help?
See an error in this article or want to suggest a missing topic? Please leave us a comment below! If you need technical support with your account, please email us, chat live with a representative, or call us!

4 Comments

  • What is the port to be used when creating the connection to the mySQL DB?
    Regards,
    Cor

    • 3306

  • Thnks for the vid, but now how does one create a database.

    • Hello Jim,

      If you follow the steps in this article, it will create both the database and the user. The database name is set on step 2 of this article.

      Happy Hosting!

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.