To show the selected databases in the open state in the connection tree, double-click the preferable databases in the Databases list box. To show the selected databases in the close state in the connection tree, click the preferable databases in the Databases list box.

To start working with advanced database settings, check the Use Advanced Connections. Set the advanced database properties, which are not obligatory. This option allows you to use encryption.Īdvanced Database Properties for MySQL, PostgreSQL and MariaDB The initial database to which user connects when making connection. To attach or detach databases in the connection. You can set the period between pings in the edit fieldĮnable this option and provide Password when connecting to an encrypted SQLite database. This option allows you to keep the connection with the server alive by pinging it. With this option on, Oracle Database uses Windows user login credentials to authenticate database users. Indicate that the database user is connecting with either the Default, SYSOPER or SYSDBA system privilege. With this option on, Navicat uses socket file for localhost connection. It is used if both client and server support zlib compression, and the client requests compression. This option allows you to use compression protocol. You can set the period between pings in the edit field. With this option on, Navicat automatically open connection with the registered database at application startup.Ĭhoose a codepage to communicate with MySQL Server while MySQL character set not being employed. Vgroup.json - stores how the objects are categorized.

Navicat premium sqlite tutorial