Online Documentation for SQL Manager for MySQL

Setting connection parameters


Use this step of the wizard to set the necessary connection parameters for the new database using the corresponding boxes and options: Host name, Port, User name and Password.

 

Register Database wizard - Setting connection parameters

 

 

Specify the host where the database being registered resides: type in the host name in the Host name field or select one in the drop-down list.

Enter MySQL port to connect through in the Port field and provide authorization settings: User name and Password. If needed you can define the Named pipe to connect to local MySQL. The named pipe value is stored in the MySQL server configuration file and it is 'MySQL' by default. Please note that only name of named pipe can be used, not a full path. The Named pipe field can be also used to specify a Unix socket in case of using HTTP-tunneling on *nix platforms. Unix socket value should start with '/' (Unix path delimiter) and its value is '/tmp/mysql.sock' by default.

 

CheckBox Register a single database

Check this option if you wish to register only one database at the host.

 

CheckBox Use tunneling

If this option is checked, you should set tunneling parameters at the Specifying tunneling parameters step of the wizard.

 

RadioButton SSH tunneling

Select this option to establish connection to an intermediate SSH server and forward all MySQL commands through the secure tunnel. The next step of the wizard allows you to define the corresponding parameters for SSH tunneling.

 

RadioButton HTTP tunneling

Select this option to access MySQL server through the HTTP protocol in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to MySQL, but allows HTTP connections. The next step of the wizard allows you to define the corresponding parameters for HTTP tunneling.

 

 

Click the Next button to proceed to the Setting specific options step or to the Selecting databases step of the wizard, depending on whether the CheckBox Register a single database option has been selected or not. If SSH or HTTP tunneling is used, you will proceed to  the Specifying SSH tunneling parameters step or Specifying HTTP tunneling parameters step first.