MySQL 8.0

...

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

1. What’s New in MySQL 8.0? (Generally Available), https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/
2. 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