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 an SSH tunnel. In your terminal simply create the tunnel:
ssh -fNg -L 8888:127.0.0.1:3306 {your_username}@{yourdomain.com}
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.
Your email is never published nor shared. Required fields are marked *
You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Don’t use PHPMyAdmin. SSH tunnel instead.
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 an SSH tunnel. In your terminal simply create the tunnel:
ssh -fNg -L 8888:127.0.0.1:3306 {your_username}@{yourdomain.com}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.