bchalfresco

Connect to MySQL with Navicat

NOTE: We are in the process of modifying the configuration for many Bitnami stacks. On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. To identify which database server is used in your stack, run the command below:

 $ test -d /opt/bitnami/mariadb && echo "MariaDB" || echo "MySQL"

The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations.

The latest version of Navicat supports SSH tunnels for MySQL connections. Follow these steps.

  • In the connection properties, set the following values:

    • Host Name: localhost
    • Port: 3306
    • User Name: root
    • Password: The password from the server detail page in Bitnami Cloud Hosting dashboard
  • Click the “SSH” tab.

  • Check the “Use SSH Tunnel” option and set the following values:

    • Host Name: The local machine’s hostname
    • Port: 22
    • User Name: bitnami
    • Authentication Method: Public key
    • Private Key: The location to the private key file for the server
Last modification October 21, 2020