-
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, […]