{"id":1879,"date":"2024-06-02T13:03:29","date_gmt":"2024-06-02T13:03:29","guid":{"rendered":"https:\/\/kb.cloudhostgeek.com\/?p=1879"},"modified":"2025-11-05T10:48:54","modified_gmt":"2025-11-05T10:48:54","slug":"set-up-mysql-database","status":"publish","type":"post","link":"https:\/\/www.bigcloudy.com\/knowledge-base\/set-up-mysql-database\/","title":{"rendered":"Creating MySQL databases and users using cPanel"},"content":{"rendered":"\n

Steps to Set Up MySQL Database<\/strong><\/strong><\/h4>\n\n\n\n

1. Firstly, log in to your cPanel account<\/a><\/strong> provided by your web hosting provider<\/a><\/strong>.<\/p>\n\n\n\n

2. Within the cPanel interface, navigate to the “Databases<\/mark><\/strong>” section. This may be prominently displayed on the homepage or categorized under a broader section like “Software<\/mark><\/strong>” or “Web Applications<\/mark><\/strong>.”<\/p>\n\n\n\n

3. Find this option \u201cCreate New Database<\/mark><\/strong>\u201d on within the “Databases<\/mark><\/strong>” section. This could be a button, icon, or menu option depending on your specific cPanel theme.<\/p>\n\n\n\n

4. Enter a descriptive and unique name for your new database. Choose a name that reflects the purpose of the database and adheres to allowed characters (typically alphanumeric characters, underscores, and hyphens).<\/p>\n\n\n\n

5. Click the button labeled “Create Database<\/mark><\/strong>” or a similar action to initiate the process of creating your new MySQL database on the server.<\/p>\n\n\n\n

Steps to Add a User<\/strong><\/h4>\n\n\n\n

1. While the database creation section might offer options for user management as well, some cPanel configurations might have a separate section dedicated to user accounts.<\/p>\n\n\n\n

2. Explore your cPanel interface to locate options related to “MySQL Users<\/mark><\/strong>” or “Database Users<\/mark><\/strong>.”<\/p>\n\n\n\n

\u00a03. Look for an option labeled “Create New User<\/mark><\/strong>” or a similar action within the user management section.<\/p>\n\n\n\n

4. Provide a username for the database user account and enter a secure password twice. Consider using the password generator tool offered by cPanel to ensure a strong and unique password<\/a><\/strong> is created.<\/p>\n\n\n\n

5. Click on the button labeled “Create Use<\/strong>r<\/mark>” or a similar action to finalize the creation of the new user account.<\/p>\n\n\n\n

Connecting User and Database<\/strong><\/h4>\n\n\n\n

1. Locate the section labeled “Add User To Database<\/mark><\/strong>” or a similar functionality within your cPanel interface.<\/p>\n\n\n\n

2. From the provided dropdown menus, choose the user you just created and the database you wish to associate them with.<\/p>\n\n\n\n

3. Click the button labeled “Add<\/mark><\/strong>” or a similar action to establish the connection between the user account and the database.<\/p>\n\n\n\n

Finally, you have successfully created a new MySQL database and associated it with a user account within your cPanel environment. This user account indeed possesses the necessary permissions to interact with the database content for your website or application.<\/p>\n\n\n\n

Additional Information<\/h4>\n\n\n\n