Hi.
I have a number of sites still using mysql_* functions and I am trying to convert them all to PDO.
My code works OK on XAMPP version 3.2.1 but when I try to link to my actual online database I get the following error (2054) The server requested authentication method unknown to the client.
I can connect to the database using mysql_connect etc. but I want to bring the code up to date.
PHP and MYSQL is controlled by my host and are versions 5.4.27 (php) and 5.5.36-cll (mysql).
I understand that this is probably due to the MYSQL password length but I can’t change that in MYSQL without stopping my other sites from working and I can’t upgrade them all at once. Is there a way to control this from within PHP, or can you suggest something to help me please?