Create MySQL Database and DB User. Connect MySQL DB and DB User

To create a MySQL database and user

Step#1. Log into your cPanel control panel.
Step#2. Click on "MySQL Databases" under the "Databases" section.
Step#3. At the next page, enter the new database name under the Create New Database field to create a new database.
You can create a new user by specifying one under "Add New User".

To make sure that the MySQL users have access to specific MySQL databases

Step#4. Link them at the bottom of the page under "Add User to Database". Click MySql Databases under the "Databases"
Step#5. The next screen will allow you to grant privileges for the MySQL user to the database you selected.

To connect to a database and manage Database tables

Step#6. Use phpMyAdmin. You can access this by clicking the icon in the Databases section of cPanel.

  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

Disabling mod_security via cPanel Modsec Manager plugin

What is Mod_Security and why is it importantIn apache web server Mod_security module helps to...

How to force HTTP to HTTPS Automatically

First make sure Free SSL is installed in your hosting account. How to verify the SSL activated,...

How to add Multiple Domains in a single CPanel Account

You can add multiple domains in the single cPanel account with our premium packages.  Follow the...

Step by step instructions to take full backup in cPanel

Follow the below step by step instructions to take full backup in cPanel: Step1:Log into...

Powered by WHMCompleteSolution