Where is my.cnf?

[lost123]

Hi,


I can't seem to find my my.cnf file.
I've looked inside /etc, however it's not there.

Any ideas where it could be?

Thank you

 

[chatwizrd]

It is not there by default you have to create it.

http://help.directadmin.com/item.php?id=44

 

[lost123]

It is not there by default you have to create it.

http://help.directadmin.com/item.php?id=44

So since it's not created, where is the server reading the settings from?
Thank you Chat.

 

[chatwizrd]

So since it's not created, where is the server reading the settings from?
Thank you Chat.

It will use whatever settings are default for those variables if you have no config setup.

 

[quleek]

By default it will have some setting. That will be too low. If you get mysql error please create that file and update the contents. If you have any problem still you need to optimise your database.

 

[Hank Freid]

Yes, I read all users and all have good opinions. So it is not there as default you have to create it himself.

Regards:
Hank Freid

 

[ForexGuides]

I am very interested in all the helpfull information about server tune-ups and see that one of the main things is tweaking the my.cnf file. I am unable to find one. When I run "locate my.cnf" from the root, allI get is this:

 

[daveyw]

Normally if you have one it should be in "/etc/my.cnf". If you dont have one, you can create one.

After changes you must restart MySQLd.

Also if you got one and 'locate' isn't showing it, then run the command "updatedb" as root.