ALTER USER 'user'@"localhost" IDENTIFIED WITH mysql_native_password BY 'password'
mysql> FLUSH PRIVILEGES;