### Creating a MySQL Database in cPanel
**Overview**
SQL (Structured Query Language) is a standardized language for querying and retrieving data from databases. MySQL, used on your gptservers.net hosting account, is a database server that processes SQL requests. To use a MySQL database, you must first create the database and then add one or more users with appropriate permissions.
**Steps to Create a MySQL Database**
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. **Create a New Database**:
- In the **Create New Database** section, enter a name for your database in the field next to **Db:** (e.g., `mydatabase`).
- Note: cPanel automatically prefixes the database name with your cPanel username (e.g., `username_mydatabase`).
4. **Add the Database**: Click **Create Database** (or **Add Db** in older cPanel versions) to create it.
- You’ll see a confirmation message like: *Database "username_mydatabase" created successfully.*
**Next Steps**
- **Create a Database User**: You must create at least one user to interact with the database. Go to **MySQL Databases** > **Add New User**, enter a username and strong password, and click **Create User**.
- **Grant Permissions**: Assign the user to the database by navigating to **Add User to Database**, selecting the user and database, and granting specific permissions (e.g., ALL PRIVILEGES for full access).
- Refer to cPanel’s documentation or gptservers.net’s knowledgebase for detailed guides on creating users and granting permissions.
**Troubleshooting**
- **Database Not Visible**: Ensure you’re viewing the correct cPanel account. The database name will include your cPanel username prefix (e.g., `username_mydatabase`).
- **User Access Issues**: Verify that a user is created and assigned to the database with appropriate permissions. Use **MySQL Databases** > **Manage User Privileges** to check or modify.
- **Connection Errors**: When connecting (e.g., via PHP or phpMyAdmin), use:
- **Host**: `localhost`
- **Database Name**: Full name (e.g., `username_mydatabase`)
- **Username**: Full username (e.g., `username_dbuser`)
- **Password**: As set during user creation
- **Quota Limits**: Check your hosting plan’s database limits in cPanel > **MySQL Databases** > **Current Databases**.
- **Propagation Delays**: If the domain is new, allow 24–48 hours for DNS propagation if external connections are involved.
For assistance, contact support@gptservers.net with your domain and error details. Your MySQL database is now ready for use with applications like WordPress or Joomla!
