hello and good eveing dear Autotutorial
mmm – this allmost is a issue for more than 2 Weeks now! I guess that you are right. This seems to be an issue that is rooted in some configs…
first of all many many thanks to you dear Autotutorial – you are just great and you do a superb job here on the wordpress-site: I am overwhelmed by your continued help and support. Dear Autotutorial – a big big sorry – for the bit of confusing thread-posting with the issues. I am in need of help and i try to sort out things here.
again: this error is quite very hard to fix .? i re-checked some tests and the behavior of the server while running the following scripts?
define("HOST",'localhost');
define("USERNAME",'jc');
define("PASSWORD",'my_passwd');
? ? $db = new PDO("mysql:host=".HOST,USERNAME,PASSWORD);
? ? $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
? ? $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
? ? $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$res = $db->query("SELECT 7 * 6 ");
echo $res ->fetchColumn(); ? ? ? ? ?//--> 42
…throws back the following:?
define("HOST",'localhost'); define("USERNAME",'jc'); define("PASSWORD",'my_secret_passwd'); $db = new PDO("mysql:host=".HOST,USERNAME,PASSWORD);?
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);?
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);?
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);?
$res = $db->query("SELECT 7 * 6 ");?
echo $res ->fetchColumn(); //--> 42
and the following script?
<?php
$servername = "localhost";
$username = "jc";
$password = "my_passwd";
try {
? ? $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
? ? // set the PDO error mode to exception
? ? $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
? ? echo "Connected successfully";?
? ? }
catch(PDOException $e)
? ? {
? ? echo "Connection failed: " . $e->getMessage();
? ? }
?>
…throws back the following:
Connection failed: SQLSTATE[HY000] [2002] No such file or directory
?
I spend some time in trying to find out what goes wrong here: – see what i have? found out: ….?
?Connection failed: SQLSTATE[HY000] [2002] No such file or directory ….. what means according this hread: /strong>??https://stackoverflow.com/questions/29695450/pdoexception-sqlstatehy000-2002-no-such-file-or-directory
Quick test (run in shell):
php -r "new PDO('mysql:hostname=localhost;dbname=test', 'username', 'password');"
?
?see the following: `
SQLSTATE[HY000] [2002] No such file or directory means php cannot find the mysql.default_socket file. Fix it by modifying php.ini file. On Mac it is mysql.default_socket = /tmp/mysql.sock (See PHP – MySQL connection not working: 2002 No such file or directory)? SQLSTATE[HY000] [1044] Access denied for user ‘username’@’localhost’ CONGRATULATION! You have the correct mysql.default_socket setting now. Fix your dbname/username/password. `
Also see Error on creating connection to PDO in PHP ( cf: https://stackoverflow.com/questions/1435445/error-on-creating-connection-to-pdo-in-php )
Today, I removed and reinstalled the latest version of lampp in order to move to php 5.30, and suddenly a very simple app?is failing to connect to the mysql database. I’m using PDO to connect, and receiving the following error:
?Warning: PDO::__construct() [pdo.--construct]: [2002] Invalid argument (trying to connect?via unix://) in /home/raistlin/www/todoapp/home.php on line 9 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002]
[.. and so forth and so forth..]?
….. see some answers that i have found for the cumbersome issues:?
answer1:
Usually means that you need to specify TCP/IP (1), or tell MySQL where your Unix socket is (2):
"mysql:host=127.0.0.1" or "mysql:host=localhost;port=3306"
"mysql:unix_socket=/var/run/mysqld/mysqld.sock"
answer2: ?
You can also use 127.0.0.1, rather than specifying “localhost”, in your db connection string to avoid this issue altogether.
answer3:
You might want to modify php.ini so PDO can find mysql.sock by specifying the pdo_mysql.default_socket = /opt/lampp/var/mysql/mysql.sock (in the case of xampp). Don’t forget to restart Apache after changing php.ini.
cf: https://stackoverflow.com/questions/1435445/error-on-creating-connection-to-pdo-in-php
well i think i have some issues on my server…?
dear Autoturorial – i think that you are 100 right – and that you show into the right direction – i guess that it is time to discuss all that with the serveradmin – since he is the guy that can change the configs…
