How to modify MySQL

Connection|mysql Remember that there was a netizen here asked how to modify the maximum number of MySQL connection problem, as if not get a complete answer (I remember as if), today suddenly received a Netizen csdn sent an e-mail to ask this question, So I went to the MySQL site to find the answer, but I am disappointed that I did not find a specific solution (perhaps I am not too careful for the sake), suddenly remembered in DOS can be modified by the command, but into the DOS, see Help, How also did not think up the original read the command (memory is not good in time to save), no way, had to exit DOS to find information again, When I quit, I suddenly found a my-example.cnf file in the MySQL directory (not seen on Windows, showing all hidden files). cnf file is not config? So I opened it, and finally I found the answer! The solutions are as follows:

Execute in the program-〉 run: Notepad yourmysqlpath/my-example.cnf, copy the contents of the my-example.cnf file into a new text file, find [mysqld], See there are some things like set-variable on the bottom of it? After the last set-variable = add set-variable = max_connections= The number you want, and then save the text file as c:/ MY.CNF file (if you have this file, modify it directly), this time you enter under the MySQL bin directory under DOS, execute mysqld--help, after execution you will see Max_connections value is the value you fill in above. Other system variables are modified and modified max_connections in a similar way.

So careful, the benefits of seeing more documents are obvious, in the programming is so, we should be clearer than I know this, I still did not find the direct use of the command to modify the parameters of the method (of course, then did not find), if the Netizen knows or found, please speak out, thank you!

Anyway the problem is solved (please don't think I wordy), and finally wish you happy Mid-Autumn Festival! Send you a few pieces of moon cakes that are not very similar! (Is it enough?) At least enough wayne.xiao to eat, because it's just me and him online, but I guess this guy forgot to turn off the browser, maybe he wasn't online!!!!! )