news
Gaming Servers Page Already Available. See Live Demo
Locale Settings
My Hostarina
logo
  • Web Hosting
    Shared Hosting
    Shared Hosting

    For Small to Medium Websites

    Unlimited Hosting
    Unlimited Hosting

    For Blogs, Wordpress, Ecommerce Websites

    Free Website Migration
    1. Buy any web hosting package
    2. Request a site migration from your account
    3. Sit back and let us handle things at a time that suits you
    Get Started

  • Servers
    High Performance VPS
    High Performance VPS

    Your own VPS server to securely run the application with peak performance.

    Cloud VPS Servers
    Cloud VPS Servers

    Your Own Virtual Storage Server for using as Files storage space

    VPS Simple. Fast. Reliable

    When purchasing a VPS, it comes with a list of Operating Systems templates, all Linux based, which can be installed in a couple of clicks, saving you the hassle of doing it yourself.

  • SSL Certificates
    Rapid SSL
    Geo Trust SSL
    Symantec SSL
    Thawte SSL
    Comodo SSL
    Sectigo SSL
    Digicert SSL
    cWatch SSL
    Protect Your Brand

    Trust is everything. And, that's never been more true than in today's world, where there are now over 4 million data breaches per day. So, how do you ensure that your reputation and trustworthiness aren't at risk? Implement proper security protections that users can see and feel. When consumers trust your security, they trust your brand.

    SSL Installation

  • Domains
    My Domains
    My Domains

    Your Domains with us

    Domain Register
    Domain Register

    Find the perfect domain name.

    Domain Whois
    Domain Whois

    Lookup tool to find WHOIS information.

    Domains Prices
    Domains Prices

    Domain Pricing List

    Domain Transfer
    Domain Transfer

    Want to transfer domain to Hostarina?

  • Billing
    Payment Options
    Payment Options

    Our Supported Payment Options

    Affiliates
    Affiliates

    Latest News about our services

  • Support
    Website Migration
    Website Migration

    Buy Web hosting and Request a free website migration

    Announcements
    Announcements

    Latest News about our services

    Knowledgebase
    Knowledgebase

    Knowledgebase Articles to solve your problems

    Network Status
    Network Status

    Our Servers and Services Status information

How to Manage MySQL Databases and Users in cPanel?
Useful : 0
Views : 0


  • How to Access phpMyAdmin in cPanel?
  • How to Change MySQL DB Collation Settings using PHPMyAdmin?
  • How to Configure Remote MySQL Access in CPanel?
  • How to Manage MySQL Databases and Users in cPanel?
  • How to Optimize and Repair MySQL Databases using PHPMyAdmin?
  • How to Use PHPMyAdmin to Copy a MySQL Database?
  • What is Database & PHPmyAdmin?

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.


<iframe src="https://www.youtube.com/embed/e6HQafFRwEc" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe>



MANAGING DATABASE USERS

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:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Add New User, type the MySQL username in the Username text box.
  3. In the Password text box, type the user password.
  4. In the Password (Again) text box, retype the user password.

Note: You can click Password Generator and cPanel generates a random, strong password for you.

 

5. 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:

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

Note: You can click Password Generator and cPanel generates a random, strong password for you.

 

4. Click Change Password. The new password takes effect immediately.


Renaming a user

To rename a MySQL user, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Current Users, locate the user that you want to rename, and then click Rename.
  3. In the text box, type the new name, and then click Proceed.


Deleting a user

When you delete a user, the user and its database permissions are deleted.

To delete a MySQL user, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Current Users, locate the user that you want to delete, and then click the red X icon.
  3. Click Delete User to confirm the deletion.


MANAGING DATABASES

After you create a database user, you are ready to create a database and associate the user with the new database.


Creating a database

To create a MySQL database, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Create New Database, type the name of the database in the New Database text box.
  3. Click Create Database.

Note: When you create a database, your username is added to the database name. For example, if your username is username, and you create a database named database, the actual MySQL database name is username_database.

 

Adding a user to a database

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

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Add User to Database, select the user that you want to add in the User list box.
  3. In the Database list box, select the database.
  4. Click Add.
  5. 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.
  6. 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.

To check and repair a database, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. To check a database:
  • Under Modify Databases, select the database in the Check DB list box.
  • Click Check DB.

      3. If a database check indicates problems with a database, you can repair it:

  • Under Modify Databases, select the database in the Repair DB list box.
  • Click Repair DB.


Removing a user from a database

When you remove a user from a database, the user can no longer access the database.

To remove a MySQL user from a database, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Current Databases, locate the user that you want to remove, and then click the red X icon.
  3. Click Delete User from Database to confirm the deletion.


Deleting a database

Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.

Note: When you delete a database, its associated users are not deleted. However, all permissions users have for that database are deleted.

 

To delete a MySQL database, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Current Databases, locate the database that you want to delete, and then click Delete Database.
  3. Click Delete Database to confirm the deletion.
Domains
  • Register a New Domain
  • Transfer Domain to Us
Support
  • Announcements
  • Knowledgebase
  • Network Status
  • Contact Us
Servers
  • High Performance VPS
  • Virtual Dedicated Server
  • Dedicated Servers
  • VPS Storage Servers
Company
  • About Us
  • Privacy Policy
  • Unlimited Policy
  • Acceptable Use Policy
  • Anti-Spam Policy
  • Refund Policy
  • Terms of services
  • Copyright © 2022 hostarina. All Rights Reserved.