Fix ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%' when using MySQL 8

1. Connet to MySQL DB:
mysql -u user -pPASSWORD
 
2. Just Run the following command:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';