よく忘れがちなコマンドのメモ。
SQLモードの確認
mysql> select @@global.sql_mode \G
*************************** 1. row ***************************
@@global.sql_mode: NO_ENGINE_SUBSTITUTION
1 row in set (0.00 sec)
Hostとユーザ設定の確認
mysql> select host, user from mysql.user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | dev01 |
| % | dev02 |
| localhost | development |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
6 rows in set (0.00 sec)
ユーザの権限確認
mysql> SHOW GRANTS FOR 'development'@"%";