Kerap bermasala di autentifikasi [1]:
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
Jika gagal, pastikan user sudah dihapus dengan benar, jika sebelumnya pernah dibuat :
DROP monty@localhost ;
FLUSH PRIVILEGES :
Baru ulangi perintah create user diatas.
Mengubah password
alter user 'username'@'localhost' identified by 'password';
Referensi
- What’s New in MySQL 8.0? (Generally Available), https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/
- Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server, https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server
