Contents
What is standard TCP IP over SSH?
The connection type allows MySQL Workbench to connection to MySQL Server using TCP/IP over an SSH tunnel. In addition to a number of parameters that are in common with Standard TCP/IP connections, this connection method features a number of specialized parameters.
What port does MySQL Workbench use?
3306/TCP
Table 3.4 MySQL Workbench Ports
| Default Port/Protocol | Description | Direction |
|---|---|---|
| 3306/TCP | MySQL client to the MySQL server (classic MySQL protocol) | From MySQL Workbench to the MySQL server |
| 22/TCP | Connection via SSH tunnel | From MySQL Workbench to the MySQL server |
What ports does MySQL use?
Client – Server Connection Ports Port 3306 is the default port for the classic MySQL protocol (port), which is used by the mysql client, MySQL Connectors, and utilities such as mysqldump and mysqlpump.
How do I access MySQL using SSH?
Connecting to Your Database with SSH
- Connect to your account using SSH. For instructions on connecting to your account with SSH, How to Connect to Your Account with SSH.
- Once you have logged in to your account, type in the command: mysql -h dbDomain.pair.com -u dbUser -p dbName.
- Enter the database password.
How do I connect to SSH?
How to Connect via SSH
- Open the SSH terminal on your machine and run the following command: ssh your_username@host_ip_address.
- Type in your password and hit Enter.
- When you are connecting to a server for the very first time, it will ask you if you want to continue connecting.
How does MySQL Workbench connect to a SSH server?
This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP over an SSH connection. In addition to a number of parameters that are in common with Standard TCP/IP connections, this connection method features a number of specialized parameters. These options are: SSH Hostname: The name of the SSH server.
How does MySQL Workbench use TCP / IP connection?
This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. The skip_networking MySQL system variable affects the TCP/IP connection method. If disabled, use named pipes or shared memory (on Windows) or Unix socket files (on Unix).
What is MySQL Workbench 5.3.3 connection method?
5.3.3 Standard TCP/IP over SSH Connection Method. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP over an SSH connection. In addition to a number of parameters that are in common with Standard TCP/IP connections, this connection method features a number of specialized parameters.
What is the port of the MySQL server?
Port: The TCP/IP port on which the MySQL server is listening (the default is 3306). Username: User name to use for the connection. Password: Optional password for the account used.