Exposing mysql

[VRay]

I am trying to expose mysql to my network. I have no firewall running. I have googled around and it seems I need to comment out the skip-networking section in /etc/mysql/mycnf. The problem is I am on RH9 and can only find a /etc/my.cnf which does not contain any networking stuff. Does anyone know where Redhat stuck the mysql networking configuration options in RH9??

[fatTrav]

from my my.conf file

# /etc/mysql/my.cnf: The global mysql configuration file.
#
# This file can be simultaneously placed in three places:
# 1. /etc/mysql/my.cnf to set global options.
# 2. /var/lib/mysql/my.cnf to set server-specific options.
# 3. ~/.my.cnf to set user-specific options.

[VRay]

I only find /etc/my.cnf - there must be a another config file somewhere....

[danimal1009]

try using the "locate my.conf" command. That should tell you the locatino of any file named my.conf

[VRay]

Yeah, did all that... got to be something i am missing here...

[j79zlr]

what do you mean "expose mysql to the network" mysqld should be listening on port 3306, you would need a mysql-client on a networked PC to access it remotely without SSHing into the PC to run it locally. Is that what you are asking?

[*nixX]

my.cnf will either be in /etc/mysql/my.cnf or /etc/my.cnf.

Once you find it look for the line:

skip-networking

and comment it

#skip-networking

restart mysqld

[VRay]

Yes... mysql is running locally, but an external scan of the box does not reveal an open port 3306. (internal scan does) . I am sure there is some setting somewhere that will open access to mysql on 3306 to other machines in the network, but I am f**ked if i can figure it out...

I have no firewall...

[VRay]

Yeah, that;'s the problem. RH9 does not have the skip-networking option in my.cnf anymore. I am trying to figure out where it is now...