테스트 사이트 - 개발 중인 베타 버전입니다

그누보드 설치중 에러메세지(mysqli_connect(): The server requested authentication method unknown to the client )가 뜨는데 왜 그런가요? 채택완료

쿠리쿠쿠 8년 전 조회 4,491
Warning: mysqli_connect(): The server requested authentication method unknown to the client [mysql_old_password] in /home/isnews/public_html/lib/common.lib.php on line 1423 Warning: mysqli_connect(): (HY000/2054): The server requested authentication method unknown to the client in /home/isnews/public_html/lib/common.lib.php on line 1423 Connect Error: The server requested authentication method unknown to the client
댓글을 작성하려면 로그인이 필요합니다.

답변 1개

채택된 답변
+20 포인트
굿
8년 전

The solution: 1. I have access to a MySQL server that actually functions properly so I was able to get the correct HASH in order to update the password which is a pre-requisite for this repair.

2. Run the following command in a SQL prompt on the working MySQL server: SELECT PASSWORD('Enter-Your-Password-Here'); /* This will return a 41 character Hexadecimal Digits. Copy all 41 characters */

3. Give this command to your hosting company to run: UPDATE mysql.user SET Password='Enter-41-Character-Hex-Here' WHERE User='Enter-Your-User-Here-That-You-Want-ToFix' AND Host='localhost'; /* localhost presumes that your MySQL server is on the same server as your website. If that is not the case then you will have to change localhost to whatever the mysql server computer name is. Your hosting company will know that. */

 

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인