Navicat report Viewer How to connect to MySQL database

The Navicat report Viewer is an easy-to-use tool. With a user-friendly graphical user interface (GUI), the Navicat report Viewer allows you to browse reports designed by Navicat reporting Builder and support remote servers connected to different platforms, namely Windows, Mac, Linux, and UNIX. Here is a brief introduction to how the Navicat report Viewer connects to the MySQL database.

When viewing reports in the Navicat Report Viewer, the user first needs to create one or more connections in the connection window. To create a new connection, tap Connect or select File-New connection, and then enter the required information in the Connection Properties window. After the connection is created, the user needs to place the report file (. RTM) to the report location before viewing and printing the report.

Navicat Connection Property Information

MySQL Connection General Settings

To successfully create a new connection to a native or remote server, set the connection properties in the General tab, regardless of SSL, SSH, or HTTP. If the user's Internet service provider (ISP) does not provide direct access to the server, Secure channel Protocol (SSH) or HTTP is another workaround. Enter a properly described connection name in the Connection Name text box.

The user can connect to the MySQL remote server, but for security reasons, the remote direct connection to the MySQL server is disabled. Therefore, users may not be able to connect directly to the remote server using the Navicat report Viewer or other similar applications unless the user rights have been configured.

By default, MySQL provides the username "root" and the password is blank.

Host name or IP address: the host name or the IP address of the server where the database resides.

PORT: The TCP/IP port that is connected to the database server.

User name: The user name to connect to the database server.

Password: the password to connect to the server.

MySQL Connection Advanced Settings

Report location: When creating a new connection, the Navicat report Viewer creates a subfolder within the reporting location where the user places all the report files (. RTM) in this subfolder, and the user can also change the location to any desired location.

Automatic connection: Tick this option and the Navicat report Viewer will automatically open the connection when the program is started.

Encoding: When the MySQL character set cannot be used, select a code page to communicate with the MySQL server.

Maintain connection interval (seconds): This option allows the user to maintain a connection by pinging, and the user can set the interval between ping and ping in the edit field.

Use the MySQL character set: This option should be enabled if you are using MySQL version 4.1 or later.

Use compression: This option allows users to use compressed communication contracts when the client and server support Zlib compression and when the client needs compression.

Use name pipe, socket: Tick this option to Navicat the report Viewer to use a native connected socket file.

Here's how the Navicat report Viewer connects to the MySQL database, and if you want to learn about other tutorials you can focus on how Navicat connects to the SQLite database .

Navicat report Viewer How to connect to MySQL database