search

10sr / machine-setups

My Instances setups
https://3ends.info
The Unlicense
0 stars 0 forks source link

Cannot set mysql root password #130

Closed 10sr closed 4 years ago

10sr commented 4 years ago

https://stackoverflow.com/a/43424234/6219249

10sr commented 4 years ago

ubuntu のデフォルトはパスワード認証じゃないなんか別の奴やってるらしい

10sr commented 4 years ago

なんでそんなことしてるの？？？？？？？？？？？？？？？？？？？？？

10sr commented 4 years ago

https://fsck.jp/?p=793

10sr commented 4 years ago

https://stackoverflow.com/questions/41846000/mariadb-password-and-unix-socket-authentication-for-root

10sr commented 4 years ago

https://jyn.jp/ubuntu-16-04-mariadb-password-bug/

10sr commented 4 years ago

こういう感じにすると unix_socket ログインをしているか調べられる

MariaDB [(none)]> select host, user, plugin from mysql.user;
+-----------+------+-------------+
| host      | user | plugin      |
+-----------+------+-------------+
| localhost | root | unix_socket |
| %         | 10sr |             |
+-----------+------+-------------+
2 rows in set (0.00 sec)