Record the problems you solve for others. Problem Description The version of MySQL is 5.7 and the operating system is window10. MySQL is installed in C:\Program Files. Recently, you need to add a new configuration item to the my-default.ini configuration file in the MySQL installation directory: max_allowed_packet=100M After editing a file, I always fail to save it and get the message "Access Denied". Workaround 1. Stop the MySQL service. 2. Open the file browser. File -> Change folder and search options -> "View" tab -> uncheck all hidden files and folders. 3. You can now see the hidden folder C:\ProgramData\MySQL\MySQL Server 5.7. In this folder there is a my.ini configuration file. MySQL reads this configuration file by default. 4. Copy myini to another disk, such as drive D. 5. Modify D:\my.ini and save. Note: max_allowed_packet=100M should be placed under the [mysqld] configuration section. You can search for this parameter first. If the system already has it, just change the number. 6. Delete my.ini in the original installation directory as an administrator. 7. Open the Start menu, right-click on the command line menu item -> Run as administrator. Execute the command: copy "D:\my.ini" "C:\ProgramData\MySQL\MySQL Server 5.7" Seventh, start the MySQL service. think Win10 restricts files and folders to be modified only with administrator privileges. So use this command line to solve the problem. At the same time, MySQL reads the my.ini configuration file under C:\ProgramData\MySQL\MySQL Server 5.7 by default. The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: jQuery implements clicking left and right buttons to switch pictures
>>: Detailed explanation of Tomcat's Server Options
1. HTML Overview htyper text markup language Hype...
Preface Locks are synchronization mechanisms used...
Environmental Description: There is a running MyS...
Today I sent a small tool for Ubuntu to a custome...
Table of contents 1. Environment Introduction 2. ...
0. What is a tag? XML/HTML CodeCopy content to cl...
In today's development environment, fast is b...
Table of contents 1. Component switching method M...
1. Introduction When a web project is published o...
As shown below: LOCATE(substr,str) Returns the fi...
There are many loop statements in JavaScript, inc...
This article mainly explains the style of buttons...
Previously, the images we used were all pulled fr...
Controversy over nofollow There was a dispute bet...
1. Basic lines 2. Special effects (the effects ar...