How to configure remote host connectivity?

[Fred]

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?

-Thanks

[Bill Karwin]

Re: How to configure remote host connectivity?

Fred wrote:[color=blue]
> 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?[/color]

http://dev.mysql.com/doc/mysql/en/connection-access.html

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.

Regards,
Bill K.