知識庫

How to add a user to a database and add privileges?  列印本文

Add a user to a database

To add a user to a database, perform the following steps:

  1. In the Add User To Database section of the interface, select the desired user and database from the menus.
  2. Click Add. The MySQL Account Maintenance interface will appear.
  3. Select the checkboxes that correspond to the privileges that you wish to grant to the user.

    Note:

    To grant all of the available privileges to the user, select the ALL PRIVILEGES checkbox.

     

  4. Click Make Changes.

  5. Click Go Back to return to the main interface.

For more information about user privileges, read the MySQL documentation.

這篇文章有幫助嗎?

相關文章

How to import database via phpMyAdmin in cPanel?
1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...
How to edit database table via phpMyAdmin in cPanel?
1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...
How to delete database table via phpMyAdmin in cPanel?
1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...
How to optimize database via phpMyAdmin in cPanel?
1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...
How to Repair database via phpMyAdmin in cPanel?
1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...