### Creating a MySQL User in cPanel
**Overview**
To use a MySQL database on your gptservers.net hosting account, you must first create a MySQL user. This user won’t automatically have access to any database; you must explicitly grant permissions to specific databases afterward. For details on granting permissions, refer to cPanel’s documentation or gptservers.net’s knowledgebase on granting user permissions to a MySQL database.
**Steps to Create a MySQL User**
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. **Add a New User**:
- Scroll to the **Add New User** section.
- **Username**: Enter a username for the new user (e.g., `dbuser`). Note: cPanel prefixes the username with your cPanel account name (e.g., `cpaneluser_dbuser`).
- **Password**: Enter a strong password (at least 12 characters, including letters, numbers, and symbols). Alternatively, click **Generate Password** for a secure option and save it securely.
4. **Create the User**: Click **Create User** (or **Add User** in older cPanel versions).
- You’ll see a confirmation message like: *User "cpaneluser_dbuser" created successfully.*
**Next Steps**
- **Grant Permissions**: Assign the user to a database by going to **MySQL Databases** > **Add User to Database**. Select the user and database, then choose permissions (e.g., ALL PRIVILEGES for full access).
- **Use in Applications**: Use the full username (e.g., `cpaneluser_dbuser`), password, and database name (e.g., `cpaneluser_mydatabase`) when configuring applications like WordPress or Joomla.
**Troubleshooting**
- **User Not Recognized**: Ensure the username includes the cPanel prefix (e.g., `cpaneluser_dbuser`). Check **Current Users** in **MySQL Databases** to confirm creation.
- **Login Issues**: Verify the password is correct. Reset it via **MySQL Databases** > **Manage Users** > **Change Password** if needed.
- **No Database Access**: Confirm the user is assigned to a database with appropriate permissions in **Add User to Database**.
- **Connection Errors**: When connecting (e.g., via phpMyAdmin or scripts):
- **Host**: Use `localhost`.
- **Username**: Full username (e.g., `cpaneluser_dbuser`).
- **Password**: As set during creation.
- **Database**: Full database name (e.g., `cpaneluser_mydatabase`).
- **Quota Limits**: Verify your hosting plan’s user limits in **MySQL Databases** > **Current Users**.
- **Propagation Delays**: If the domain or database is new, allow 24–48 hours for DNS propagation if external connections are involved.
For further assistance, contact support@gptservers.net with your domain, username, and any error details. Your MySQL user is now ready to be assigned to a database for use with your applications!
