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

You might be reading this while on lockdown yourself, or while watching the coronavirus disease (COVID-19) spread rapidly and without discrimination, make its way across the world. Help us fight against the COVID-19 pandemic.The donation supports our work, our children, our families, and our community that affect by COVID-19
PROFESSIONAL HOSTING RECOMMENDATION
Coupon code for JULY 2020.
Hawkhost Recurring Coupon.
Service
Discount
Coupon Code
Shared
25% OFF Recurring
july2020
Semi-Dedicated
25% OFF Recurring
sdjuly2020
Reseller
30% OFF Recurring
rjuly2020
Order at: HERE
PROFESSIONAL HOSTING RECOMMENDATION
Coupon code for JULY 2020.
Hawkhost Recurring Coupon.
Service /Coupon Code
Shared
25% OFF Recurring
july2020
Semi-Dedicated
25% OFF Recurring
sdjuly2020
Reseller
30% OFF Recurring
rjuly2020
Order at: HERE

Leave a Reply

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

four × four =