### Granting Permissions to a MySQL User in cPanel
**Overview**
After creating a MySQL user on your gptservers.net hosting account, you must grant them permissions to access specific databases. This process links the user to a database and defines what actions they can perform (e.g., read, write, or modify data).
**Steps to Grant Permissions**
1. **Log in to cPanel**: Access your cPanel dashboard at `https://yourdomain.com/cpanel` or via your gptservers.net Client Area.
2. **Navigate to MySQL Databases**: In the **Databases** section, click the **MySQL Databases** icon.
3. **Assign User to Database**:
- Scroll to the **Add User to Database** section.
- **User**: Select the user from the dropdown menu (appears as `cpaneluser_username`, e.g., `cpaneluser_dbuser`).
- **Database**: Select the database from the dropdown menu (appears as `cpaneluser_databasename`, e.g., `cpaneluser_mydatabase`).
4. **Set Privileges**:
- Click **Make Changes** or **Submit** to open the privileges screen.
- Check the boxes for the permissions you want to grant (e.g., `SELECT`, `INSERT`, `UPDATE`, `DELETE`, or `ALL PRIVILEGES` for full access).
- Common privileges include:
- `SELECT`: Read data.
- `INSERT`: Add new data.
- `UPDATE`: Modify existing data.
- `DELETE`: Remove data.
- `CREATE`/`DROP`: Manage tables or databases.
5. **Grant Permissions**: Click **Make Changes** (or **Add User to Db** in older cPanel versions) to assign the selected permissions.
- You’ll see a confirmation like: *User "cpaneluser_dbuser" was successfully added to database "cpaneluser_mydatabase".*
**Troubleshooting**
- **Insufficient Permissions**: Ensure you’ve granted all necessary privileges for the user’s intended tasks (e.g., `ALL PRIVILEGES` for full control, or specific ones like `SELECT` and `INSERT` for limited access). Check or modify permissions in **MySQL Databases** > **Manage User Privileges**.
- **User/Database Not Listed**: Verify the user and database exist in **MySQL Databases** > **Current Users** or **Current Databases**. Create them if missing (see earlier guides on creating a database or user).
- **Connection Issues**: When connecting (e.g., via phpMyAdmin or scripts):
- **Host**: Use `localhost`.
- **Username**: Full username (e.g., `cpaneluser_dbuser`).
- **Password**: As set during user creation.
- **Database**: Full database name (e.g., `cpaneluser_mydatabase`).
- **Application Errors**: For CMS like WordPress or Joomla, ensure the configuration file (e.g., `wp-config.php` or `configuration.php`) uses the correct database name, username, and password.
- **Quota Limits**: Confirm your hosting plan allows additional user-database connections in **MySQL Databases** > **Current Databases**.
- **Propagation Delays**: If the database or domain is new, allow 24–48 hours for DNS propagation if external access is involved.
For further assistance, contact support@gptservers.net with your domain, username, database name, and any error details. Your MySQL user is now ready to access the assigned database with the specified permissions!
---
