How to Configure MySQL in cPanel 1

How to Configure MySQL in cPanel

Posted on 323 views

MySQL Database lets you save (and access) large amounts of information with ease. This facility required by many web-based applications, such as bulletin boards, Content Management System (CMS), and others. You need to create your own database prior to using it. Only users who have the privilege or a special authority can access a database.

How to Create Database in MySQL?

1. Login to cPanel account.

2. Search “Databases” then click “MySQL Database Wizard.”

click-mysql-database-wizard

3. You will be redirected to the MySQL Database Wizard page. Enter your database name, and then click the Next Step button to continue.

mysql-database-wizard-page

4. The database have been created.

How to add user to database?

5. Create database user. Enter the username and password that you want, and then click the Create User button.
create-database-users

6. Select privilege or authority can be made by that user. You can choose whether the user can add to the database, indexing, delete, update, and others. In this example we choose the option All Privileges.
Then click the Next Step button to continue.
add-user-to-database

7. Done.

complete-task

PROFESSIONAL HOSTING RECOMMENDATION
Coupon code for SEPTEMBER 2020.
Hawkhost Recurring Coupon.
Service
Discount
Coupon Code
Shared
25% OFF Recurring
september2020
Semi-Dedicated
25% OFF Recurring
sdseptember2020
Reseller
30% OFF Recurring
rseptember2020
Order at: HERE
PROFESSIONAL HOSTING RECOMMENDATION
Coupon code for SEPTEMBER 2020.
Hawkhost Recurring Coupon.
Service /Coupon Code
Shared
25% OFF Recurring
september2020
Semi-Dedicated
25% OFF Recurring
sdseptember2020
Reseller
30% OFF Recurring
rseptember2020
Order at: HERE

Leave a Reply

Your email address will not be published. Required fields are marked *

13 + fourteen =