CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password'; CREATE USER 'gilang'@'localhost' IDENTIFIED BY 'hello123'; --> untuk buat create user GRANT ALL PRIVILEGES ON * . * TO 'gilang'@'localhost'; ---> Jalankan perintah ini untuk memberikan semua akses database kepada user baru: select user,host from mysql.user; ---> untuk mengakses mysql root ke user CREATE USER 'gilang1'@'localhost' IDENTIFIED BY 'hello'; GRANT ALL PRIVILEGES ON * . * TO 'gilang2'@'localhost'; CREATE USER 'gilang2'@'localhost' IDENTIFIED WITH mysql_native_password BY 'gilanggans';