Remote Access

Remote Access to MySQL, MariaDB and Percona

You can connect to MySQL, MariaDB, or Percona remotely from your computer without opening the platform dashboard each time. The source example uses MySQL Workbench and a public IPv4 address assigned directly to the database node.

In this article
✓

MariaDB and Percona

The same steps described for MySQL can also be used for remote access to MariaDB and Percona.

Create the Environment

1

Open the environment wizard

Log in to the platform and click Create environment at the top-left of the dashboard.

Create environment
Open the environment creation wizard from the dashboard.
2

Select the application server and database

In the Environment Topology dialog, select the required application server, for example Tomcat, and choose MySQL as the database.

3

Enable Public IPv4 for MySQL

Switch on Public IPv4 for the MySQL database node. Then enter the required environment name. The source example uses dumptest.

Environment topology wizard
Enable Public IPv4 for the MySQL node while creating the environment.

Wait until the environment is created.

Find the Database Public IP

4

Open the MySQL node information

Click the Info button for the MySQL node. The assigned public IP address is displayed at the end of the information list.

MySQL node public IP
Copy the public IPv4 address displayed for the MySQL database node.

Configure the Remote MySQL Connection

Open any desktop MySQL client. The source guide uses MySQL Workbench as an example.

Connection NameEnter any convenient name for the remote connection.
HostnameEnter the database node’s public IPv4 address.
Port3306
UsernameUse the database username provided by the platform.
PasswordUse the database password sent after environment creation.

The database username and password are included in the email sent by the platform when the environment is created.

Remote MySQL connection credentials
Configure MySQL Workbench with the public IP, port 3306, username, and password.

Open the connection. Once authenticated, the database can be queried remotely from the desktop client.

Remote access to MySQL
After the connection opens successfully, the remote database is ready for queries.

Expected Result

The MySQL, MariaDB, or Percona database node has a public IPv4 address and can be accessed directly from a desktop database client such as MySQL Workbench using port 3306 and the database credentials supplied by the platform.

Important Notes

  • Enable Public IPv4 for the database node before attempting the documented remote-access workflow.
  • Use the database node’s public IP as the MySQL Workbench hostname.
  • The documented MySQL port is 3306.
  • The database username and password are provided by the platform after environment creation.
  • The same workflow applies to MariaDB and Percona.