MySQL/MariaDB 계정 삭제

✔️ MariaDB 10에서 테스트하였습니다.

1 개요

MySQL/MariaDB 계정 삭제

DROP USER

sql

Copy

DROP USER '계정'@'접속대역';

2 실행예시

Console

Copy

MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE User='rootuser' AND Host='%';
+----------+------+
| User     | Host |
+----------+------+
| rootuser | %    |
+----------+------+
1 row in set (0.00 sec)

MariaDB [(none)]> DROP USER 'rootuser'@'%';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE User='rootuser' AND Host='%';
Empty set (0.00 sec)

3 같이 보기

• MySQL/MariaDB 계정 생성

4 참고

• https://dev.mysql.com/doc/refman/5.7/en/removing-users.html