How to Create MySQL Database and MySQL User In CPanel | Hosterpk | Urdu Tutorial

How to Create and Manage a MySQL Database using CPanel – Urdu Tutorial
more info

This article describes how to use cPanel to manage MySQL databases and users. You can add, modify, and delete databases and users, as well as manage user database permissions.

To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.

Creating a database user
To create a MySQL database user, follow these steps:

In the Databases section of the cPanel home screen, click MySQL® Databases.
Under Add New User, type the MySQL username in the Username text box.
In the Password text box, type the user password.
In the Password (Again) text box, retype the user password.
Click Create User.
Changing a user’s password
You can change a database user’s password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.

To change a MySQL user’s password, follow these steps:

In the Databases section of the cPanel home screen, click MySQL® Databases.
Under Current Users, locate the user for which you want to change the password, and then click Set Password.
In the Password and Password (Again) text boxes, type the new password.

Adding a user to a database
To add a MySQL user to a database, follow these steps:

In the Databases section of the cPanel home screen, click MySQL® Databases.
Under Add User to Database, select the user that you want to add in the User list box.
In the Database list box, select the database.
Click Add.
Click the check boxes to grant the user specific privileges, or click the ALL PRIVILEGES check box to grant the user all permissions to the database.
Click Make Changes.
Checking and repairing a database
You can check MySQL databases for errors or possible corruption. If a database check reveals problems, you can repair the database as well.

Article Credit
https://www.a2hosting.com/kb/cpanel/cpanel-database-features/managing-mysql-databases

◄▌● About Us ● ▌►

HosterPK is a Pakistan based web hosting company, providing both providing reliable hosting services since 2009. Although we are a Rawalpindi based company, but as with any online business we provide services to all Pakistan cities with more than 3000 customers from all over Pakistan including Karachi, Lahore, Islamabad, Peshawar Quetta etc.

Since its launch in 2009, HosterPK has achieved a remarkable success, in a very short time, we are currently 3rd largest hosting company in Pakistan with more than 3000 clients. Our vision is to provide international standard services to our clients.

◄▌● Provided Services ● ▌►
HosterPK provides Shared Web Hosting, Reseller Hosting, VPS hosting, Dedicated Server Hosting, Web Development and Domain Registration services to our customers with reliable service and dependable support as the foundation of our operation. We believe in providing rock solid service and a friendly, reachable support to meet the international standards that we set for ourselves. We are always reachable to our clients through phone, email and variety of other ways listed on the website.
Click For More Info
For Free domain name registration in Pakistan click the link below
https://freedomain.pk/
#hosterpk
#howtocreatemySQLdatabase
#urdu
◄▌● Don’ Forget To Subscribe Our Channel ● ▌►
https://www.youtube.com/channel/UCJjL0R8kSNwI3BNuyz-1Flg

◄▌● Our Channel Videos ● ▌►
——————————

◄▌● Our Social Links ● ▌►

Youtube –
Facebook-
Twitter-
Pinterest

You May Also Like

Leave a Reply

Your email address will not be published.

error: Content is protected !!