How to set advanced database properties in navicat

Navicat is a set of fast and reliable database management tools. You can also set advanced database properties in the Set Advanced Connection tab. There is no mandatory requirement whether to set advanced database properties. If you need to set up an advanced database, the prerequisite is to check "Use advanced connection". Detailed introduction is as follows:

MySQL, PostgreSQL and MariaDB advanced database properties

The selected database in the connection tree is in the "closed" state, click the database in the database list .

The selected database in the connection tree is in the "open" state. Double-click the database in the database list.

Related recommendations: "Navicat for mysql graphic tutorial"

Add a hidden database

1. Click " Add database to list" button.

2. Enter the name of the database.

3. Select the newly added database in the database list.

Remove a database: Select the database to be removed in the database list and click the "Remove Database from List" button. It should be noted that the database is only removed from the database list and is not removed from the server. It still exists on the server.

SQLite's advanced database properties

Click the "Attach Database" button to attach a database file.

Database file: Set the file path of the database.

Database name: Enter the database name displayed by "Navicat".

Encrypted: Enable this option and provide a password to connect to an encrypted SQLite database.

Detach a database: Select it from the list and click the "Detach Database" button.

The above is the detailed content of How to set advanced database properties in navicat. For more information, please follow other related articles on the PHP Chinese website!