MySQL. 비밀번호 인증방식 변경하기(mysql_native_password, auth_socket)

< 정리 > 

 

"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';