$db=mysql_connect("124.172.118.122", "dbcms_f","123456");
if (!$db)
{
die('<br>连接错误: ' . mysql_error());
}
$sqlname="dbcmxs";//数据库的名
mysql_select_db($sqlname,$db)or die ("链接错误!! ");//连接到数据库
session_start();
mysql_query("SET NAMES 'utf8'",$db);//定义数据交互的语言格式错误信息是Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:553) in D:\workspace\php\fww\phpcms\inc\conn.php on line 2Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in D:\workspace\php\fww\phpcms\inc\conn.php on line 2Warning: mysql_connect() [function.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 D:\workspace\php\fww\phpcms\inc\conn.php on line 2连接错误: 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下面的是我远程mysql的信息
服务器版本: 5.5.20
Protocol version: 10
服务器: Localhost via UNIX socket
用户: *****)**@localhost
MySQL 字符集: cp1252 West European (latin1)
创建一个新的数据库:
无权限
MySQLPHP数据库服务器
if (!$db)
{
die('<br>连接错误: ' . mysql_error());
}
$sqlname="dbcmxs";//数据库的名
mysql_select_db($sqlname,$db)or die ("链接错误!! ");//连接到数据库
session_start();
mysql_query("SET NAMES 'utf8'",$db);//定义数据交互的语言格式错误信息是Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:553) in D:\workspace\php\fww\phpcms\inc\conn.php on line 2Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in D:\workspace\php\fww\phpcms\inc\conn.php on line 2Warning: mysql_connect() [function.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 D:\workspace\php\fww\phpcms\inc\conn.php on line 2连接错误: 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下面的是我远程mysql的信息
服务器版本: 5.5.20
Protocol version: 10
服务器: Localhost via UNIX socket
用户: *****)**@localhost
MySQL 字符集: cp1252 West European (latin1)
创建一个新的数据库:
无权限
MySQLPHP数据库服务器
但是我连接本地的mysql可以的哦$conn=mysql_connect("localhost", "root","admin");
$sqlname="dbstewengood";//数据库的名
mysql_select_db($sqlname,$conn)or die ("链接错误!! ");//连接到数据库
mysql_query("SET NAMES 'utf8'",$conn);//定义数据交互的语言格式这样没有问题的。怎么办?
这样呀。看来我要升级一下mysql与php的版本才行了,谢谢!