Just upgrade one of my MySQL from 5.0 to 5.5 using WHM MySQL Upgrade tools. The upgrade went smooth. Right after i think everything is ok, some of my website show error while performing db query “Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]”. That website is being developed using an old symfony 1.4 framework. I can see many people are facing the same problem and there are various solution. And i found one that works for me and i’m going to show it here.
To solve: MySQL 5.5 – PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password], follow the steps below:-
Continue reading MySQL 5.5 PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] »
Just gone thru the maximum length limit for different MySQL TEXT field types. I’m designing a table to store large amount of data within a field. To avoid data being truncated automatically, it’s good to know the maximum length limit for different MySQL TEXT field types.