{"id":3890,"date":"2024-06-28T10:17:24","date_gmt":"2024-06-28T10:17:24","guid":{"rendered":"https:\/\/kb.cloudhostgeek.com\/?p=3890"},"modified":"2025-11-05T10:48:09","modified_gmt":"2025-11-05T10:48:09","slug":"create-database-and-database-user-cpanel","status":"publish","type":"post","link":"https:\/\/www.bigcloudy.com\/knowledge-base\/create-database-and-database-user-cpanel\/","title":{"rendered":"Creating MySQL databases and users using cPanel"},"content":{"rendered":"\n

cPanel is a widely used web hosting control panel that empowers website owners to efficiently manage different aspects of their web hosting accounts, including databases. Its intuitive graphical interface enables users to effortlessly create, configure, and manage databases without requiring extensive technical expertise.\u00a0\u00a0In this article we will understand the process to create database easily.<\/p>\n\n\n\n

Simple Guide to Create Database in cPanel<\/h4>\n\n\n\n

1. Log in to cPanel<\/strong><\/p>\n\n\n\n

Access your cPanel account<\/a><\/strong> using your provided login credentials. You can typically log in by visiting your website’s URL followed by “\/cpanel<\/mark><\/strong>” (e.g., www.example.com\/cpanel).<\/p>\n\n\n\n

2. Locate the Databases section<\/strong><\/p>\n\n\n\n

Once logged in, navigate to the “Databases<\/mark><\/strong>” section. This area usually contains icons or options related to databases, MySQL.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"Database<\/figure>\n\n\n\n
<\/div>\n\n\n\n

3. Create a New Database<\/strong><\/p>\n\n\n\n

Look for an option to “create a new database<\/mark><\/strong>” and click on it to proceed.\u00a0\u00a0<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"Create<\/figure>\n\n\n\n
<\/div>\n\n\n\n

4. Create a Database User<\/strong><\/p>\n\n\n\n

You will be prompted to provide specific details for the “new database<\/mark><\/strong>“, such as the database name, username, and password. Choose a name that is relevant to your application or website and set a secure password. Keep note of the database name, username, and password, as you’ll need them later.\u00a0\u00a0<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"Add<\/figure>\n\n\n\n
<\/div>\n\n\n\n

5. Assign a User to the Database<\/strong><\/p>\n\n\n\n

After creating the database, you’ll need to assign a user to it. This step helps enhance the security of your database. You can either “create a new user<\/mark><\/strong>” or assign an existing user to the database.\u00a0\u00a0<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"Add<\/figure>\n\n\n\n
<\/div>\n\n\n\n

6. Configure User Privileges<\/strong><\/p>\n\n\n\n

Set appropriate privileges<\/mark> <\/strong>for the user you’ve assigned to the database. Privileges determine what actions the user can perform within the database. Generally, you’d want to grant the user full privileges to ensure smooth database operations for your application.\u00a0\u00a0<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"User<\/figure>\n\n\n\n
<\/div>\n\n\n\n

7. Save the changes<\/strong><\/p>\n\n\n\n

Once you’ve completed the above steps, save the changes. The cPanel interface will likely have a “Create<\/mark><\/strong>” or “Save<\/mark><\/strong>” button to finalize the database creation process.\u00a0\u00a0<\/p>\n\n\n\n

 Following these steps, you should have successfully created a database using cPanel. You can now use this database for your website or web application, and you may need to configure your application to connect to the database using the provided database details (database name, username, and password).  <\/p>\n\n\n\n

If you encounter any difficulties, please don’t hesitate to contact\u00a0BigCloudy\u00a0Support<\/a><\/strong> for assistance.\u00a0<\/p>\n\n\n\n

Additional Resources<\/strong><\/p>\n\n\n\n