<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)