Steps to Enable Remote MySQL Access

Step 1: Create a Database and Database User

1. Log in to your CloudStick account and navigate to your server.
2. Go to the Database section.
3. Click Create Database and provide the following details:
   • Database Name: Enter a name for your database.
   • Database User: Create or select an existing user.
4. Assign the database to the selected user by choosing it from the drop-down menu.

   

Step 2: Configure Remote Access for the Database

1. While assigning the database to the user, set the Host option to Remote.
2. Enter the Remote Host IP Address in the field labeled Remote Host.
   • This is the IP address from which you will be connecting to the database.

     

Step 3: Enable Remote MySQL

1. Navigate to the MySQL Settings section in your server dashboard.
2. Locate the option to enable Remote MySQL and switch it on.
   

Step 4: Connect to Your Database

Once remote MySQL is enabled and the remote IP address is added:

• Use a MySQL client (such as MySQL Workbench, phpMyAdmin, or a command-line interface) to connect to your database using the following details:
  • Host: Your server’s IP address
  • Port: 3306 (default MySQL port)
  • Username: The database user you created
  • Password: The password for the database user

Notes:

• Ensure the IP address entered in the Remote Host field is accurate and trusted.
• If you are unable to connect, check your server’s firewall settings to allow MySQL outgoing traffic (port 3306).
• Use a strong password for your database user to enhance security.

By following these steps, you can successfully enable remote MySQL access and manage your databases from an external system.