If you’re still using phpMyAdmin to admin your remote database, then you’re doing it wrong. Don’t expose your database to the outside world like this, instead use a SSH tunnel. In your terminal simply create the tunnel:
|
1 |
<span class="source source_shell"> ssh -fNg -L 8888:127.0.0.1:3306 {your_username}@{yourdomain.com}</span> |
Then in your MySQL interface of choice just connect to 127.0.0.1 port 8888 and voila, you’ll be connected to your remote database.
Apps like Querious even let you setup the connection internally without having to tunnel through in Terminal.
