MySQL Workbench での設定とTips

外部参照の無効/有効
SET FOREIGN_KEY_CHECKS = 0/1;

Read only 権限のユーザ

mysql> GRANT SELECT ON *.* TO 'username'@'host_or_wildcard' IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;

MySQL のユーザ一覧を参照

mysql> select host, user from mysql.user;