135-1821-9792

MySQL4.1+usingtheold怎么解决?

Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old ...

创新互联建站于2013年成立,先为临川等服务建站,临川等地企业,进行企业商务咨询服务。为临川企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

有些程序在安装时,出现如下错误:

Warning: mysql_connect(): 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 K:\WEB_2013\www.aerchi.com\***\***.php

这个问题主要就是因为数据库的登陆密码编码问题,将密码设置成41位,即可。

进入phpmyadmin,点击SQL。输入以下两条命令,然后执行即可。

  1. SET SESSION old_passwords = FALSE;
  2. SET PASSWORD = PASSWORD('your password');

复制代码

your password  替换为你自己的密码。


文章题目:MySQL4.1+usingtheold怎么解决?
文章位置:http://www.wtcwzsj.com/article/dpoiojc.html

其他资讯



Copyright © 2009-2022 www.wtcwzsj.com 青羊区广皓图文设计工作室(个体工商户) 版权所有 蜀ICP备19037934号