Preferences and global settings

In addition to the data stored on a per-server basis; SQL DM for MySQL has a database storing global user preferences (preferences.config database) and also a very tiny text file (MONyog.ini), that only has what minimal information is required for SQL DM for MySQL to start.

connection.data

There is a Preferences table in connection.data which is used for storing the default processlist query.

CREATE TABLE IF NOT EXISTS [preferences] ( [name] VARCHAR(50) DEFAULT '' NOT NULL PRIMARY KEY UNIQUE, [value] TEXT DEFAULT '');

The server_names table is used for storing all the connection details.

CREATE TABLE [server_names] (id INTEGER DEFAULT 0 NOT NULL PRIMARY KEY UNIQUE, key VARCHAR(255) DEFAULT '' NOT NULL, value VARCHAR(255) DEFAULT '' NOT NULL);

Copyright © 2026 Webyog Inc. All Rights Reserved.