Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I can tune the connection to MySQL server by SSH. What values do I need to input to the fields on SSH tab of Database Registration dialog?

April 26, 2017connection database Fields input MySQL server SSH Tab tune values

0

Posted

I can tune the connection to MySQL server by SSH. What values do I need to input to the fields on SSH tab of Database Registration dialog?

2 Answers

0

Posted

To setup SSH connection correctly, input the following values to the corresponding fields: On SSH page/tab: SSH host name is a host where SSH server is activated. SSH port is a port where SSH server is activated. SSH user name is a user on Linux machine. (It is a Linux user. It is not a user of MySQL server.) SSH password is a Linux user password. On Connection properties/General page/tab: Host is a host where MySQL server is located from the point of view of SSH server. If SSH and MySQL server are on the same machine, it is equal to SSH Host, or may be ‘localhost’. Port is a port of MySQL server on Remote Host, by default it is 3306. User Name is a MySQL user name. Password is a password of the MySQL user. Please note that MySQL host name should be set relatively to the SSH server in this case. For example, if both MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server’s external host name or IP address.

0

Posted

To setup SSH connection correctly, input the following values in the corresponding fields: • On SSH page/tab: • SSH host name is a host where SSH server is activated. • SSH port is a port where SSH server is activated. • SSH user name is a user on Linux machine. (It is a Linux user. It is not a user of MySQL server.) • SSH password is a Linux user password. • On Connection properties/General page/tab: • Host is a host where MySQL server is located from the point of view of SSH server. If SSH and MySQL server are on the same machine, it is equal to SSH Host, or may be ‘localhost’. • Port is a port of MySQL server on Remote Host, by default it is 3306. • User Name is a MySQL user name. • Password is a password of the MySQL user. Please note that MySQL host name should be set relative to the SSH server in this case. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server’s external host name or IP address.