[MYSQL] Error caching_sha2_password
Progamming/DB2022. 5. 19. 13:53
- plugin 조회
SELECT Host,User,plugin,authentication_string FROM mysql.user where User ='root'\G
- User 변경
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';
'Progamming > DB' 카테고리의 다른 글
[MYSQL] Error The slave I/O thread stops because master and slave have equal MySQL server UUIDs (0) | 2022.05.19 |
---|---|
[MYSQL] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (0) | 2022.05.19 |
Mysql Base64 encode/decode (0) | 2022.04.04 |
MYSQL my.cnf 설정 가이드 (0) | 2022.02.21 |
MYSQL 컬럼 구조 조회 (0) | 2022.02.09 |