Posts under MySQL Database

MySQL 5.5 PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]

advertisement

mysql-poweredJust 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] »

phpmyadmin disable 1440 timeout with auto login

advertisement

I’m running phpmyadmin in my dev server and i always encounter phpmyadmin timeout after 1440 seconds.

To disable the phpmyadmin timeout after 1440 seconds, follow the steps below:-

Continue reading phpmyadmin disable 1440 timeout with auto login »

Maximum length for MySQL TEXT field types

advertisement

mysqlJust 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.

Here’s the summary for maximum length limit for different MySQL TEXT field types:

Continue reading Maximum length for MySQL TEXT field types »