How to Add a User to a MySQL Database

January 5, 2023 / MySQL

This guide explains how to add a user to a MySQL database. The most extensively used open-source relational database, MySQL is used as the main relational data storage for numerous well-known websites, programmes, and commercial goods.

Let us follow the steps:

  1. Log in to your cPanel account.
  2. Select the “Databases” category, then click on the “MySQL Database” option.
  3. Find the “Add User To Database” option and fill in the information.
  4. Add the “User” and “Database” and click on the “Add” button.
    Add user
  5. You will enter a new “Manage User Privileges” page.
  6. You can select the privileges here. It’s acceptable to select “All privileges” for the majority of applications.
    All privileges
  7. Click on the “Make Changes” button.
    Make Changes
  8. You will get a success message as shown below.
    success message

This way you can add a user to a MySQL database. Hope you liked our article. For any query contact our support staff.

In this manner, a user can be added to a MySQL database. We hope you enjoyed reading this. Contact our support staff with any questions.

Spread the love