How to change the max_connection

[dassh]

Hi,
I am developing a java application that uses MySQL. MySQL is installed in a Windows machine. I want to change the max_connection from 100 to 500. I am able to do it thru command line but it exists only during a session. when i restart my PC, the max_connection is set to 100.

I want to set the max_connection to 500 permanently. From web site I found that my.cnf file is there and we can change the max_connection there. But in windows, I am unable to find any my.cnf file.

Pls let me know how to rid out of this problem.

Thanks in advance.

-Shantanu

 

[TonyGroves]

Your config file could be named my.ini .

 

[dassh]

Hi Tony,
Thanks for ur response.

I am not finding any .ini file in mysql installation path. I installed mysql in a windows machine. I found some cnf files like my-small.cnf, my-medium.cnf etc in root path of mysql installation. I am not seeing any other configuration files.

Thanks
Shantanu

 

[TonyGroves]

It would be in your root directory (c:\) or system directory (c:\windows or whatever). The my-small.cnf etc. files are templates you can use to create your own my.cnf.