Matomo Analytics

You can connect to your MySQL server via SSH, if you have your SSH key uploaded on the server, you don't need to enter a password, besides the SSH user (ploi in this case), and database user name.

There are several apps that make managing your MySQL table with SSH connection, think of TablePlus (mac) or HeidiSQL (windows).

You will find an example below here to connect with TablePlus to your MySQL server:

Any other client should look similar to this. In mainlines:

  • Host: 127.0.0.1

  • User: ploi

  • Password: -enter your DB password you received-

  • Connection over SSH

  • Server: Your server's IP address

  • User: ploi

  • Password: -leave empty-

  • Use SSH key

This example above, assumes you have the SSH key setup on your server so you can leave SSH password empty.

In the MySQL host and SSH Host you fill in the server's IP address where the MySQL server is located.

10 July 2018 (last updated 10 months ago)

11775 views

Written by Dennis

Dennis brings over 6 years of hands-on experience in server management, specializing in optimizing web services for scalability and security.

Back to Database


Start free trial