How To Create A MySQL Database Print

  • 0

how to create a MySQL database in cPanel:

Step 1: Log into cPanel:

Make sure you are logged into your cPanel account.

Step 2: Access MySQL Databases:

Scroll down to the Database section on the main cPanel page and click on the "MySQL Databases" icon. This will take you to the MySQL Databases page.

Step 3: Create a New Database:
- In the "Create New Database" section, enter a name for your new database (e.g., "myinfo" or "mydata").
- Click the "Create Database" button. You'll see a verification screen indicating that the database has been created.

4. **Add a New User:**
- Under the "Add New User" section, provide a username for the new user in the "Username" box.
- Enter and confirm a password for the user.
- Click the "Create User" button. A confirmation screen will appear, indicating that the user has been created.

5. **Link User to Database:**
- Click the "Go Back" link.
- In the "Add User to Database" section, ensure that you've selected the correct user and the correct database. Note that the username of the hosting account is typically added at the beginning of both the user and the database with an underscore (_) between them.
- If the user and database selections are correct, click "Submit" to add the user to the database.

6. **Manage User Privileges:**
- After submitting, you'll be taken to a screen called "Manage User Privileges."
- You can assign all privileges to the user by checking the top box that says "All Privileges."
- Click "Make Changes" to save the privileges.

7. **Final Verification:**
- You'll be shown a final verification screen that confirms all the information you've entered.

8. **Complete:** This marks the end of the tutorial. You can return to set up more databases (if allowed by your hosting plan), add or remove users, or delete databases at any time. To return to the main cPanel page, click "HOME" in the upper left corner.

9. **Log Out:**
- Once you're done with cPanel, you can exit by closing your browser or by using the "Logout" button in the upper right corner. If you're using a public computer, always remember to log out of cPanel for security reasons.

Was this answer helpful?

« Back