-[[MySQLのアクセス権限を設定:http://www.rfs.jp/server/mysql/02/03.html]] * 権限一覧 [#m8b10d4a] | 権限 | Column | Context |h | select | Select_priv | tables | | insert | Insert_priv | tables | | update | Update_priv | tables | | delete | Delete_priv | tables | | index | Index_priv | tables | | alter | Alter_priv | tables | | create | Create_priv | databases, tables/indexes | | drop | Drop_priv | databases/ tables | | grant | Grant_priv | databases/ tables | | reload | Reload_priv | server administration | | shutdown | Shutdown_priv | server administration | | process | Process_priv | server administration | | file | File_priv | file access on server | -fileの権限を与えると、LOAD DATA INFILE と SELECT ... INTO OUTFILE構文を使用して、サーバーのファイルを読み書きする事ができる -一般のアプリケーション向け ... select,insert,update,delete,file