membatasasi privileges database mysql

grant privileges :

GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';

membatasi privileges akses DB:
mysql> GRANT USAGE ON *.* TO 'francis'@'localhost'
    ->     WITH MAX_QUERIES_PER_HOUR 100;

 

Tinggalkan Balasan