Create Mysql Database

Step 1: Log in to cPanel

1. Access your cPanel by going to http://yourdomain.com/cpanel (replace with your actual domain). You can also login to cPanel from Members Arear ->
   

2. Enter your username and password

Step 2: Find the MySQL Databases Section

1. In the cPanel dashboard, look for the "Databases" section

2. Click on "MySQL Databases"

Step 3: Create a New Database

1. In the "Create New Database" section:

   • Enter a name for your database (usually prefixed with your cPanel username)

   • Click "Create Database"

Step 4: Create a Database User

1. Scroll down to "MySQL Users" section

2. Enter a username and password (make it strong!)

3. Click "Create User"

Step 5: Add User to Database

1. In the "Add User to Database" section:

   • Select the user you just created from the dropdown

   • Select the database you created

   • Click "Add"

Step 6: Set User Privileges

1. On the next screen, check all privileges or select specific ones needed

2. Click "Make Changes" to save the permissions

Step 7: Note Your Connection Details

You'll need these details to connect to your database:

• Database name: cpanelusername_dbname

• Username: cpanelusername_dbuser

• Password: [the one you set]

• Hostname: localhost

Alternative Method (Using Database Wizard)

cPanel also offers a simpler wizard:

1. In cPanel, go to "MySQL Database Wizard"

2. Follow the step-by-step instructions to:

   • Create a database

   • Create a user

   • Assign privileges

   • Connect them together

How helpful was this article to you?