- User and password on the AMRS Web server
- User and password on the AMRS Research MySQL server
Windows with Navicat
- Complete the details within the "SSH" tab of the new connection dialogue.
- Put MySQL connection details under the "General" tab of the dialogue. Test the connection to verify that you can connect to the MySQL server.
Windows with MySQL Query Browser and PuTTY
- Open PuTTY and go to the "Tunnels" configuration. Put the MySQL port and the forwarded port as seen in the image and then press the "Add" button
- Go to SSH configuration and enter the AMPATH web server address (wiki.ampath.or.ke)
- Press "Open" and put your ssh credentials for the web server.
- Open MySQL Query Browser and then connect to server "localhost" port 3306 within the MySQL Query Browser.
Ubuntu using MySQL Query Browser
- Open a terminal and execute the following command
replacing "username" with your username on the web server.
- Open MySQL Query Browser and then connect to 127.0.0.2 on the MySQL Query Browser.