To manage your website's data effectively, you may need to create a MySQL database in Plesk, Internetport's web hosting control panel. This guide will walk you through the process of creating a MySQL database and adding a user with appropriate permissions.

Step-by-Step Guide to Create a MySQL Database in Plesk

Login to Your Plesk Control Panel

First, log into your Internetport Plesk control panel using your credentials. Navigate to https://your-domain.com/plesk, replacing "your-domain.com" with your actual domain name.

Navigate to the Databases Section

Once logged in, find and click on Databases in the left-hand menu. This section allows you to manage all databases associated with your hosting account.

Create a New Database

  1. Click on the Add Database button located at the top right corner of the Databases page.
  2. In the "Add Database" window, enter a name for your database in the Name field. Choose a unique and descriptive name to easily identify it later.
  3. Select MySQL as the type of database from the dropdown menu.
  4. Choose an appropriate character set for your database, typically UTF-8 (utf8mb4), which supports a wide range of characters including emojis and special symbols.
  5. Click on the Create button to create your new MySQL database.

Add a Database User

To interact with your newly created database, you need to add a user with appropriate permissions.

  1. In the Databases section, find your newly created database and click on it to open its management page.
  2. Click on the Add Database User button located at the top right corner of the page.
  3. In the "Add Database User" window, enter a username in the User name field. Choose a strong and unique username for security purposes.
  4. Create a secure password by entering it into the Password and Confirm Password fields. It's recommended to use a mix of letters, numbers, and special characters.
  5. Click on the Add button to create the database user.

Assign Permissions to the Database User

After creating the user, you need to assign permissions so that the user can interact with your database.

  1. In the Databases section, find your newly created database and click on it to open its management page.
  2. Click on the username of the database user you just created. This will take you to the user's permissions management page.
  3. Select the appropriate permissions for the user from the dropdown menu next to your database name. Typically, you would select All privileges unless you have specific requirements.
  4. Click on the Apply button to save the changes and assign the selected permissions to the user.

Note Credentials for Application Configuration

After setting up your database and user, make sure to note down the following credentials as you will need them to configure your web application:

  • Database Name: The name of your MySQL database.
  • User Name: The username of the database user with permissions to access the database.
  • Password: The password for the database user.
  • Host Name: Typically, this will be localhost, but it can also be your domain name or IP address depending on your hosting setup.

Troubleshooting

If you encounter any issues during the process:

  • Error creating database/user: Ensure that you have entered all required fields correctly and that the names are unique. Check for any typos or special characters that might be causing issues.
  • Permission errors: Verify that the user has been granted the correct permissions for the database. You can always modify these settings in the Plesk control panel.
  • Connection issues from your application: Double-check the credentials you have entered in your web application's configuration file. Ensure they match exactly with what you set up in Plesk.

If problems persist, contact Internetport support for further assistance.