How to configure remote host connectivity?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I just started using MySQL, and cannot find how to
configure host access in the my.cnf file.  I want
to be able to allow access to a MySQL database
from a remote host, and also from a particular
network.  How do you configure access of this sort?


Re: How to configure remote host connectivity?

Fred wrote:
Quoted text here. Click to load it

As far as I know, MySQL is enabled for all network access, and you
control which hosts, networks, and even individual accounts can connect
to which databases using the GRANT system.

You could also configure a firewall to allow only some networks or
individual IP addresses to connect to your MySQL server host on the port
MySQL uses, port 3306.  But this is operating system and network
configuration, outside of MySQL control.

Bill K.

Site Timeline