hi...

so i have this user in the user table in the mysql db that has all the
privileges but "grant". now i need for that user to have the "file"
privilege so it can do "into outfile". thing is i don't see that
privilege anywhere in the db table. i know that i have to do the "grant
file on user@localhst" thing but what table does that write to?
also if i have all the other privileges granted and just need to add the
"file" one, do i have to re-grant all the rest of those or it'd just add
the "file" privilege to all the already granted ones?

the tables_priv, columns_priv and procs_priv don't have any "file"
privilege listed.

this is the list of privileges i can see off the db table:

| Select_priv | enum('N','Y')
| Insert_priv | enum('N','Y')
| Update_priv | enum('N','Y')
| Delete_priv | enum('N','Y')
| Create_priv | enum('N','Y')
| Drop_priv | enum('N','Y')
| Grant_priv | enum('N','Y')
| References_priv | enum('N','Y')
| Index_priv | enum('N','Y')
| Alter_priv | enum('N','Y')
| Create_tmp_table_priv | enum('N','Y')
| Lock_tables_priv | enum('N','Y')
| Create_view_priv | enum('N','Y')
| Show_view_priv | enum('N','Y')
| Create_routine_priv | enum('N','Y')
| Alter_routine_priv | enum('N','Y')
| Execute_priv | enum('N','Y')
| Event_priv | enum('N','Y')
| Trigger_priv | enum('N','Y')


thanks...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql