{ Berbagi, Menulis, Dan Mengajar } Ilmu…

DELETE USERNYA KALO SUDAH ADA,

———————–

SELECT User,Host FROM mysql.user;

DROP USER ‘testuser’@’localhost';

—-

mysql> CREATE USER ‘NamaUser’@’localhost’ IDENTIFIED BY ‘passwordnya';

Query OK, 0 rows affected (0.52 sec)

mysql> GRANT SELECT ON *.* TO ‘NamaUser’@’localhost';
Query OK, 0 rows affected (0.12 sec)

Issue the GRANT command now to grant those permissions:

GRANT ALL PRIVILEGES ON *.* TO ‘debian-sys-maint’@’localhost’ IDENTIFIED BY ‘n4aSHUP04s1J32X5′;

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘debian-sys-maint’@’localhost’ IDENTIFIED BY ‘n4aSHUP04s1J32X5′;

GRANT ALL PRIVILEGES ON *.* TO ‘dimas’@’localhost’ IDENTIFIED BY ‘okedeh';