format
← Older revision
Revision as of 13:13, 31 August 2013
Line 3:
Line 3:
My Sofeware details:
My Sofeware details:
−
OS - linux 2.6.18
+
* OS - linux 2.6.18
−
Apache - http2.2.3-31
+
* Apache - http2.2.3-31
−
php - 5.5.3
+
* php - 5.5.3
−
mysql - 5.0.77
+
* mysql - 5.0.77
The error prompted:
The error prompted:
−
Database host:192.168.2.102
+
* Database host:192.168.2.102
−
Database: wikidatabase
+
* Database: wikidatabase
−
DBUser:root
+
* DBUser:root
−
DBPassword: ***
+
* DBPassword: ***
−
DB connection error: Permission denied (192.168.2.102)。
+
* DB connection error: Permission denied (192.168.2.102)。
Or
Or
−
Database host:localhost
+
* Database host:localhost
−
Database: wikidatabase
+
* Database: wikidatabase
−
DBUser:root
+
* DBUser:root
−
DBPassword: ***
+
* DBPassword: ***
−
DB connection error: DB connection error: 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 (localhost)。
+
* DB connection error: DB connection error: 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 (localhost)。
I must carify that i can oper mysql in the local server, and port 3306 was opened.
I must carify that i can oper mysql in the local server, and port 3306 was opened.