• 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

    • Clear Linux is open source, indeed, so its source code is available for anyone. They're just shutting down its support from them, they're not forbidding anyone else from taking over.
    • Linux Mint is also my favorite distro, but I fear what will happen with it if Clem were to disappear tomorrow, to be honest.
    • Yeah, I totally get your point, which is possible it could happen. I just hope there is a few people around him who are similar to where if they took over things would run pretty much the same. if not, then yeah, it could start to decline rapidly etc. but I figure something that's been around for a longer period of time with a decent backing, and probably more users than most Linux distro's (which I would 'imagine' Mint is one of the more used Linux desktop distro's by volume of people who use it), is less likely to just disappear. but like you said, nothing is guaranteed. but I do think you are probably right in that Clem is probably the core of what keeps Mint, Mint. I like how it tends to stay pretty much the same with some slight tweaks here and there (but is largely the same) instead of that crap some people go for with change for the sake of change trying to create a overly fancy interface and other unnecessary stuff etc. I also feel Mint keeps a nice balance of things out-of-the-box where it's not too bloated, nor too striped down. p.s. but I see Mint as a better Ubuntu basically. but I get your point like if it was more of a really serious choice of needing a 'safe bet' to use long term, then yeah something like official Ubuntu would be one of the better choices for sure given what you said with it being backed by an actual company which makes it a safer bet than Mint which is smaller and 'could' potentially be more fragile.
    • It’s in development so hopefully it’s improved upon before release.
    • For the 10th iteration they could have bothered with some design changes rather than just carrying over the 9's
  • Recent Achievements

    • First Post
      leoniDAM earned a badge
      First Post
    • Reacting Well
      Ian_ earned a badge
      Reacting Well
    • One Month Later
      Ian_ earned a badge
      One Month Later
    • Dedicated
      MacDaddyAz earned a badge
      Dedicated
    • Explorer
      cekicen went up a rank
      Explorer
  • Popular Contributors

    1. 1
      +primortal
      506
    2. 2
      ATLien_0
      209
    3. 3
      Michael Scrip
      202
    4. 4
      Xenon
      146
    5. 5
      +FloatingFatMan
      121
  • Tell a friend

    Love Neowin? Tell a friend!