• 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

    • That is typically how his products go. They start off with a photoshopped image or slapped together pre-production sample. If they get enough orders, they make them, if they don't, they cancel and send refunds. Art of the deal, lol.
    • The idea of an adversary saying "oh darn it, the keys are on a TPM chip so we can't get them" is probably too good to be true.
    • PowerToys is getting a big Dashboard redesign by Taras Buria PowerToys currently has 28 utilities to enhance your user experience (the latest addition arrived in April). You can check out the list of all modules and quickly toggle them on or off on the dedicated Dashboard page that greets you each time you open PowerToys. However, with the increasing list of tools and their vast customizability, many may feel that the Dashboard is a bit undercooked and lacks more polish and useful features. If you think so, Microsoft has some good news for you. In a new PR on PowerToys' GitHub, Microsoft engineers agree that the Dashboard needs improvements, even though it worked fine in earlier days with fewer modules. The proposed solution for the overcrowded Dashboard is a redesigned variant, which looks more similar to the Windows 11 Settings app. With the suggested variant, you get much more from Dashboard: a quick link to the latest changelog, various warnings that need your attention (like conflicting shortcuts), an update button, Quick Launcher, shortcuts for your modules, and a list of available tools. A search box for modules and settings is also there to help you find stuff that you need. Here is how Niels Laute, a software engineer working on WinUI and PowerToys, describes the proposed redesign: Since PowerToys is an open-source project, other developers are welcome to contribute their ideas. One of those ideas is implementing SplitView so that you can open each module's settings without leaving the Dashboard page. Unfortunately, there is no information on when Microsoft will ship the redesigned Dashboard. While we wait for the June 2025 update, check out these three useful plugins for PowerToys Run. What other changes would you like Microsoft to add to PowerToys? Share your thoughts in the comments.
    • But AI is not turned off completely, you can hide stuff, but AI is still there, even on Windows 10 to a lesser extent. You use different MS apps on Windows 11 and again 10 to a lesser extent and AI is there, sure you don't have to use it, but why not just give an easy option to disable all AI? Even Google does that on Android. If you don't think that the MS account is not forced, then I do wonder what you think is forced. Sorry, but it is forced, try and install Windows 10 and 11 without an MS account? You will find that you can't officially, sure there are some ways to get around to and even those are getting more difficult to use as MS decides to stop people using them. My Mac on set up ask you if you have an Apple account, but it is so easy to say, nope, I have not got one. I don't understand why the pushing for an MS account, not all of us want to use the cloud for storage and for most people that is the only advantage of having an MS account, unless you play some games. I have heard that Windows 11 still pop up about using Edge when people don't certainly on updates. I get a pop-up on my Windows 10 machine now and again saying let's finish setting up. It is set up, what they want me to do is to say what I am using the computer for. Nothing to do with them, no idea what they do if I go ahead with what ever they want me to do as I skip, but there should be a no, thanks. I don't use the search in Windows, never have, unless I am looking for files, I use Duck Duck go in my default browser, but some people do, and they should not be forced to use Bing, which in the UK is a load of poop and then if they do click on an in it should open in the default browser.. This is the sort of thing I expected from Apple, Microsoft is far worse than Apple. Context menus again, people should not have to do tweaks, it should be a simple setting.
  • Recent Achievements

    • Week One Done
      patrickft456 earned a badge
      Week One Done
    • One Month Later
      patrickft456 earned a badge
      One Month Later
    • One Month Later
      Jdoe25 earned a badge
      One Month Later
    • Explorer
      Legend20 went up a rank
      Explorer
    • One Month Later
      jezzzy earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      636
    2. 2
      ATLien_0
      275
    3. 3
      +FloatingFatMan
      171
    4. 4
      Michael Scrip
      155
    5. 5
      Steven P.
      132
  • Tell a friend

    Love Neowin? Tell a friend!