MYSQLの権限
use mysql;
select * from user;
チェック
mysql> select Select_priv,Insert_priv,Update_priv,Delete_priv from user WHERE USER ='XXXXXX' ;
+-------------+-------------+-------------+-------------+
| Select_priv | Insert_priv | Update_priv | Delete_priv |
+-------------+-------------+-------------+-------------+
| N | N | N | N |
| N | N | N | N |
+-------------+-------------+-------------+-------------+
2 rows in set (0.00 sec)
mysql> UPDATE user SET Select_priv='Y' ,Insert_priv='Y',Update_priv='Y',Delete_priv='Y' WHERE USER ='XXXXXX' ;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select Select_priv,Insert_priv,Update_priv,Delete_priv from user WHERE USER ='XXXXXX' ;
+-------------+-------------+-------------+-------------+
| Select_priv | Insert_priv | Update_priv | Delete_priv |
+-------------+-------------+-------------+-------------+
| Y | Y | Y | Y |
| Y | Y | Y | Y |
+-------------+-------------+-------------+-------------+
2 rows in set (0.00 sec)
mysql>