CP MySQL, cPanel

Creating MySQL databases and users using cPanel

2 minutes

10 Views

Steps to Set Up MySQL Database

1. Firstly, log in to your cPanel account provided by your web hosting provider.

2. Within the cPanel interface, navigate to the “Databases” section. This may be prominently displayed on the homepage or categorized under a broader section like “Software” or “Web Applications.”

3. Find this option “Create New Database” on within the “Databases” section. This could be a button, icon, or menu option depending on your specific cPanel theme.

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

5. Click the button labeled “Create Database” or a similar action to initiate the process of creating your new MySQL database on the server.

Steps to Add a User

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.

2. Explore your cPanel interface to locate options related to “MySQL Users” or “Database Users.”

3. Look for an option labeled “Create New User” or a similar action within the user management section.

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 is created.

5. Click on the button labeled “Create User” or a similar action to finalize the creation of the new user account.

Connecting User and Database

1. Locate the section labeled “Add User To Database” or a similar functionality within your cPanel interface.

2. From the provided dropdown menus, choose the user you just created and the database you wish to associate them with.

3. Click the button labeled “Add” or a similar action to establish the connection between the user account and the database.

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.