How to create a new MySQL database user?

Having multiple databases will allow you to manage large amounts of information over the web easily. If you wish to create a new MySQL database and user, please follow the steps below.

Create MySQL via cPanel

Step 1. Log in to the cPanel.

cPanel-Login-SS | MySQL

Step 2. Under Databases panel, click on MySQL® Databases.

MySQL

Step 3. Type in the database name you want to use and click Create Database button. (If there is an existing database proceed to Step 4.)MySQL

You will be redirected to a message prompt that it was successful. (Please note that the database created is only an example.)MySQL

Step 4. Type in the New user and password and click Create User button. (Please note that the username created is only an example.)

MySQL

You will be redirected to a message prompt that it was successful.MySQL

Step 5. The user must be added to the database. Choose on the user and database and click on Add button. (Please note that the user and database created are only an example.)

MySQL

Step 6. Click on the check box for ALL PRIVILEGES and click Make Changes button.MySQL

You will be redirected to a message prompt that it was successful.MySQL

(Visited 279 times, 1 visits today)