Contents
Why is MySQL error no such file or directory?
I have a form that that will collect form from users and save it into the database as it should, but i keep getting this error about MYSQL Error: SQLSTATE [HY000] [2002] No such file or directory. Here is my database config file and the file that includes it:
Where can I find MySQL-Adminer-SQLSTATE [ hy000 ] file name?
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 8ecd82867a06 mysql “docker-entrypoint.s…” 37 seconds ago Up 34 seconds 0.0.0.0:3306->3306/tcp, 33060/tcp mySql-wordpress ae01696e6445 adminer “entrypoint.sh docke…”
How to fix ” no such file or directory “?
The answer from @stuyam solved the “No such file or directory” issue for me Short answer: Change “host” in the /app/config/database.php file from “localhost” to “127.0.0.1” But then I had a “Connection refused” error. If anyone had the same issue, my solution for this was to update the app/config/local/database.php file so the port is 8889:
Is there no such file or directory in Adminer?
I’m not familiar with docker, but I had this same No such file or directory error with adminer when I tried to login. I fixed it by creating a custom php.ini file to tell PHP where MYSQL put its socket file. I had compiled PHP manually so I did not already have a php.ini. Check if you already have one.
What is the error message for SQLSTATE [ hy000 ]?
SQLSTATE [HY000] [1044] Access denied for user ‘username’@’localhost’ CONGRATULATION! You have the correct mysql.default_socket setting now. Fix your dbname/username/password. I had the same error using PHP 5.6.30 (macOS Sierra) with the simple PDO code like: And I received the same error message.
How to get Php-pdoexception SQLSTATE hy000 [ 2002 ]?
It will ask you for the related password. Then once you get the mysql promt type the next command:
Why is there no such file in PHP?
I encountered the [PDOException] SQLSTATE [HY000] [2002] No such file or directory error for a different reason. I had just finished building a brand new LAMP stack on Ubuntu 12.04 with Apache 2.4.7, PHP v5.5.10 and MySQL 5.6.16. I moved my sites back over and fired them up.