Tag: ssh tunnel

  • Using an SSH tunnel to step debug through a firewall

    In a previous post I covered how to set up PHP step debugging in Zend Studio. But if that doesn’t work there may be a firewall in between the server and the debugging client, or IDE, preventing the connection. Here is a possible way to get around that. Note: Of course there is no way to […]

  • SSH port forwarding/tunneling for MySQL connection

    Create an account on the remote MySQL database server. useradd -s /bin/false remote_user mkdir /home/remote_user/.ssh touch /home/remote_user/.ssh/authorized_keys chown -R remote_user:remote_user /home/remote_user/.ssh chmod 755 /home/remote_user/.ssh chmod 600 /home/remote_user/.ssh/authorized_keys Add MySQL permissions in the remote MySQL database to allow user connections from localhost. USE mysql; GRANT ALL ON db.* TO [email protected] IDENTIFIED BY ‘database_pass’; FLUSH PRIVILEGES; Now, […]