No my.cnf file found

[jim.thornton]

I cannot find my.cnf file:

# locate my.cnf
/etc/my.cnf.old
/etc/my.cnf.rpmsave

I want to make sure that mysql is setup to block remote connections but I can't because I can't find the config file.

Any suggestions?

 

[smtalk]

It should be /etc/my.cnf. You've probably renamed the file to /etc/my.cnf.old in the past (the rpmsave file is a moved my.cnf file, most likely at the moment when MySQL RPMs were removed from the system). I would recommend checking the contents of /etc/my.cnf.old, and if the file looks okay, just do:

cp /etc/my.cnf.old /etc/my.cnf

 

[jim.thornton]

Can MySQL still function without the proper file??

I ask because, currently I can login to mysql via CLI and use it.

 

[smtalk]

Yes it would have no problems even without the my.cnf file, but for security reasons it's recommended to have the following in it: http://help.directadmin.com/item.php?id=208

 

[zEitEr]

Any suggestions?

You shoud either use find or make sure to run updatedb peridioticaly to update locate's DB.