
MySQL 报错 ERROR 1290 (HY000): running with the --secure-file-priv
mysql> show variables like '%secure%'; +————————–+...
mysql> show variables like '%secure%'; +————————–+...
select * into outfile '/home/update_testdbtest.txt' from update_test; ERROR 1290 (HY000): The MySQL server is ...
一个问题纠结很久,反复确认语法问题。但是后来网上搜了一下,茅塞顿开。特此总结一下。 mysql> grant select,insert,update,delete on *.* to 'root'@'%'; ERROR 1290 (...