# MySQL 8.0預設密碼加密方式由原本mysql_native_password 改成 caching_sha2_password
# 怕Client端連線有問題,先設定為IDENTIFIED WITH mysql_native_password
ALTER USER 'mysqluser1'@'%' IDENTIFIED WITH mysql_native_password BY '自訂密碼';
GRANT ALL ON *.* TO 'mysqluser1'@'%';
CREATE USER 'mysqluser2'@'%' IDENTIFIED WITH mysql_native_password BY '自訂密碼';
GRANT ALL ON *.* TO 'mysqluser2'@'%';
FLUSH PRIVILEGES;
調整前Client端連線的錯誤訊息:
FLUSH PRIVILEGES;
調整前Client端連線的錯誤訊息:
Retrieval of the RSA public key is not enabled for insecure connections.
沒有留言:
張貼留言