• 0

from MySQL, MySQLi or PDO and mysqli::$connect_error - the script for errors in the db-connection


Question

hello dear experts -. 

 

good day @all - my name is tarifa - i am pretty new to this forum. 

 

 

well today i need your help in a wordpress issue. 

i thought that during the installation process the file wp-config-sample.php gets to wp-config.php - but this is not happening.  - i have gathered some more infos and inights due to some tests. see the following data: - the outcome of a testscript: 

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /sites/www.mysite.de/tests.php on line 3
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /sites/www.mysite.de/tests.php on line 4
could not connect

see the script; 

 

<?php
if(function_exists('mysqli_connect')){
if(!($link = mysqli_connect('localhost','user','passwd','my_db'))){
die('could not connect: ' . mysqli_error($link));
}
} else {
die("don't have mysqli");
}
echo 'connect successfully';
mysqli_close($link);


on the webmin-frontend (that is the area i have to controll and configure all the stuff on the server')

1 USE yourdatabase;
2 SHOW GLOBAL VARIABLES LIKE 'PORT';
3 SHOW GRANTS FOR CURRENT_USER;


i get back the following results: 

check the manual that corresponds to your MySQL server version for the right syntax to use near ''name of my db';
SHOW GLOBAL VARIABLES LIKE 'PORT'; SHOW GRANTS FOR CURRENT_USER' at line 1

and the following

Failed to execute SQL : SQL USE 'name of my db'; SHOW GLOBAL VARIABLES LIKE 'PORT';
SHOW GRANTS FOR CURRENT_USER; failed : You have an error in your SQL syntax;

 

 

well - i am a bit unsure what i can do now.  

 

well - since there is no connection_error property in mysqli. i think that i have to check connection error using 

 

if ($conn->connect_error) {
    die('Connect Error: ' . $conn->connect_error);
}

well i have to read the manpages here http://php.net/manual/en/mysqli.connect-error.php in order to learn what i need to get more insights., 


btw:  I have Linux Server. Apache 2.4.10, PHP Version 5.6.39 and mysqlnd 5.0.11-dev - 20120503 - installed. There are several wordpress website running on server.

do i have MySQL or MySQLi  - i am not sure. 

 

what would you do now!?


by the way: just another question.... regarding the  different systems in DB-terms:  we have got different systems that are available generally... 

MySQL - MySQLI and PDO . if we compare the different systems then we can say. 

 

a. The now extinct mysql library and the mysqli library are two completely different animals.
b.   we may forget about mysqli - since PDO is much much better - so we should probably make use of PDO.

 

see the three systems in a ASCII - Comparison..:

+---------+-------------+
|  mysql  |  dodo       |
|  mysqli |  donkey     |
|  PDO    |  racehorse  |



what do you suggest - should i ask my serveradmin that he will update & upgrade the whole system - in order to have a modern system... And then i run the mysqli_error_(function)

Love to hear from you

regards Tarifa

 

 

6 answers to this question

Recommended Posts

  • 0

Are you sure you set up the MySQL use to beable to access the database via localhost?

 

Try using the following code to connect to the DB

 

<?php
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');

/*
 * This is the "official" OO way to do it,
 * BUT $connect_error was broken until PHP 5.2.9 and 5.3.0.
 */
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

$mysqli->close();

 

  • 0
  On 20/06/2019 at 13:40, Matthew S. said:

Are you sure you set up the MySQL use to beable to access the database via localhost?

 

Try using the following code to connect to the DB

 

<?php
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');

/*
 * This is the "official" OO way to do it,
 * BUT $connect_error was broken until PHP 5.2.9 and 5.3.0.
 */
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

$mysqli->close();

 

Expand  

 

got back this  result ... 

 

Parse error: syntax error, unexpected end of file in /sites/www.mysite.de/new_test.php on line 13

  • 0

and besides the php-configuration 

 

if i use code with a closing tag -  like so... .

 

 

<?php
$mysqli = new mysqli('localhost', 'jo', 'susi19', 'jo');

/*
 * This is the "official" OO way to do it,
 * BUT $connect_error was broken until PHP 5.2.9 and 5.3.0.
 */
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error)
}

$mysqli->close();

?>

 

then i get back 

 

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /sites/www.my_page.org/new_test.php on line 2
Connect Error (2002) No such file or directory

 

still wonder what is going on here . and what i can do and test now

  • 0

Try using 127.0.0.1 instead of localhost as the server name.

 

Are you sure that there are no firewalls in between the MySQL process and the network stack?

 

If it isn't that, have a look at editing mysqli.default_socket in php.ini and check that the path is correct.

  • 0

Hello dear C;Amie

 

many many thanks for the  quick reply. Thats great to hear from you. 


 

  Quote

 

Try using 127.0.0.1 instead of localhost as the server name.

 

 

 

Expand  

 

that i will do right now...

 

  Quote

 

Are you sure that there are no firewalls in between the MySQL process and the network stack?

 

 

 

Expand  

 

well i am not 100 % sure . i have to re check all this settings. 

 


 

  Quote

 

If it isn't that, have a look at editing mysqli.default_socket in php.ini and check that the path is correct.

 

 

 

Expand  

 

i will talk to my serveradmin - (a friend of me) and i will surely discuss all these ideas. 

 

dear C;Amie - i am very very glad to hear from you - i am so glad. This annoying  error is still keeping me worrying one whole week now.  - i need to get this fixed. 

 

Dear C;Amie many many thanks for your hints.  I am trying to figure out what has happened. 

By the way: see even more -  i have runned several code examples - also this one....:

<?php
$mysqli = new mysqli("localhost", "db-user", "passwd", "db-name");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if (!$mysqli->query("SET a=1")) {
    printf("Errormessage: %s\n", $mysqli->error);
}

/* close connection */
$mysqli->close();
?>

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /sites/www.job-starter.de/tt.php on line 2
Connect failed: No such file or directory


well this is really funny... 

 

now i am trying to follow all your hints of the previous post - CTAmie i am glad that you want to help me..

 

regards tarifa

Edited by tarifa
  • 0

 

hello dear 😄 Amie and dear 'Matthew, 

 

first of all - many many thanks for the quick reply - i have tried out several things so far.. 

 

 

 

some first statements: 

i am on
PHP Version 5.6.39
btw: I have Linux Server - based on opensuse: 
Apache 2.4.10, PHP Version 5.6.39 and mysqlnd 5.0.11-dev - 20120503 
the newest version of Webadmin - Webmin 1.910 see http://www.webmin.com/


i have testesd varios versions of the mysqli.connect-error-scripts... see the results: ave tr


https://www.php.net/manual/en/mysqli.connect-error.php

mysqli::$connect_error
mysqli_connect_error
(PHP 5, PHP 7)

Example #1 $mysqli->connect_error example

Object oriented style

 

	<?php
$mysqli = @new mysqli('localhost', 'fake_user', 'my_password', 'my_db');
	// Works as of PHP 5.2.9 and 5.3.0.
if ($mysqli->connect_error) {
    die('Connect Error: ' . $mysqli->connect_error);
}
?>
	

 

 

i also runned the prozedural-style 

 

<?php
$link = @mysqli_connect('localhost', 'fake_user', 'my_password', 'my_db');
	if (!$link) {
    die('Connect Error: ' . mysqli_connect_error());
}
?>
	

 


and got back the following:

 

Connect Error: No such file or directory 

 

 

note: i also runned this with the adviced replacement of localhost with 127.0.0.1  ... see below: 

 

	<?php
$link = @mysqli_connect(''127.0.0.1'', 'user', 'db-passwd', 'db-name');
	if (!$link) {
    die('Connect Error: ' . mysqli_connect_error());
}
?>
	

 

 

and i got back here: 

 

Connect Error: No such file or directory 

 


...and here we have more insights  - i also runned the PDO-version: 

see: https://www.w3schools.com/php/php_mysql_connect.asp

 

	<?php
$servername = "localhost";
$username = "username";
$password = "password";
	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();
    }
?>
	

 

see what i have got back:

 

	Connection failed: SQLSTATE[HY000] [2002] No such file or directory
	

 

Note: In the PDO example above we have also specified a database (myDB). PDO require a valid database to connect to. If no database is specified, an exception is thrown.
Tip: A great benefit of PDO is that it has an exception class to handle any problems that may occur in our database queries. If an exception is thrown within the try{ } block, the script stops executing and flows directly to the first catch(){ } block. cf. https://www.w3schools.com/php/php_mysql_connect.asp

conclusio: all attemts to set up a mysql-db that is accessible from a Wordpress-installation failed.

some more ideas that i need to think about. 

i should do some more tests and i will try to change "localhost" to "127.0.0.1
see https://www.fatalerrors.org/a/warning-mysqli-mysqli-hy000-2002-no-such-file-or-directory.html

i further have to test  PDO it is told to be much easier to deal with than MySQLi.

what i need to do:

a. i also have tried the changing "localhost" to "127.0.0.1"
b. i have no experience with PDO but i will dig deeper into all that. I am going to read the docs.  But see - i allready have done a first test with PDO 

 

above all: well - this is so crazy and i think that there some kind of magic things are happening.

i have to do some more checks:
- is there probably some firewalls in between the MySQL process and the network-stack and if it isn't that,
- i might have a closer look at the editing of mysqli.default_socket in php.ini and i need to check that the path is set correct.

and report all the findings. 

 

What can i do now!? 

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • It's significant growth for Linux considering the market share, so it could have had that effect I described.
    • Microsoft and Crowdstrike announce partnership on threat actor naming by Pradeep Viswanathan Whenever a cyberattack is discovered, companies disclose it to the public and assign it a unique name based on their internal procedures. Unfortunately, this leads to inconsistencies, as each company has its own naming conventions. As a result, the same threat actor behind a cyberattack may end up with multiple names, causing delays and confusion in response efforts. For example, a threat actor that Microsoft refers to as Midnight Blizzard might be known as Cozy Bear, APT29, or UNC2452 by other security vendors. To address this issue, Microsoft and CrowdStrike are teaming up. These companies will align their individual threat actor taxonomies to help security professionals respond to cyberattacks with greater clarity and confidence. It’s important to note that Microsoft and CrowdStrike are not attempting to create a single naming standard. Instead, they are releasing a mapping that lists common threat actors tracked by both companies, matched according to their respective taxonomies. The mapping also includes corresponding aliases from each group’s naming system. You can view the joint threat actor mapping by Microsoft and CrowdStrike here. Although this threat actor taxonomy mapping is a joint effort between Microsoft and CrowdStrike, Google/Mandiant and Palo Alto Networks' Unit 42 are expected to contribute to this initiative in the future. Vasu Jakkal, Corporate Vice President of Microsoft Security, wrote the following about this collaboration with CrowdStrike: As more organizations join this initiative, the collective defense against cyber threats will undoubtedly be improved.
    • You make no sense since most of the stuff on YouTube is free to begin with. Comparing Netflix to YouTube is not even remotely the same. YouTube has tons of free videos to begin with, unlike Netflix, you are paying Netflix for original style of programming.
    • Youtube can go screw themselves. Never ever, ever will I pay for this BS nonsense. And I encourage anyone else not to either.
  • Recent Achievements

    • First Post
      chriskinney317 earned a badge
      First Post
    • Week One Done
      Nullun earned a badge
      Week One Done
    • First Post
      sultangris earned a badge
      First Post
    • Reacting Well
      sultangris earned a badge
      Reacting Well
    • First Post
      ClarkB earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      172
    2. 2
      ATLien_0
      125
    3. 3
      snowy owl
      122
    4. 4
      Xenon
      116
    5. 5
      +Edouard
      93
  • Tell a friend

    Love Neowin? Tell a friend!