Re: Making a mysql database available from the internet
Posted by: Aram Mirzadeh
Date: September 12, 2016 03:11PM

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?

Options: ReplyQuote

Written By
Re: Making a mysql database available from the internet
September 12, 2016 03:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.