<aside> 💡 mysql_native_password 처리를 해주어야 한다고 한다.

</aside>

먼저 루트 계정으로 mysql db에 접속한다.

use mysql

이후 user 확인을 해준다.

*SELECT user,authentication_string,plugin,host FROM mysql.user;*

*mysql> use mysql;
Database changed
mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| user             | authentication_string                                                  | plugin                | host      |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost |
P-a8^U2|E~nCsYPgiY923oydX1WoTg0hJRHJk9hithSIbcBMt/uV5 | caching_sha2_password | localhost |
| Ryeo             | $A$005$SeC5`5c:g1H.<3!(RV7nFfuiUVIQB4qGRFoFjQK4oeg37svliw7yj5Pr7J/0 | caching_sha2_password | ryeo      |
+------------------+------------------------------------------------------------------------+-----------------------+-----------+
5 rows in set (0.00 sec)*

이후 모든 권한을 부여한다.

GRANT ALL PRIVILEGES ON *.* TO 'ryeo'@'localhost';

GRANT GRANT OPTION ON *.* TO 'ryeo'@'localhost';

변경 사항을 저장한다.

flush privileges;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'ryeo'@'localhost';
Query OK, 0 rows affected (0.04 sec)

mysql> GRANT GRANT OPTION ON *.* TO 'ryeo'@'localhost';
Query OK, 0 rows affected (0.04 sec)

이후 mysql_native_password 처리를 해준다.

ALTER user 'ryeo'@'localhost' IDENTIFIED WITH mysql_native_password by 'todo';

mysql> ALTER user 'ryeo'@'localhost' IDENTIFIED WITH mysql_native_password by 'todo';
Query OK, 0 rows affected (0.01 sec)