Shulou(Shulou.com)06/01 Report--

Report an error when you clearly have select permission.

Mysql > select * from server into outfile'/ tmp/tt.txt'

ERROR 1045 (28000): Access denied for user 'chenliang'@'%' (using password: YES)

Baidu needs to give file permission after.

Mysql > grant file on *. * to chenliang

Query OK, 0 rows affected (0.00 sec)

Guide again or report an error?

Mysql > select * from server into outfile'/ tmp/tt.txt'

ERROR 1290 (HY000): The MySQL server is running with the-- secure-file-priv option so it cannot execute this statement

This error is different. This error is caused by a parameter.

Restart after the configuration file is added

Secure_file_priv=''

Exported successfully

Mysql > select * from server into outfile'/ tmp/tt.txt'

Query OK, 27 rows affected (0.00 sec)

I haven't adjusted this parameter before in version 5.6.24, maybe the default value is'', and the default value of the high version is changed to null, so you must pay attention to it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.