그누보드 설치중 에러메세지(mysqli_connect(): The server requested authentication method unknown to the client )가 뜨는데 왜 그런가요? 채택완료
답변 1개
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. */
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인