12,665
回編集
差分
ナビゲーションに移動
検索に移動
→Failed! Error: SET PASSWORD has no significance for user... エラー
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password for 'root'@'localhost' = 'North@123NewPassword';
ERROR 4102 (HY000): SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
© 2006 矢木浩人
