MySQL. 비밀번호 인증방식 변경하기(mysql_native_password, auth_socket)
·
BackEnd(?)
"auth_socket -----> mysql_native_password" > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password'; > FLUSH PRIVILEGES;  "mysql_native_password -----> auth___socket" > ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;> FLUSH PRIVILEGES;  '변경사항 확인하기'> USE mysql;(사용하고자 하는 데이터베이스 변경)> SELECT user, host, plugin FROM mysql.user WHERE user='root';
HardConcentrator
'인증' 태그의 글 목록