0

After asking last question about $id=$_GET['id']; and security issues I tried a PDO connection to my server. The following message appeared; ERROR: could not find driver.

I connected to phpMyAdmin - 2.11.1.2 and had this message appear; Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.61. This may cause unpredictable behavior.

Is there a connection? Are PDO drivers required on the server? Would MySqli work?

Bob

1
  • You will need to enable the php_pdo_mysql module in your php.ini file.
    – Krister Andersson
    Commented Jul 24, 2013 at 2:18

1 Answer 1

1

There is a connection otherwise phpmyadmin wouldnt know what version the server is.

In most cases you can ignore that as only slight differences exist (for a full difference check the changelogs between the versions)

apt-get install php5-mysql

yum install php5-mysql

one of those should update your php library and not show that warning

6
  • OK.. Thank you...I have no control over this. I would have to ask the web_server people to do the upgrade and unless I have a real good reason they would not. So the question is will PDO and or MySqli work on this server or am I stuck with deprecated old code?
    – Bobby
    Commented Jul 23, 2013 at 19:58
  • its not that old, There are newer versions yes, but not "old" pdo and mysqli will work though
    – exussum
    Commented Jul 23, 2013 at 19:59
  • MySQL 5.5 was released in 2009 and obsoleted MySQL 5.1 which was released in 2005. The machine you're on is as much a museum if it still has a 5.0 install on it.
    – tadman
    Commented Jul 23, 2013 at 20:20
  • @tadman - tahst his php version. The MySQL version is still current on debian squeeze
    – exussum
    Commented Jul 23, 2013 at 20:25
  • @user1281385 If Debian is shipping with MySQL 5.1 then it's in sad shape. MySQL 5.5 is significantly faster.
    – tadman
    Commented Jul 23, 2013 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.