How to create MySQL database ? Print

To create a MySQL database, the process depends on how you're accessing your server. Since you're using 4GoodHosting (which uses cPanel), here are the easiest ways to do it:

Method 1: Create a MySQL Database in cPanel (Recommended for 4GoodHosting)

Step-by-Step:

1. Log in to cPanel
   URL usually looks like: https://yourdomain.com/cpanel

2. Find the "MySQL® Databases" section
   Under the Databases heading.

3. Create a New Database

   • In the "Create New Database" box, enter your database name.

   • Click Create Database.

4. Create a Database User

   • Scroll down to MySQL Users > Add New User.

   • Enter username and password.

   • Click Create User.

5. Assign User to Database

   • Under "Add User to Database", select the user and database you created.

   • Click Add.

   • On the next screen, check All Privileges, then click Make Changes.

 

If you’re using phpMyAdmin:

 

• Go to phpMyAdmin from cPanel.

• Click on the "New" link in the sidebar.

• Enter a database name.

• Click Create.