{"id":304,"date":"2024-02-15T12:27:03","date_gmt":"2024-02-15T12:27:03","guid":{"rendered":"https:\/\/www.webhostinghyderabad.co.in\/tutorials\/?p=304"},"modified":"2024-02-15T12:33:19","modified_gmt":"2024-02-15T12:33:19","slug":"create-database-on-cpanel","status":"publish","type":"post","link":"https:\/\/www.webhostinghyderabad.co.in\/tutorials\/create-database-on-cpanel\/","title":{"rendered":"How to Create a Database in Your cPanel Account"},"content":{"rendered":"\n

create Database on cPanel – Here are the instructions for setting up a database within your cPanel account:<\/p>\n\n\n\n

To establish a functional database, you must undertake three essential steps: creating the database itself, generating a user for database access, and linking the user to the database.<\/p>\n\n\n\n

create Database on cpanel<\/h2>\n\n\n\n

Creating the Database<\/h2>\n\n\n\n

1. Log in to your Hosting <\/a>cPanel account. using your cPanel credentials <\/p>\n\n\n\n

\"create<\/figure>\n\n\n\n

2. Click on MySQL\u00ae<\/strong> Databases<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3. In the “Create New Database” section, input a name for your database, and then proceed to click on “Create Database”.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Creating the User<\/h2>\n\n\n\n

4 Navigate to the “Add New User” section. Input a username and password, then proceed to click on “Create User”.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Linking the User to the Database<\/h2>\n\n\n\n

Scroll down to Add User to Database. Under the dropdown box select the appropriate user and database<\/a> you have created, then click\u00a0Add<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

6. You will now be asked to assign Permissions\/Privileges the user can have on the database. Select the\u00a0ALL PRIVILEGES<\/strong>\u00a0tick box, then click\u00a0Make Changes<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Table of Contents<\/h2>