3C手札

今天安裝phpMyAdmin於Ubuntu中，

但設定MySQL server密碼時卻老是顯示:  

Since password will be sent to server in plain text, use ssl connection to ensure password safety.

Warning (Code 1287): 'SET PASSWORD = PASSWORD('<plaintext_password>')' is deprecated and will be removed in a future release. Please use SET PASSWORD = '<plaintext_password>' instead

SET PASSWORD has no significance for user 'root'@'localhost' as authentication plugin does not support it.

等訊息。


解決方法:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypasswordhere';


參考資料: https://stackoverflow.com/questions/47099351/mysql-5-7-20-unable-to-set-root-password