Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’ with pdo

by

I just had the same error (with PHP 5.2.6), and all I had to do is enable the MySQL-specific PDO driver:

TL;DR

In your php.ini file, you should have the following line (uncommented):

  • extension=php_pdo_mysql.dll on Windows
  • extension=php_pdo_mysql.so on Linux/Mac

Longer explanation:

  1. open php.ini in a text editor

    • e.g. its default path on Windows: C:\Program Files (x86)\PHP\v5.X\php.ini (substitute v5.x with the version you installed) or C:\Windows\php.ini, etc.
    • or on Linux: /etc/php5/apache2/php.ini (e.g. this is the path on Ubuntu) or /etc/php5/cli/php.ini, /etc/php5/cgi/php.ini, etc.
    • or you can get to know where it is like this:
      • php --ini | find /i "Loaded" in Windows command prompt OR
      • php --ini | grep "Loaded" in Linux/Mac terminal
      • using phpinfo(), and looking for the line “Loaded Configuration File”

  2. and remove the semicolon from the beginning of the following line (to uncomment it):

    • ;extension=php_pdo_mysql.dll on Windows
      • OR ;extension=php_pdo_mysql.so on Linux/Mac
    • of course, if this line doesn’t exist, you should paste it
    • so as a result the expected line would look like this in php.ini:
      • extension=php_pdo_mysql.dll on Windows
      • OR extension=php_pdo_mysql.so on Linux/Mac

  3. You may need to restart your web server.

That solved my problem.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. How to properly set up a PDO connection
  3. PHP PDO prepared statements
  4. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  5. PDO Prepared Inserts multiple rows in single query
  6. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  7. mysql PDO how to bind LIKE
  8. Connect PHP to MSSQL via PDO ODBC
  9. PDO closing connection
  10. How to get the total number of rows of a GROUP BY query?
  11. How do I use pdo’s prepared statement for order by and limit clauses?
  12. How to install pdo driver in php docker image?
  13. MySQL retrieve variable from Stored Procedure in PHP PDO
  14. PDO try-catch usage in functions
  15. How do I enable php to work with postgresql?
  16. Call to a member function fetch() on boolean [duplicate]
  17. How to prevent PDO from interpreting a question mark as a placeholder?
  18. PHP PDO returning single row
  19. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  20. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  21. How to handle PDO exceptions [duplicate]
  22. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  23. Get Last Executed Query in PHP PDO
  24. PDO and MySQL Fulltext searches
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. escaping column name with PDO
  27. prepared parameterized query with PDO
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment