Connection configuration

Saturday, 17 April 2010 19:18

Via menu Manage connection you can save, edit and remove your most used connections, edit connection attributes or change order in list/db tree.

The information is stored in the xml file conn.xml in the configs folder. If some connections are already open, before opening the Manage connections dialog, they are automatically closed. After each change the tree with connections is refreshed.

When you press New or Edit buttons, you can insert/edit connection, and afterwards save or update the inserted informations.

The Clear button will clear all the input fields, port and server will default to localhost:3306.
The passwords are stored encrypted using symetric encryption DES in the file configs/psswds.properties. The key for en/decryption is stored in file configs/key. This file should be readable only by the user - 0400.
If you want to change your key, you just remove the file key and psswds.properties and new key will be generated after the first insert/update of any connection.
The passwds.properties file uses combination of server, login and alias to pairs it with a certain password.

Manage connections server variables:

MyJgui has added a better way to work with mysql server parameters. You can add, view and edit the parameters for each connection in Manage connections. These parameters will be set as soon as the connection is made. This lets you gain control of the behaviour of your mysql connection or server.

To view all possible variables run query: show variables
To view only variables shared throuhg all connections, clients and databases run: show global variables
To view a single variable: show variables like 'character_set_server'.
If you want to set a variable without closing all connection (usage of Manage connections will ask your approval to do so) run:set variable character_set_server='utf-8'.