MySQLでユーザの追加と消去

すべての権限を持つユーザを追加する

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)
mysql>