Removing the error-supressing from mysql_connect it will show the following, hopefully helpful message:
Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:553) in /var/www/froxlor/lib/classes/database/class.db.php on line 105
Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in /var/www/froxlor/lib/classes/database/class.db.php on line 105
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
I hope this will save some of you from getting a heart-attack
Question
d00p
For seeing this quite often these days, here's how to fix it (most of the times).
You get an error like
Checking the syslog, you might find something similar to this:
Removing the error-supressing from mysql_connect it will show the following, hopefully helpful message:
Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:553) in /var/www/froxlor/lib/classes/database/class.db.php on line 105
Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in /var/www/froxlor/lib/classes/database/class.db.php on line 105
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
I hope this will save some of you from getting a heart-attack
d00p
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.