Secure-file-prev (MySQL): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
Regel 18: | Regel 18: | ||
| /var/lib/mysql-files/ | | | /var/lib/mysql-files/ | | ||
+-----------------------+ | +-----------------------+ | ||
+ | 1 row in set (0.00 sec) | ||
+ | </pre> | ||
+ | |||
+ | Of: | ||
+ | |||
+ | <pre> | ||
+ | mysql> show variables like "secure_file_priv"; | ||
+ | +------------------+-----------------------+ | ||
+ | | Variable_name | Value | | ||
+ | +------------------+-----------------------+ | ||
+ | | secure_file_priv | /var/lib/mysql-files/ | | ||
+ | +------------------+-----------------------+ | ||
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
</pre> | </pre> |
Versie van 13 apr 2018 18:49
Foutmelding
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.012 sec
Aanvullende gegevens
Dit betreft een systeemvariabele:
mysql> select @@secure_file_priv; +-----------------------+ | @@secure_file_priv | +-----------------------+ | /var/lib/mysql-files/ | +-----------------------+ 1 row in set (0.00 sec)
Of:
mysql> show variables like "secure_file_priv"; +------------------+-----------------------+ | Variable_name | Value | +------------------+-----------------------+ | secure_file_priv | /var/lib/mysql-files/ | +------------------+-----------------------+ 1 row in set (0.00 sec)
Oftewel, standaard mag je alleen in- & uitvoeren naar deze map.
Oplossing
secure_file_priv=""
toevoegen aan [mysqld]
-gedeelte van my.cnf
.