If an instance of MySQL is already running locally, an alternative port may be used, such as “3307”. localport - Normally “3306”, the local port used to access MySQL.Creating a Tunnel with OpenSSHĪ secure tunnel to the Webscale STRATUS database can be created using one command line: ssh -p -L :mysql:3306 SSHport - Use the SSH Port found in your SSH Info panel. Use an IP of 127.0.0.1 and port number of 3306. Connect locally using a MySQL client application. The SSH tunnel to the remote database is now open. Log in with the STRATUS SSH User credentials.Destination - Enter myqsl with a port of “3306” (mysql:3306) This is the mysql hostname and port used by your Stratus environment.If MySQL is locally using this port, enter another port number (e.g. Creating a Tunnel with PuTTYĮnter the SSH Host address shown SSH > Info.įrom the left-hand tree in PuTTY, go to Connection > SSH > Tunnels.
Create ssh tunnel for mysql password#
In your Webscale STRATUS management panel, expand the MySQL section and click Info to see your database username and password The IP address that will connect to the Webscale STRATUS MySQL (i.e., the same IP allowed for SSH access).A working SSH login to your Webscale STRATUS environment.Putty and OpenSSH are used in the following examples.īefore you can connect, you need several pieces of information: SSH tunnels are possible with a variety of clients. To use a local MySQL manager or other application to connect to a database on Webscale STRATUS, an SSH tunnel is preferred.
0 kommentar(er)
