Add database getting error SQLSTATE[HY000] [2002] No such file or directory

Question

I tried to install Magento using XAMPP for Linux (I use 32-bit Ubuntu), I've created a database, and when you want to add via Magento Installer I get an error message like this:

Picture

I've tried a variety of ways, but it does not work, is there a solution?

• Jackson: Make sure ur Host is correct
• Febriyanto Nugroho: @AnkitShah When I try to change the host febri , I get the following error like SQLSTATE[HY000] [2002] Connection refused
• Manthan Dave: @FebriyantoNugroho replace localhost to 127.0.0.1 and then check
• Khoa Truong: Possible duplicate of PDO Exception error on index
• Febriyanto Nugroho: @ManthanDave Error result I have SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

Answer 1

Try to replace localhost to 127.0.0.1 and check

This is commonly caused by a different instance of PHP being used by the PHP command line compared to the web server. In particular, mysql.sock might be misconfigured.

Refer this magento devdocs link http://devdocs.magento.com/guides/v2.0/install-gde/trouble/php/tshoot_phpini.html

You can also refer - PDO Exception error on index

It will works

• Febriyanto Nugroho: Do I have to add value to the pdo_mysql.default_socket ?
• Manthan Dave: @FebriyantoNugroho after chaning localhost to 127.0.0.1 now you have access denied error right ? please confirm ?
• Febriyanto Nugroho: Yes sir, of course
• Manthan Dave: @FebriyantoNugroho so now your first issue is solved , you just need to pass correct password . Check your database password with privillages and enter that password in the password field. it will works
• Febriyanto Nugroho: I'll try it later

Answer 2

In your terminal run below command and look for MYSQL_SERVICE_PORT_33060_TCP_ADDR. You can use for your database server host.

php -i

enter image description here