MySQL会话/用户的FILE特权 [英] FILE privilege to MySQL session/user

问题描述

当有人在我的MySQL数据库中注册时，此功能必须起作用:

When someone is registerd in my MySQL database, this function must work:

mysql_query("SELECT mail 
               FROM users 
               INTO OUTFILE 'test.txt'");

但是我得到了错误

拒绝用户'registerdb'@'％'的访问(使用密码:是)

Access denied for user 'registerdb'@'%' (using password: YES)

那么我如何授予FILE对会话/用户的写权限?

So how I give the FILE writing permission to the session/user?

推荐答案

检查该用户的权限:

SHOW GRANTS FOR'registerdb'@'％'

SHOW GRANTS FOR 'registerdb'@'%'

如果没有列出的FILE权限，只需添加它:

If there no listed FILE permission, just add it:

GRANT FILE ON .到'registerdb'@'％'

GRANT FILE ON . to 'registerdb'@'%'

然后:

冲洗特权；

FLUSH PRIVILEGES;

但是要提防在*.*上授予FILE权限，实际上，您实际上是

But beware for by doing granting the FILE permission on *.* you are essentially giving that user full access to any file the server.

要限制限制文件可以放置的位置要进行读写，请将secure_file_priv系统设置为特定目录.

这篇关于MySQL会话/用户的FILE特权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！