Shulou(Shulou.com)06/01 Report--

1. The copy code of MYSQL installation directory is as follows: select @ @ basedir

2. The copy code for MYSQL data file directory is as follows: select @ @ datadir

3. Accordingly, the configuration file is in the directory one level above the data file

4. Stop the MYSQL service to copy the code as follows: net stop native mysql service name

5. Start the MYSQL service and copy the code as follows: net start native mysql service name

6. Configure parameter max_allowed_packet

The maximum size of the cache for client / server communication, which defaults to 4m

7. Configuration parameter net_buffer_length

TCP/IP and socket communication buffer size to create rows up to net_buffer_length. Default is 1m.

Summary

The above is the picture and text analysis of the MYSQL5.7 configuration file under the Windows environment introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.