Belajar Pemrograman

mysql syntax

November 26th, 2005 by mbro

MEMBUAT USER

GRANT USAGE ON * . * TO 'mbro'@'localhost' IDENTIFIED BY '******' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

hak akses tables

GRANT ALL ON `wpdb`.`amni_links` TO 'mbro'@'localhost' WITH GRANT OPTION ;
GRANT ALL ON `wpdb`.`amni_*semua*` TO 'mbro'@'localhost' WITH GRANT OPTION ;

MENGHAPUS USER DAN REFRESH PRIVILLEGES

DELETE FROM `user` WHERE User = 'mbro' AND Host = 'localhost';

DELETE FROM `db` WHERE User = 'mbro' AND Host = 'localhost';

DELETE FROM `tables_priv` WHERE User = 'mbro' AND Host = 'localhost';

DELETE FROM `columns_priv` WHERE User = 'mbro' AND Host = 'localhost';

# Reloading the privileges …

FLUSH PRIVILEGES ;