Let's find out how to create a MySQL Database. MySQL Databases allow you to keep a couple of information in an easy to access manner. This article will be expecting that you are signed into your cPanel. If you are having a problem doing that, make sure you see the article named "How to Login to cPanel".
On the main cPanel page, scroll down to the Database part, and click on the MySQL Databases icon. This will take you to the main MySQL Databases page. There is a box below the heading Create New Database. Type the name of your new database into this box. For example, something like myinfo, or mydata. After that click on Create Database button. This will bring you to the verification screen, showing that the database has been created. At this point you must create and add a user to this database. Click the Go Back link.
Under the heading of Add New User, enter a new user to be added to your database in the Username box. You now must enter and re- enter a password for the user. Click on the Create User button. This takes you to a screen to confirm that the user has been successfully created. Now you need to link the user to the database. Hit on the Go Back link.
In the section where it says Add User to Database, check to make sure that the correct user and the right database are chosen here. NOTE: You will see that the username of the hosting account has been added to the start of both the user and the database with an "_" underscore between them. If you think the user and database are both okay, click on Submit to add the user to the database.
This will bring you to a display called Manage User Privileges. You can assign All Privileges to the user by clicking the top box, then click Make Changes. This will take you to the final verification screen, that will confirm all the information.
This is the last part of the article. You can go back to setup additional databases,as allowed by your hosting plan add or cancel users or erase databases at any moment. Return to the main cPanel page by selecting HOME in the upper left corner.
Now you can get out cPanel by closing your browser, or by using the Logout button in the upper right corner. Hey guys remember, if you are using a public computer, ALWAYS Logout of cPanel before shutting down due to security reasons.
