Knowledgebase

How To Create MySQL Database (db)


Create MySQL Database

How To Create a MySQL(r) database


a.
To setup a MySQL(r) database, first login to your site's cPanel.

image002.jpg



b.
Locate the MySQL(r) Databases icon in the grid of icons and click on it.

image004.jpg



c.
To create a new database, type a desired name for the database in the field labeled New Database. The name should not contain any spaces or symbols in it. Click [Create Database].

image006.jpg



d.
The database has been created. Click [Go Back].

image008.jpg



e.
Now that you've created a database, you have to add a user to access it. To add a user, locate the Create Users section and type in a desired username and password. Make sure to use a long cryptic password for your own security. Click [Create User].

image010.jpg



f.
The new database user has been created. Click [Go Back].

image012.jpg



g.
Now that you've created a database user, you have to link the database user to the database. To add the user to the database, refer to the section labeled Add Users To Your Database. Select the user you just created in the drop-down box labeled User. Select the database you just created in the drop-down box labeled Database. Click [Add User To Database] at the bottom of the section.

image014.jpg



h.
You're done creating the database! You can use the database name, username, and password you just created in this step for installing any script (such as WordPress(r)) that requires you to create a database.