1. Hakacces

2. Membuat user • CREATE USER user_specification [, user_specification] ... • user_specification: user [IDENTIFIED BY [PASSWORD] 'password']

3. contoh • To enable the user to connect with no password, include no IDENTIFIED BY clause: • CREATE USER 'jeffrey'@'localhost'; • To assign a password, use IDENTIFIED BY with the literal plaintext password value: • CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

5. Menghapus user • DROP USER user [, user] ... • DROP USER 'jeffrey'@'localhost';

6. Memberi Access • GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] priv_level TO user_specification [, user_specification] ... [REQUIRE {NONE | ssl_option [[AND] ssl_option] ...}] [WITH with_option ...] • object_type: • TABLE • | FUNCTION • | PROCEDURE • priv_level: • * • | *.* • | db_name.* • | db_name.tbl_name • user_specification: • user [IDENTIFIED BY [PASSWORD] 'password']

7. Privilege

8. Privilege cont’

9. Privilege cont’

10. Privilege cont’

11. Privilege cont’

12. contoh • CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass'; • GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; • GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; • GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

13. Global Privileges • Global privileges are administrative or apply to all databases on a given server. To assign global privileges, useON *.* syntax: • GRANT ALL ON *.* TO 'someuser'@'somehost'; • GRANT SELECT, INSERT ON *.* TO 'someuser'@'somehost';

14. Database Privileges • Database privileges apply to all objects in a given database. To assign database-level privileges, use ONdb_name.* syntax: • GRANT ALL ON mydb.* TO 'someuser'@'somehost'; • GRANT SELECT, INSERT ON mydb.* TO 'someuser'@'somehost';

15. Table Privileges • Table privileges apply to all columns in a given table. To assign table-level privileges, use ONdb_name.tbl_name syntax: • GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost'; • GRANT SELECT, INSERT ON mydb.mytbl TO 'someuser'@'somehost';

16. RENAME USER • RENAME USER old_user TO new_user [, old_user TO new_user] ... • Contoh • RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1';

17. REVOKE • REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] priv_level FROM user [, user] ... • REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... • Contoh • REVOKE INSERT ON *.* FROM jeffrey'@'localhost';

18. latihan • Buat user Diberiacess User pakainomorip Buktikan