MySQL - 版の履歴

Piroto: /* phpMyAdmin */

2023-11-13T10:57:36Z

phpMyAdmin

2023-10-24T11:10:02Z

CentOS(yumからインストール)

2023-04-18T03:32:29Z

制約を無視してテーブルをtruncateする

2022-10-22T17:08:38Z

Failed! Error: SET PASSWORD has no significance for user... エラー

2022-10-22T17:03:06Z

Failed! Error: SET PASSWORD has no significance for user... エラー

2022-10-22T17:01:32Z

Failed! Error: SET PASSWORD has no significance for user... エラー

2022-08-30T13:58:33Z

Failed! Error: SET PASSWORD has no significance for user... エラー

2022-08-30T13:57:24Z

Failed! Error: SET PASSWORD has no significance for user... エラー

2022-08-30T13:52:47Z

初期の権限変更ツール mysql_secure_installation

2022-08-30T13:43:35Z

Failed! Error: SET PASSWORD has no significance for user... エラー

@@ 509行目: / 509行目: @@
 ===[[phpMyAdmin]]===
 *[[phpMyAdmin]]
 ==管理==

@@ 78行目: / 78行目: @@
   # [[chkconfig]] | grep "mysql"
   mysql          	0:off	1:off	2:on	3:on	4:on	5:on	6:off
 ===権限の初期設定===
 *http://dev.mysql.com/doc/refman/5.1-olh/ja/unix-post-installation.html

@@ 534行目: / 534行目: @@
   kill [Id]
 ==[[SQL]]==
 ===制約を無視してテーブルをtruncateする===
 ----
@@ 540行目: / 547行目: @@
   mysql&gt; truncate table hoge;
   mysql&gt; SET FO[[R]]EIGN_KEY_CHECKS=1;
 ===パーティショニング===
 ----

@@ 204行目: / 204行目: @@
 </pre>
 *https://dev.mysql.com/doc/refman/8.0/ja/resetting-permissions.html
 <pre>
 ubuntu@ip-172-26-11-57:~$ mysql -u debian-sys-maint -p
@@ 225行目: / 221行目: @@
 mysql> set password for 'root'@'localhost' = 'NewPassword';
 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 WITH mysql_native_password by 'NewPassword';
 Query OK, 0 rows affected (0.01 sec)

@@ 205行目: / 205行目: @@
 *https://dev.mysql.com/doc/refman/8.0/ja/resetting-permissions.html
 <pre>
-kill `cat /mysql-data-directory/host_name.pid`
+mysql> FLUSH PRIVILEGES;
-ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
+mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
 </pre>
 <pre>

@@ 193行目: / 193行目: @@
 =====Failed! Error: SET PASSWORD has no significance for user... エラー=====
 ----
-*https://level69.net/archives/30666
+*上記「Ubuntu 初期パスワードの場所」のユーザーでログイン
 <pre>
 Estimated strength of the password: 100

@@ 219行目: / 219行目: @@
 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-mysql> set password for 'root'@'localhost' = 'North@123';
+mysql> set password for 'root'@'localhost' = 'NewPassword';
 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';