Solve the problem of secure_file_priv null

Solve the problem of secure_file_priv null

Add secure_file_priv = ' '; then run cmd as an administrator,

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 show variables like '%secure%'; command to view the value of secure_file_priv .

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

secure_file_priv is NULL to prohibit the export of files secure_file_priv=""

secure_file_priv specifies the address to restrict the export address to this address only secure_file_priv=“D:/”

secure_file_priv is empty and can be exported to any file secure_file_priv=

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 solution

Administrator 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 show variables like “%secure%”; you can see success

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:
  • Solution to secure-file-priv problem when exporting MySQL data
  • MySQL online log library migration example
  • How to clean up data in MySQL online database
  • How to create a table in mysql and add field comments
  • Optimized implementation of count() for large MySQL tables
  • Introduction to the use of MySQL source command
  • Causes and solutions for MySQL too many connections error

<<:  Echarts implements switching different X-axes in one graph (example code)

>>:  Shell script builds Docker semi-automatic compilation, packaging and release application operations

Recommend

How to use shell to perform batch operations on multiple servers

Table of contents SSH protocol SSH Connection pro...

How to install MySQL database on Ubuntu

Ubuntu is a free and open source desktop PC opera...

Build a server virtual machine in VMware Workstation Pro (graphic tutorial)

The VMware Workstation Pro version I use is: 1. F...

Let the web page redirect to other pages after opening for a few seconds

Just add the following code to achieve it. Method ...

10 skills that make front-end developers worth millions

The skills that front-end developers need to mast...

Pure CSS3 to create page switching effect example code

The one I wrote before is too complicated, let’s ...

Vue uses GraphVis to develop an infinitely expanded relationship graph

1. Go to the GraphVis official website to downloa...

Web page image optimization tools and usage tips sharing

As a basic element of a web page, images are one ...

Solution to elementui's el-popover style modification not taking effect

When using element-ui, there is a commonly used c...

Introduction to HTML page source code layout_Powernode Java Academy

Introduction to HTML page source code layout This...

Common date comparison and calculation functions in MySQL

Implementation of time comparison in MySql unix_t...

Data Structure - Tree (III): Multi-way Search Tree B-tree, B+ tree

Multi-way search tree Height of a complete binary...

Vue realizes cascading selection of provinces, cities and districts

Recently, I need to implement a cascading selecti...

Summary of ways to implement single sign-on in Vue

The project has been suspended recently, and the ...