Kudos
Collect
Twiiter
Facebook
Share
Develop somethings, meditation, reading and thinking...

MySQL 8 login error because of new authentication

Last updated over 3 years ago
1 0 0 0

MySQL 8 부터는 로그인 방식이 바뀌었다. 설치할 때 기존 로그인 방식을 선택하면 되지만 새로운 로그인 방식을 선택하면 PHP 등에서 MySQL 에 접속을 하면 다음과 같은 에러를 만나게 된다.

2lgWaLprSq.png
The server requested authentication method unknown to the client

MySQL 에서도 기존의 로그인 방식을 사용하는 방법은 다음과 같다.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
BY 'your_password';  

Mics.

Hi, my name is Richard. I’m a developer wants to make the world better with logic power. Mainly I use Linux, Nginx, MySQL, PHP and JavaScript . I want to share my knowledge with someone that it was also based from some great persons via LYNMP. 👨‍💻

Related Articles
Essedrop - Make your file online instantly
 

Responses

Leave a response to @richard

Please sign in to comment.
Markdown is also available in comment.