Таблица MYSQL_LIST

В таблице хранится информация необходимая для подключения к базам MySQL (MariaDB).

CREATE TABLE MYSQL_LIST (
[id] INTEGER PRIMARY KEY AUTOINCREMENT,
[alias] TEXT,
[groupname] TEXT,
[servername] TEXT,
[serverport] TEXT,
[dbname] TEXT,
[username] TEXT,
[userpasswd] TEXT,
[charset] TEXT,
[compress] INTEGER DEFAULT 0,
[ssl] INTEGER DEFAULT 0,
[timedout] TEXT,
[readtime] TEXT,
[writetime] TEXT,
[resmode] TEXT,
[tiny] TEXT,
[meta] TEXT,
[ssl_use] TEXT,
[ssl_ca] TEXT,
[ssl_cert] TEXT,
[ssl_key] TEXT,
UNIQUE (alias, groupname)
)

Описание полей таблицы

id	record number in the table
alias	connection alias
groupname	group name (used to group entries in connection manager)
servername	DNS name of the server or its IP address
serverport	MySQL listener port on the server
dbname	the name of the database to connect to
username	username
userpasswd	user password (stored in ASCII code separated by \|)
charset	connection encoding
compress	compress traffic
ssl_use	connect using an SSL certificate
ssl_ca	path to the certificate authority file
ssl_cert	path to the certificate file
ssl_key	path to the key file