google-templateswordpress

Connect to the database server

By default, the database port in this solution cannot be accessed over a public IP address. As a result, you will only be able to connect to your database server from the runtime server (the server instance running the application). Follow these instructions to connect to the database server:

  • Connect to the application server via SSH following the steps in the Forwarding your key using SSH Agent section.
  • Once logged in the application server, you must obtain the server hostname where the database is running by executing the following command:

    $ sudo cat /opt/bitnami/wordpress/wp-config.php | grep 'DB_HOST'
    

    You should see an output similar to this:

    define('DB_HOST', 'provisioner-peer:3306');
    

    In this case, the server hostname where the database is running is “provisioner-peer”.

  • Inside the application server, with the SSH key forwarded, run the following command to connect to the database server through SSH. Remember to replace SERVER-IP with the value obtained for the DB-HOST:

    $ ssh bitnami@SERVER-IP
    

    In the current example, the command would be the following:

    $ ssh bitnami@provisioner-peer
    
Last modification September 7, 2018