問:mysqlnd cannot connect to MySQL 4.1 using the old insecure authentication. Please use an istration 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
怎么解決?是不是空間少了什么配置?,mysqlnd無法使用舊的不安全身份驗(yàn)證連接到MySQL 4.1 。
答:您好,查看到是數(shù)據(jù)庫連接加密問題,現(xiàn)在為您更換服務(wù)器,現(xiàn)在連接正常,現(xiàn)在沒有該報(bào)錯(cuò),查看到網(wǎng)站首頁訪問404,請(qǐng)核實(shí)您的程序上設(shè)置,非常感謝您長期對(duì)我司的支持!
問:通過php mysqli_connect 連接mysql數(shù)據(jù)庫,提示:
\”PHP Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1 using the old insecure authentication. Please use an istration 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 D:\\www\\zwillingxu\\www\\includes\\DB_connector.php on line 13 PHP Fatal error: Call to undefined function 聽die() in D:\\www\\zwillingxu\\www\\includes\\DB_connector.php on line 16\”,網(wǎng)上查過后說故障是因?yàn)榉?wù)器側(cè)使用16位加密,mysqlnd使用41位加密。mysqlnd無法連接導(dǎo)致。煩請(qǐng)盡快協(xié)助處理,謝謝!
答:您好,已經(jīng)為您更換PHP版本為 5.2 請(qǐng)?jiān)贉y試下 ,非常感謝您長期對(duì)我司的支持!
問:謝謝這么快回復(fù)。已經(jīng)連接上了。但是從服務(wù)器里讀出來的漢字都是??。我phpmy里看到數(shù)據(jù)庫是utf8的,我的頁面也是utf8,php頁面也是utf8。請(qǐng)問是我和服務(wù)器側(cè)編碼不匹配嗎?
答:您好,
附圖,我司查看您的數(shù)據(jù)庫中的中文數(shù)據(jù)都是正常顯示,如頁面出現(xiàn)亂碼的情況,請(qǐng)您檢查下頁面調(diào)用的數(shù)據(jù)編碼格式是否一致,非常感謝您長期對(duì)我司的支持!