GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
It won't set up a new account, just add the privilege for you.
-Sheeri
On 5/26/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
Hello
How to set "FILE privilege enable" to an already defined user ?
It seems that I have to read the all manual for that.
I cannot find an example in the on line manual.
thanks.
- Gilles -
-------------------------------------------------
I will end up running mysql as root.
1-I set up an user
mysql> GRANT SELECT, INSERT, UPDATE, CREATE ON dr4.* to 'wr'@'localhost'
IDENTIFIED BY 'the_passwd';
2- It works fine :
mysql> select my_item from my_table ;
give it fine.
3- Now I want to select and put the results into a file :
mysql> select my_item from my_table into outfile'/tmp/my_outfile';
ERROR 1045 (28000): Access denied for user 'wr'@'localhost' (using
password: YES)
4- So I go the online doc , look for "outfile" keyword
and I find that I must have FILE privilege enabled.
So on the online doc, I look for the syntax for "FILE privilege
enable"
5- hu.... then I decide to run mysql client as root (of mysql)
the same command as above (-3) works fine
A note to the manual writer : If you want that more people use database,
do not make tons : just a tree-like doc.
otherwise most people will continue to consider that grep into a file
is fine for "database".
=_==_==_==_==_==_=
=¯==¯==¯==¯==¯==¯=
Gilles Missonnier
IAP - [EMAIL PROTECTED]
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
