My system doesn't seem to be using my.cnf file

[jim.thornton]

Is it possible for mysql to run successfully and NOT use a my.cnf file?

I've got everything working find with DA but I've recently installed vTiger into one of the accounts and was suddenly started having problems logging into it. So, I looked up the system requirements for vTiger to find that there were some MySQL requirements. It was working at one point, so I don't know why it would have just stopped logging in.

Anyway... I then logged into my box to find out what the my.cnf settings were only to find out there were no cnf files that seemed to be in use. I entered the following commands (with outputs):

# locate my.cnf
/etc/my.cnf.old
/etc/my.cnf.rpmsave
/usr/local/directadmin/conf/my.cnf

In the /usr/local/directadmin/conf/my.cnf there are only 3 lines. The first [client] then a user=value and password=value.

# cat /proc/$(pidof mysqld)/cmdline | tr '\0' '\n'
/usr/sbin/mysqld
--basedir=/usr
--datadir=/var/lib/mysql
--plugin-dir=/usr/lib64/mysql/plugin
--user=mysql
--log-error=/var/lib/mysql/s1.outoftheboxsites.com.err
--pid-file=/var/lib/mysql/s1.outoftheboxsites.com.pid

As you can see there is no defaults file listed.

-- Any suggestions on me figuring this out? I would appreciate any assistance I could get please.

 

[SeLLeRoNe]

If /etc/my.cnf doesnt exist, simply create that with the settings you need and restart MySQL, after that, it will start using /etc/my.cnf file

Also be sure that /root/.my.cnf doesnt exist

Regards

 

[jim.thornton]

Are there any "best settings" for basically running wordpress/joomla sites?

 

[SeLLeRoNe]

You can find some useful info's here: http://help.directadmin.com/item.php?id=44

Regards