Add Enter mysql/bin to stop the mysql service net stop mysql, and restart the mysql service net start mysql. log in mysql mysql -u root -p enter password: password Run the Note: secure_file_priv is used to set the location where load data can be imported and exported. Supplement: The problem that secure_file_priv does not take effect in the MYSQL configuration file my.ini. MYSQL modifies the export file address settings into three types This configuration can only be modified in my.ini. Previously, I encountered a situation where changing secure_file_priv= in my.ini to various formats did not work. I was entangled for a night, and after researching, I found the solutionAdministrator CMD enters the DOS command interface Type mysql --help to view the limited folders where mysql reads files. Move the modified my.ini file to one of the folders. net stop mysql,net start mysql restart service, after logging in Supplement: Solve the problem that the MySQL configuration file my.ini does not work First you need to know which my.ini you are running. Most my.ini files are located in the root directory of the MySQL installation directory. Check which folder's configuration file is started under your MySQL service in the service As shown in the figure, go to the correct directory to find the run file. There are two solutions after finding it:I recommend the second one, which is simple and rough. 1. Change the path in the above picture to your own my.ini path. (You should modify it in the registry) 2. Find the file directly in the directory in the picture above, copy your configuration file to the directory or modify it directly in it. (The ProgramData folder is hidden by default, just check Show hidden folders in Folder Options) The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM. If there are any mistakes or incomplete considerations, please feel free to correct me. You may also be interested in:
|
<<: Echarts implements switching different X-axes in one graph (example code)
Table of contents SSH protocol SSH Connection pro...
Ubuntu is a free and open source desktop PC opera...
The VMware Workstation Pro version I use is: 1. F...
Just add the following code to achieve it. Method ...
The skills that front-end developers need to mast...
The one I wrote before is too complicated, let’s ...
1. Go to the GraphVis official website to downloa...
As a basic element of a web page, images are one ...
When using element-ui, there is a commonly used c...
Introduction to HTML page source code layout This...
Implementation of time comparison in MySql unix_t...
Multi-way search tree Height of a complete binary...
Recently, I need to implement a cascading selecti...
The project has been suspended recently, and the ...
1. Download the installation package The installa...