12,504
回編集
差分
ナビゲーションに移動
検索に移動
→Failed! Error: SET PASSWORD has no significance for user... エラー
*https://dev.mysql.com/doc/refman/8.0/ja/resetting-permissions.html
<pre>
ubuntu@ip-172-26-11-57:~$ sudo systemctl stop mysql-u debian-sys-maint -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 9Server version: 8.0.30-0ubuntu0.20.04.2 (Ubuntu) Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> set password for 'root'@'localhost' = 'North@123';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';Query OK, 0 rows affected (0.01 sec)
</pre>
*mysql.initファイルに記入
© 2006 矢木浩人
