MySQL Settings

Posted March 31, 2013 5.5k views
The list below is what the script requires me to do: MySQL 5.x Recommended configuration: interactive_timeout = 1000 connect_timeout = 1000 wait_timeout = 1000 How do i ensure these are set properly, am not sure how to do it in SSH or the location of the file. My server is running centos6 64bit with WHM/CPANEL.. Thank you

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers
I'm not sure for centos but for ubuntu it's /etc/mysql/my.conf (if memory serves me right).
nano /etc/my.cnf

ctrl+x. ( save)