You need to set ‘ secure_file_priv‘ with an empty value as shown below and restart MySQL service.
#MY FILE SECURE HOW TO#
Step 3: Restart MySQL service: # /etc/init.d/mysqld restart How to disable/remove secure_file_priv in MySQL?
Secure_file_priv="/usr/local/mysql-files" How to change the value of secure_file_priv in MySQL? So, what if you want to output into a different directory? To do that, you need to restart MySQL service with new value set to secure_file_priv option. Let’s check this now! mysql> select option_value from wp_options WHERE option_value LIKE ('%sess%') INTO OUTFILE '/var/lib/mysql-files/sam.txt' Similarly, if you want to output into a file (export), then it can only output to file that’s located within this directory. It means, if you ever want to load a file (import), then the file should be located within this directory. PSCredential is class that is composed of username (string) and password (SecureString). It uses reversible encrypting so the password can be decrypted when needed, but only by the principal that encrypted it. | secure_file_priv | /var/lib/mysql-files/ |Īs you can see the value of ‘ secure_file_priv‘ is ‘ /var/lib/mysql-files‘. - This type is like the usual string, but its content are encrypted in memory. mysql> show variables LIKE "secure_file_priv" Method 1: I would suggest you to enable the file download in Internet Explorer. To fix this error, you need to check the value of ‘ secure_file_priv‘ option. You might also get the above error while loading data file using ‘ LOAD DATA INFILE‘ in MySQL. Here are the snapshots of the error: mysql> select option_value from wp_options WHERE option_value LIKE ('%sess%') INTO OUTFILE '/tmp/sam.txt' ĮRROR 1290 (HY000): The MySQL server is running with the -secure-file-priv option so it cannot execute this statement If you are getting an error “ The MySQL server is running with the secure_file_priv option so it cannot execute this statement” while using ‘ LOAD DATA INFILE‘ or ‘ INTO OUTFILE‘, then here’s how you can fix it.
0 kommentar(er)
