To configure an SSH tunnel for MySQL server in VisualCron, follow these steps:
Create a new SSH connection in VisualCron by going to "Tools" > "SSH/Telnet" > "New Connection".
Configure the SSH connection settings, including the hostname or IP address of the server, the port number, and authentication details such as username and password.
Create a new MySQL connection in VisualCron by going to "Tools" > "MySQL" > "New Connection".
Configure the MySQL connection settings, including the hostname or IP address of the MySQL server, the port number (usually 3306), and authentication details such as username and password.
In the "Advanced" tab of the MySQL connection settings, enable the "Use SSH Tunnel" option.
Configure the SSH tunnel settings, including the SSH hostname or IP address, the SSH port number, and authentication details such as username and password.
Save the MySQL connection settings and test the connection to ensure it is successful.
Once the SSH tunnel is configured, you can use the MySQL connection in your VisualCron tasks to execute MySQL queries or perform other operations on the database server securely through the SSH tunnel.
Upsers
Edited by user
2023-03-03T03:51:04Z
|
Reason: Not specified