mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)

by

When you use just “localhost” the MySQL client library tries to use a Unix domain socket for the connection instead of a TCP/IP connection. The error is telling you that the socket, called MySQL, cannot be used to make the connection, probably because it does not exist (error number 2).

From the MySQL Documentation:

On Unix, MySQL programs treat the host name localhost specially, in a
way that is likely different from what you expect compared to other
network-based programs. For connections to localhost, MySQL programs
attempt to connect to the local server by using a Unix socket file.
This occurs even if a –port or -P option is given to specify a port
number. To ensure that the client makes a TCP/IP connection to the
local server, use –host or -h to specify a host name value of
127.0.0.1, or the IP address or name of the local server. You can also specify the connection protocol explicitly, even for localhost, by
using the –protocol=TCP option.

There are a few ways to solve this problem.

  1. You can just use TCP/IP instead of the Unix socket. You would do this by using 127.0.0.1 instead of localhost when you connect. The Unix socket might by faster and safer to use, though.
  2. You can change the socket in php.ini: open the MySQL configuration file my.cnf to find where MySQL creates the socket, and set PHP’s mysqli.default_socket to that path. On my system it’s /var/run/mysqld/mysqld.sock.

  3. Configure the socket directly in the PHP script when opening the connection. For example:

    $db = new MySQLi('localhost', 'kamil', '***', '', 0, 
                              '/var/run/mysqld/mysqld.sock')

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to change mysql to mysqli?
  3. How to prevent duplicate usernames when people register?
  4. Best way to INSERT many values in mysqli?
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. What is the difference between MySQL, MySQLi and PDO? [closed]
  13. Do I have to guard against SQL injection if I used a dropdown?
  14. Using MySQLi from another class in PHP
  15. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  16. Call to a member function execute() on boolean in [duplicate]
  17. Mysql No connection could be made because the target machine actively refused it
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. Fatal error: Call to undefined function mysqli_result()
  22. Using PHP to execute multiple MYSQL Queries
  23. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  24. How to run multiple insert query in SQL using PHP in one go?
  25. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. When should I close a database connection in PHP?
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. How to make mysqli connect function?

Leave a Comment