php - mysql database connection

Question

I'm trying to connect to my database to retrieve the table from sql workbench, but when I do it comes up with the following error message

could not connect to MySQL Unknown MySQL server host "Guada"

The php script is as follows:

<?php

//Using details to establish database connection
DEFINE ('DB_USER', 'i7421760');
DEFINE ('DB PASSWORD', '*********');
DEFINE ('DB_HOST', 'guada');
DEFINE ('DB_NAME', 'i7421760');




$dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
OR die('could not connect to MySQL ' .
        mysqli_connect_error());
/*
If the connection couldn't be established it 
will print a display message and the error report
*/
?>

If it is the case of just getting the host name wrong, where can I find it? The table I want to retrieve is on sql workbench.

Any help is appreciated thanks in advance

NOTE: SQL Workbench is a tool used to simplify MYSQL database management not a database MYSQL is the DBMS — RiggsFolly
– RiggsFolly, Commented Dec 10, 2016 at 12:38
So, you got Unknown MySQL server host "Guada"' - why do you think that is? — N.B.
– N.B., Commented Dec 10, 2016 at 12:38

Gulshan S · Accepted Answer · 2016-12-10 12:38:47Z

1

Update your code:

//Using details to establish database connection
DEFINE ('DB_USER', 'i7421760');
DEFINE ('DB PASSWORD', '*********');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'i7421760');




$dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
OR die('could not connect to MySQL ' .
        mysqli_connect_error());
/*
If the connection couldn't be established it 
will print a display message and the error report

answered Dec 10, 2016 at 12:38

Gulshan S

1,1142 gold badges9 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nealington Over a year ago

When I change the host to local host, I get the following error message: could not connect to MySQL Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Gulshan S Over a year ago

Please check this stackoverflow.com/questions/4448467/…

O. Jones · Accepted Answer · 2016-12-10 13:02:46Z

0

Is it possible your php and MySQL both run on a hosting service somewhere?

Many hosting services configure their internal networks so MySQL can be reached from php running on their internal servers, but not directly from customers' machines outside the hosting service networks. If you must access your MySQL directly from your home or office, ask your hosting service tech support for help.

But keep in mind that you're running a security risk by opening up your MySQL database to access by the broader internet.

answered Dec 10, 2016 at 13:02

community wiki

O. Jones

1 Comment

Nealington Over a year ago

Yeah the host is elsewhere, I'm using my home laptop so that could be the problem there. I'll get in touch with the host to try resolve the issue. Thank you

Collectives™ on Stack Overflow

php - mysql database connection

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related