Announcement

shotman

Member

Registered: 2013-12-08

Posts: 3

Installation step 2 Error

Cannot login with provided logins. Returned message:
SQLSTATE[HY000] [2000] 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
What can i do?

https://groups.google.com/forum/#!topic … _lQ3L0HCuA

Remigijus Kiminas

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Installation step 2 Error

As written in error. In general I recommend update your mysql.

2013/12/8 shotman <purch...***.com>

Cannot login with provided logins. Returned message:
SQLSTATE[HY000] [2000] 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

What can i do?

shotman

Member

Registered: 2013-12-08

Posts: 3

Re: Installation step 2 Error

Here are my server specs, is it possible to do something in livehelper soft to make it compatible with old authentication?

Apache version2.2.26PHP version5.4.22MySQL version5.1.70-cllArchitecturex86_64Operating systemlinux

Remigijus Kiminas

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Installation step 2 Error

Just try to execute in your phpmyadmin tool.SET PASSWORD = PASSWORD('your_existing_password')
Of course just change your_existing_password to real password

shotman

Member

Registered: 2013-12-08

Posts: 3

Re: Installation step 2 Error

ok i have fixed it... i used these commands: couse using just set password doesnt make any difference i found it here also
http://stackoverflow.com/questions/1575807/cannot-connect-to-mysql-4-1-using-old-authentication

... thank you so much!!!
SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD('[your password]');