Connecting to MatrixOne with Database Client Tool

MatrixOne now supports the following Database client tools:

  • MySQL Client
  • Navicat
  • DBeaver

Before you start

Make sure you have already installed and launched MatrixOne.

Connect to the MatrixOne Server through MySQL Client

  1. Download and install MySQL Client.

  2. Connect to the MatrixOne server.

    You can use the MySQL command-line client to connect to MatrixOne server:

    1. mysql -h IP -P PORT -uUsername -p

    The connection string is the same format as MySQL accepts. You need to provide a user name and a password.

    Use the built-in test account for example:

    • user: dump
    • password: 111
    1. mysql -h 127.0.0.1 -P 6001 -udump -p
    2. Enter password:

    The successful result is as below:

    1. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1031
    2. Server version: 0.6.0 MatrixOne
    3. Copyright (c) 2000, 2022, Oracle and/or its affiliates.
    4. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
    5. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

For more information on deployment, see Deployment FAQs.

Connect to the MatrixOne Server through Navicat

  1. As MatrixOne 0.6 is not fully compatible with MySQL 8.0, we reset the MatrixOne server version to 0.6.0 for adapting Navicat connection.

    Before launch MatrixOne, insert the following lines in the [cn.frontend] section of the etc/launch-tae-CN-tae-DN/cn.toml file in MatrixOne folder, then launch MatrixOne.

    1. [cn.frontend]
    2. ServerVersionPrefix = " "

    Open a new terminal and enter into the following command:

    1. #Launch MatrixOne (Source code method)
    2. ./mo-service -launch ./etc/quickstart/launch.toml

    Note: If you use Docker install method and need to modify this configuration file, please refer to Mount configuration file with Docker.

  2. Download and install Navicat.

  3. Open Navicat, click Connection > MySQL, and fill in the following parameters in the pop-up window:

    • Connction Name: MatrixOne
    • Host: 127.0.0.1
    • Port: 6001
    • User Name: dump
    • Password: 111
    • Save password:Yes
  4. Click Save, save the configuration.

    navicat_config

  5. To connect to the MatrixOne server, double-click MatrixOne in the database directory on the left.

  6. Once you connect to MatrixOne, you will see 6 default system databases.

    Connecting to MatrixOne with Database Client Tool - 图2

    And on the right you will see the information about this connection.

    Connecting to MatrixOne with Database Client Tool - 图3

Connect to the MatrixOne Server through DBeaver

  1. Download and install DBeaver.

  2. Open DBeaver, click Connection, select MySQL, then click Next.

    dbeaver-mysql

    Fill in the following parameters in the pop-up window. Click Finish, save the configuration.

    • Host: 127.0.0.1
    • Port: 6001
    • Database: MatrixOne
    • User Name: dump
    • Password: 111
    • Save password locally: Yes

    dbeaver-connection

  3. To connect to the MatrixOne server, double-click MatrixOne in the database navigation on the left. You will see the four default system databases.

    dbeaver-databases

  4. By default, views are not appearing in DBeaver. To show complete system databases, you need to right click on the MatrxiOne, select on Connection view and toggle on the Show system objects.

    Connecting to MatrixOne with Database Client Tool - 图7

    Then you can see full 6 system databases.

    dbeaver-databases-with-view