MariaDB Grant

최대 1 분 소요

Show User

SELECT HOST,USER,PASSWORD FROM USER

Generate User

CREATE USER '${user.id}'@'%' IDENTIFIED BY '${password}';

Grant

GRANT ALL PRIVILEGES ON ${db.name}.* TO '${user.id}'@'%';
FLUSH PRIVILEGES;

Delete User

DROP USER ${user.id}@${host}

카테고리:

업데이트: