Remote MySQL and Postfix

Hello,

I followed the Linode tutorial to set up Postfix with MySql. The tutorial specified Postfix should connect to the MySQL database via 127.0.0.1. The bind address for MySQL is 127.0.0.1, however, this makes it impossible to remotely access and control the database. If I change the MySQL bind address to my public IP, I'm concerned the Postfix installation will stop functioning.

Any way to remotely access MySQL without breaking my existing Postfix installation?

Sorry if the question is unclear; I can try to clarify if necessary.

Thanks for any help you can offer.

Best regards,

Matthew

1 Reply

you want a ssh tunnel, if you're on windows, you need putty, other platforms it's just ssh. I think there is a library article on ssh tunnels.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct