B
buddychrist
Guest
Hello.
I am trying to upgrade PHP to 5.3 version. Everything is ok except i get errors with mysql authentication:
Cannot connect to MySQL 4.1+ using old authentication
I know it is related to the way PLESK stores database passwords on a table with char(16). I have altered the table to varchar(41) and used "Set old_passwords=0;" followed by "Update db_user set passwd=PASSWORD('desiredpassword') where login='targetuser';" to update passwords schema.
I also modified "my.ini" files disabling "old_passwords" tag and restarted MySQL and Web Services.
No way. Despite all efforts i am still getting MySQL 4.1+ using old authentication errors and plesk keep storing passwords with old schema.
Please. I want to use PHP 5.3 cause seriously improves PHP performance on Windows but get stack at this point.
Anybody could help me?
Thanks a lot!!
Ivan
I am trying to upgrade PHP to 5.3 version. Everything is ok except i get errors with mysql authentication:
Cannot connect to MySQL 4.1+ using old authentication
I know it is related to the way PLESK stores database passwords on a table with char(16). I have altered the table to varchar(41) and used "Set old_passwords=0;" followed by "Update db_user set passwd=PASSWORD('desiredpassword') where login='targetuser';" to update passwords schema.
I also modified "my.ini" files disabling "old_passwords" tag and restarted MySQL and Web Services.
No way. Despite all efforts i am still getting MySQL 4.1+ using old authentication errors and plesk keep storing passwords with old schema.
Please. I want to use PHP 5.3 cause seriously improves PHP performance on Windows but get stack at this point.
Anybody could help me?
Thanks a lot!!
Ivan