|
Contents
Index
<< Previous
Next >>
PDF
Sessions
|
|
Menu: Settings / Sessions
In MySQL-Front, settings relevant to database linkages are saved in "sessions". Each session contains various connection-related settings such as server, user, and password as well as numerous additional settings such as selection of utilized databases or caching settings.
This means it might also be advisable, in certain situations, to create different sessions for a database connection (e.g., one with caching and one without).
(To edit / delete a session you have to close all open windows of this session before.)
Common:
| Specifies the name of the session used to identify the session in MySQL-Front.
|
Connection:
| Address of the server hosting the database. The server is described with a domain name or an IP address.
|
| To connect via the "MySQL" Named Pipe the Server has to be ".".
|
| Port number of the database (usually 3306).
|
| Indicates the type of database access. "Built-in" access is usually possible. For reasons of compatibility, the use of a vendor library might be necessary. This library is supplied together with the MySQL database.
|
| Some ISPs do not permit access to the database from external computers. This problem can be circumvented with the use of HTTP tunnels.
|
| Used character set. If not set the default character set of the database will be used.
|
Login:
| Database server user name.
|
| Database server password.
|
| Utilized databases (several are separated with ",").
|
Startup:
| This SQL queries will be executed after connection by this application immediately.
|
Data Browser:
| MySQL-Front can limit the number of records loaded in the Data Browser. This is practical in case of large tables since loading the complete table might take a long time or even exceed the memory capacity of the workstation.
|
| MySQL-Front can load the records sorted in accordance with the order of the primary index of the database. This makes viewing these records much easier. Sorting can use significant resources of the database if tables are large.
|
FTP Server:
| The FTP Server will be used to uploading the HTTP Tunnel script.
|
| Address of the server hosting the HTTP tunnel script. The server is described with a domain name or an IP address.
|
| Port number of the database (usually 21).
|
| Relative path of the FTP server to the HTTP tunnel script.
|
| The name of the tunnel script is not a part of this path - it will be taken from the "HTTP Tunnel" field from the "Connection" tab automatically.
|
See also:
|
|
