The instructions in the cs-wwu site you cited for doing that, will not work for MySQL on Ubuntu with ServerPilot (even though it opens an SSH terminal connection that you can use for command-line actions). Instead of connecting with the SSH settings in Navicat, you will need to establish an SSH tunnel in PuTTY first.Įstablish a special SSH Tunnel in PuTTY: If the first step above does not work, try this step instead. If Navicat still does not connect to the remove MySQL server on the VPS connected to ServerPilot, then undo any changes you made to /etc/ssh/sshd_config (and restart ssh). Since it is Ubuntu, it would be: 'service ssh restart' (rather than 'service sshd restart' as on some other flavors of linux). If you edited that file, then restart the SSH service. (BTW, phpMyAdmin works fine on ServerPilot but I find Navicat much more handy for certain tasks when programming in php.) Thank you.įirst, as mentioned at check the 'AllowTcpForwarding' setting (which should be 'yes' - otherwise, the SSH port forwarding will be disabled) in: /etc/ssh/sshd_config. If you got it to work, or if you know how, please explain. Surely I'm not the only one who has tried connecting to MySQL on a ServerPilot server. But not when the database is on ServerPilot (it gives an error: '2013 - Lost connection to MySQL server during query' when 'testing' the connection in Navicat). For databases on other servers/panels, Navicat connects to MySQL perfectly that way. I also tried separately opening an SSH tunnel with Putty per. That should also work with ServerPilot according to.

Host Name/IP Address: 127.0.0.1 (or 'localhost').On every other server/panel that I've tried over the years, this configuration always works: I'm using Navicat on my windows desktop computer, trying to connect to my remote ubuntu VPS database. Anyone using ServerPilot on a vps and was able to connect to the MySQL server via SSH with Navicat? On other servers/panels I do that all the time, with no problem but it won't make the connection to a MySQL database on ServerPilot (Navicat gives a 'SSH connection error Timeout').

Navicat for linux