Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in

by

You are using a Unix socket. When reading “localhost” MySQL client libraries don’t interpret it as TCP host “localhost” and resolve that name but use the default Socket location. For using TCP on the local machine you have to use 127.0.0.1 as hostname.

To specify the past use unix_socketinstead of host in the DSN. The location of the socket used for localhost can be defined at compile time or in some versions of PHP using pdo_mysql.default_socket in the php.ini.

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to apply bindValue method in LIMIT clause?
  3. PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
  4. PDOException “could not find driver”
  5. Row count with PDO
  6. How to prevent duplicate usernames when people register?
  7. PDO get the last ID inserted
  8. How do I use password hashing with PDO to make my code more secure? [closed]
  9. How to view query error in PDO PHP
  10. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  11. Insert/update helper function using PDO
  12. Resetting array pointer in PDO results
  13. pdo prepared statements with wildcards
  14. PDO multiple queries
  15. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  16. Insert multiple rows with PDO prepared statements
  17. PDO::PARAM for type decimal?
  18. Update query with PDO and MySQL
  19. Is “SET CHARACTER SET utf8” necessary?
  20. Alternative for mysql_num_rows using PDO
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. Set PDO to throw exceptions by default [duplicate]
  23. PDO: MySQL server has gone away
  24. How do detect that transaction has already been started?
  25. Trying to access array offset on value of type bool
  26. return multiple response data in one response
  27. How to get a query error from prepare() in PDO PHP?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. PDO and MySQL ‘between’

Leave a Comment