问: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无法使用旧的不安全身份验证连接到MySQL 4.1 。
答:您好,查看到是数据库连接加密问题,现在为您更换服务器,现在连接正常,现在没有该报错,查看到网站首页访问404,请核实您的程序上设置,非常感谢您长期对我司的支持!
问:通过php mysqli_connect 连接mysql数据库,提示:
\”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\”,网上查过后说故障是因为服务器侧使用16位加密,mysqlnd使用41位加密。mysqlnd无法连接导致。烦请尽快协助处理,谢谢!
答:您好,已经为您更换PHP版本为 5.2 请再测试下 ,非常感谢您长期对我司的支持!
问:谢谢这么快回复。已经连接上了。但是从服务器里读出来的汉字都是??。我phpmy里看到数据库是utf8的,我的页面也是utf8,php页面也是utf8。请问是我和服务器侧编码不匹配吗?
答:您好,
附图,我司查看您的数据库中的中文数据都是正常显示,如页面出现乱码的情况,请您检查下页面调用的数据编码格式是否一致,非常感谢您长期对我司的支持!