|
|
On Mon, 30 Jan 2012 23:56:15 -0500, kalin m <...@el.net
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
|