# gave a user password and with mysql_native_pass
ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_pass
                             word BY 'pswd';