Web Hosting Talk







View Full Version : MySQL - How to setup my.cnf


Jason King
12-07-2001, 09:33 PM
How do I setup my.cnf for mysql if I don't already have one in /etc.
I want to set some variables such as:
wait_timeout
max_connections
max_user_connections
I created a "my.cnf" file and uploaded it to /etc and it killed my mysql.
It wasn't very easy to get mysql working again so trial and error isn't an option.
I am using MySQL 3.23.37 cobalt package version on a ra4i.

If there is another way of setting those variables let me know.

funkee
12-08-2001, 06:45 AM
Look in the Mysql Source distrobution -- there are a few example my.cnf files ......

bobcares
12-08-2001, 08:04 AM
HI!
Why not first try to locate my.cnf. It may be there in some other directory (say /usr/local/etc/) and then modify the file.

Have a great day :)

regards
amar

Jason King
12-08-2001, 02:04 PM
Figured it out, thanks for the help.
I forgot to shutdown mysql before moving the file into place the first time :rolleyes: