To create a new database for cPanel users:

 

1- Login to your cPanel.

 

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

 

PzbO9tb7BxRmuG2PtmjZQZUa3I1beeEDHGESrzJCmawytnT60eT3aAEqOptvax8Va1KDWsuWCLj8Y8RCT9Y-nXbL6-oLPV8UOi6DX8eHMN5FoKGq8elY8B9GXHSXytu23ytC0oYe

 

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).

 

u5Lxa_26J8Gpb-gNl4AUdO1ZIcugDGgqwymLDPV0TdQWsTvjgRgUb9ojOtd4_5AmTnQpTVzOIT73FYSeQ0DUP8rPSv7AhSbFS1u5rxUhAoPrB9npQuqK0KAmZzklTrnNkpcUK_SK

 

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

 

4- Press (Go Back).

 

MxEWnoIKZQKw6LXqnNHK_e7T6Alm_veqiuRckCFO36_hgrZQIPUSjtQxywXmdv5KIdRIGy_lPuqCwndktLZ2neZ5l3KvliiwpRDyz420B3yhknhc86MMqgt9gXCW_6A9zWXxQQ3S

 

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).

 

5Tk4m5vzR8OGQK9LNzIb3u5KXexKU37iufMX8C4qGXiCwJ3NWstcTJCXsppiolZPCGYFimh33VG-8n9L_7r1o7q6BKVj36Hyo2Sr1gGwtYgdIQuuRdpRz33P5HDYForj17nKkmsC

 

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

 

gG_hRTi3t2X0TxthBp3EPHuLOom-1PKN0CRRltLDIwWKwjan2VDwnFNi_LRyVtJYuXsyzEXwbWLtsIhWXShnHwu0IPLpK5R9HHNHScET8mYiAQQeosk-RJk2k4oCzuIC87bb1M-B

 

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).

 

4NNCGZLcSXgaqsxtTLuw8USKUxrfBSYMa2zF2L2s1-PIp4LJ3kax2xLHqbngFqGBBP1sCucjwVlvlW1_AWr6KViFvaO_VHifcJv2zCm6Gai9Gtps3xZx2e_5bWjV6fAtdHaalT7l

rQV48MO7zLLN-96BjvuW2jH0tE08TJyqF6zI9cqrvZsDPTr0SPhKoLfNpSssbBBryazGjqaUDZfKLwyJxbHK-jHypmZKYWdf4nB3oAZRlddQTZwQHF0RcPUnHdCulpZQFPL3w4Ci

 

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? 4 Users Found This Useful (7 Votes)