Remote Access to MySQL/MariaDB/Percona

You can manage your databases from your computer without logging into our dashboard. Here are some steps to access MySQL remotely. These steps work for both Java and PHP environments.

Create Environment

Step 1: Log into the AccuWeb.Cloud platform.

Step 2: Click the Create Environment button at the top left.

Step 3: In the Environment Topology dialog, choose your application server (e.g., Tomcat) and MySQL as the database. Enable Public IPv4 for MySQL. Then enter your environment name, like remote-access-mysql.

Wait a minute for your environment to be created.

Step 4: Click the SQL Databases. Then click on the Node server and you’ll find the public IP just below the private IP address.

Remote Connection to MySQL

Step 1: Open a new connection using a desktop client for MySQL (such as MySQL Workbench).

Click on “Database” and then select “Connect to Database.”

Step 2: Enter the connection details: connection name, hostname (your Public IP), port number (3306), username, and password (you received these credentials via email when you created the environment in AccuWeb.Cloud).

In the password field, choose “Store in Vault.”

Enter the database user password in the “Store Password for Connection” window. Then click “OK.”

Step 3: Click “OK” to begin the MySQL connection process.

Step 4: Once the MySQL connection process is complete, you will see the MySQL tab in MySQL Workbench. Now, MySQL remote access is configured, and you can start querying.