WEB HOSTING SUPPORT NETWORK
     
 

Associating a MySQL user with a database

To associate a MySQL user with a database, you need to grant some privileges for that MySQL user to the database by following these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the Privileges tab.
  4. Select your database from the Database name drop-down menu.
  5. Select the MySQL user from the MySQL user drop-down menu.
  6. From the Privileges list, select the privileges that you wish to grant the MySQL user to the database.
  7. Click on the Associate button.

Note: By default, your master MySQL user has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account.