Yes just open port 3306/tcp.
But this is very dangerous and your opening your whole filesystem to the internet. So you have to take the proper security steps:
- Make sure 'skip-networking' is NOT in your my.cnf.
- Disable guest login, anonymous login, etc... (delete these from user)
- Make sure every user has a password
- If you can lock the user to a specific IP or IP range
dev@150.1.2.%
- I recommend deleting 'root' user and using a different user name not easily guessable as your DBA.
Ahmad Sakhi Wrote:
-------------------------------------------------------
> Thank you Rick.
>
> Actually, the intend is for developers.
>
> We are a group of developers, intending to share
> the same database. Each of us having our own local
> environment, but want to share one central
> database.
>
> So, my local web app can connect to remote
> database.
>
> I would assume opening up the port on the firewall
> that mysql is running, and not sure if there's
> anything else need to be done?