MySQL server properties
This window is used both for specifying the parameters of a new server being added and for modifying the settings of an existing MySQL database server. You can view them by adding or modifying the selected server settings in the MySQL Database Server Settings window. Database server properties
On the Server Properties tab, you define the parameters of the server and the MySQL database that you want to have access to in the Spider. If you do not know the details needed to configure the server, ask the server administrator. Note that to improve security, most ISPs block you from connecting to the MySQL server other than via the server name localhost - in which case you will not be able to use it directly in Spider. To configure a database server for use in Spider on the MySQL Inspector tab, you must enter the following details in the relevant fields: Friendly name
Enter a name in this field to identify the MySQL server in the server list. This value is for information only and can be anything you like. Server address
Enter the address of the MySQL server you are adding to the list here. Use the address you received from your account administrator. If the server is installed locally, this will most likely be the name localhost. Port
This is the place to specify the port on which the MySQL server is running. Most often the port number 3306 is specified, however the value depends on the server configuration. If you specify an invalid port, the connection will not be able to complete. User
Enter the user name here, in other words the name of the account to which you have rights and with which you wish to connect on this server. Password
This is the place for your account password. Enter it very carefully as it is hidden when typing. Do not use a password when logging into the server
Check this switch if you want to log in with the username only, without a password, when connecting to the server. The field for entering a password will be blocked in this case.
If you do not enter a password in this dialog box and do not check this switch, the first time you try to connect to the database server, Spider will ask for a password
Database
The server can share multiple databases. In this field, enter the name of the database you want to use in the current connection.
. Database group
Here you can enter the name of the group to which the database should belong. Database groups are displayed at the top of the list in the MySQL Inspector. With this option, if you are using multiple databases, you can more easily find the right one in the list.
Character coding
Select the character encoding the database uses to store text data from the list. If you select an incorrect encoding, some national characters in the texts displayed in the MySQL Inspector may be incorrect. Encoding command
This field contains a command that is called during MySQL server operations to set the correct character encoding when the program communicates with the server. Some servers may not support the default NAMES and CHARSET environment variables, so if you have problems connecting to a MySQL server, you should modify this command to one appropriate for your server or define these variables in the server configuration.
Note: Leaving this field blank may result in some MySQL servers not being able to correctly perform character conversion between different character encoding standards for text fields.
Delete favorite queries and tables
Clears the list of favorite server queries and tables. No data will be deleted from the server! |