![]() ![]() 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.
0 Comments
Leave a Reply. |