Create a Database and Link it to a User Name

 

 

To create a new database for cPanel users:

 

1- Login to your cPanel.

 

2- Choose (MySQL Databases) from (DataBases) block.

 

 

Note: Each website control panel differs from one to another depending on its version, but the difference is negligible.

 

3- You will find the block (Create New Database), type the new database name then press (Create database).

 

 

A message will be displayed that the database has been created successfully.

 

4- Press (Go Back).

 

 

After creating the database, you have to create a username that has all privileges to control the database.

 

5- At the same page you will find the block (Add New User) below (MySQL Users), type a username and a password (it’s better to write numbers and letters for the password), then press (Create User).

 

 

6- A message will be displayed that the username and the password have been created successfully, press (Go Back).

 

 

Now there is a final step that you have to do, which is linking the username to the database.

 

7- At the same page you will find (User) and (Database) below the block (Add User To Database), select the username and the database you have created then press (Add).

 

 

Note: When you type a username and a database in a script that requires linking files to databases, the username should be like, for example: (user_dbname).

Finally, you have successfully created a database and added a username to it with these steps.

 

Was this answer helpful? 2 Users Found This Useful (5 Votes)