すべての権限を持つユーザを追加する
mysql> GRANT ALL ON *.* TO ユーザー名@"localhost"IDENTIFIED BY "パスワード";
Query OK, 0 rows affected (0.00 sec)mysql> SELECT host,user FROM mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| localhost | root |
| localhost | seta |
| localhost | seya |
+-----------+------+
3 rows in set (0.00 sec)
ユーザーを消去する
mysql> DELETE FROM mysql.user WHERE user='ユーザ名';
Query OK, 1 row affected (0.07 sec)mysql> SELECT host,user FROM mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| localhost | root |
| localhost | seya |
+-----------+------+
2 rows in set (0.00 sec)
