Home Backend Development PHP Tutorial php联接不上mysql,但Nvicat可以

php联接不上mysql,但Nvicat可以

Jun 13, 2016 pm 12:48 PM
connect mysql nbsp php

php连接不上mysql,但Nvicat可以。
$db=mysql_connect("124.172.118.122", "dbcms_f","123456");
if (!$db)
{
die('
连接错误: ' . 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 2

Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in D:\workspace\php\fww\phpcms\inc\conn.php on line 2

Warning: 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) 
 
创建一个新的数据库: 
无权限


MySQL PHP 数据库 服务器
------解决方案--------------------
警告:MYSQL_CONNECT()[function.mysql连接]:D中的数据过早结束(mysqlnd_wireprotocol.c:553):\工作区\ PHP\ INC \ conn.php\ FWW\ PHPCMS上线2

警告:MYSQL_CONNECT()[连接]:OK包1个字节少于预期在D:\工作区\ PHP\ FWW\ PHPCMS\ INC \ conn.php2号线

警告:MYSQL_CONNECT()[function.mysql连接的mysqlnd无法连接到MySQL4.1+使用旧的不安全的认证。请使用管理工具来重置您的密码命令SET PASSWORD =的密码('your_existing_password')。这将存储在mysql.user一个新的,更安全,哈希值。如果此用户使用其他脚本执行PHP5.2或更早版本,你可能需要删除旧密码标志2号线从my.cnf文件在D:\ workspace下,\ php\ FWW的\ PHPCMS\ INC\ conn.php

连接错误的mysqlnd无法连接到MySQL4.1+使用旧的不安全的认证。请使用管理工具来重置您的密码命令SET PASSWORD =的密码('your_existing_password')。这将存储在mysql.user一个新的,更安全,哈希值。如果此用户执行在其他脚本中使用PHP5.2或更早版本,你可能需要从你的my.cnf文件删除旧密码标志

是你的 php 版本太低,还是 mysql 版本太高
------解决方案--------------------
按错误信息看,应该是php所带的mysql客户端版本太低了
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1662
14
PHP Tutorial
1262
29
C# Tutorial
1235
24
MySQL and phpMyAdmin: Core Features and Functions MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

The Compatibility of IIS and PHP: A Deep Dive The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

Explain the purpose of foreign keys in MySQL. Explain the purpose of foreign keys in MySQL. Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

Compare and contrast MySQL and MariaDB. Compare and contrast MySQL and MariaDB. Apr 26, 2025 am 12:08 AM

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

How to safely store JavaScript objects containing functions and regular expressions to a database and restore? How to safely store JavaScript objects containing functions and regular expressions to a database and restore? Apr 19, 2025 pm 11:09 PM

Safely handle functions and regular expressions in JSON In front-end development, JavaScript is often required...

SQL vs. MySQL: Clarifying the Relationship Between the Two SQL vs. MySQL: Clarifying the Relationship Between the Two Apr 24, 2025 am 12:02 AM

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

What happens if session_start() is called multiple times? What happens if session_start() is called multiple times? Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

How does MySQL differ from Oracle? How does MySQL differ from Oracle? Apr 22, 2025 pm 05:57 PM

MySQL is suitable for rapid development and small and medium-sized applications, while Oracle is suitable for large enterprises and high availability needs. 1) MySQL is open source and easy to use, suitable for web applications and small and medium-sized enterprises. 2) Oracle is powerful and suitable for large enterprises and government agencies. 3) MySQL supports a variety of storage engines, and Oracle provides rich enterprise-level functions.

See all articles