이 오류가 무슨오류인가요?
본문
Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in /home/shopy002/public_html/lib/common.lib.php on line 1423
Connect Error: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
------------------------------------------------------------
호스트먼트에서 영카트5를 설치하고 나서 마지막mysql 정보를 넣고 그 다음으로 넘기니
이런 오류가 뜹니다 이제 무슨 오류인가요? 고수님들 가르쳐주세요 ㅜ
답변 5
If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in /home/shopy002/public_html/lib/common.lib.php on line 1423
my.cnf에 old_password를 주석처리하라는 말입니다.
서버 /etc/my.cnf를 열어서 old_passwords=1부분을
#old_passwords=1
앞에 #를 붙혀서 주석처리하시면 됩니다.
1. MYSQL 암호가 틀린경우.
2. 제공되는 MYSQL 버전이 4.1 이하인경우
호스팅 받는 사이트의
PHP / MySql 버전이 너무 낮은것 같네요
설치중이시라면
웹호스팅을 초기화 하시고, PHP / MySql버전을 좀더 높은것으로 선택하신다음에
다시 시도해보세요
php , mysql 버전문제에요 .