Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


dacardworld
2023-02-11T11:39:56Z
I'm looking to connect to a MySQL server via an SSH Tunnel. How would I configure this in VisualCron?
Sponsor
Forum information
Michael Fjellström
2023-02-27T15:44:23Z
Originally Posted by: dacardworld 

I'm looking to connect to a MySQL server via an SSH Tunnel. How would I configure this in VisualCron?



Hi Dacard,

If you've done a local port forwarding it should be to just create an SSH task and connect to it with a command like this in the SSH task
$ mysql -u MYSQL_USER -p -h 127.0.0.1
Kelly Damon
2023-03-02T05:52:02Z
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 
Heather fostewer
2023-03-13T11:57:00Z
Everything is very open with a clear description of the issues. It was truly informative. Your website is very helpful.
Heather fostewer
2023-03-14T04:11:52Z
Originally Posted by: Heather fostewer 

Everything is very open with a clear description of the issues. It was truly informative. Your website is very helpful.


dinar guru
 


Scroll to Top