MySQLi cannot connect to db, but MySQL can

Question

Config.php :

define("DB_HOST", "127.0.0.1:1433");
define("DB_USER", "****");
define("DB_PASSWORD", "****");
define("DB_DATABASE", "name");

for some odd reason i keep on getting error:

mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host '127.0.0.1:1433' (3) in filelocation/file.php on line X

line X = $this->con = new mysqli(DB_HOST, DB_USER, DB_PASSWORD,DB_DATABASE);

the strange thing is that i also have an old mysql api running,

mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

which connects to the db without any problems whatsoever. note, that my MySQLi api was working and operational. This issue has only come to my notice since a week or two ago.

Question

Do I need to update my apache to run mySQLi again?

What version of PHP are you using? Also, have you checked in phpinfo() to see if you have mysqli? — Tricky12
– Tricky12, Commented Aug 26, 2015 at 13:15
@b0s3, yes i have. I just get the same error but then to host '12.0.0.1'. — Koen Demonie
– Koen Demonie, Commented Aug 26, 2015 at 13:16
did u try using localhost instead of the ip and the port number — Mystro
– Mystro, Commented Aug 26, 2015 at 13:20

Saty · Accepted Answer · 2015-08-26 13:18:08Z

2

You need to define your port number in separate constant

define("DB_HOST", "127.0.0.1");
define("DB_USER", "****");
define("DB_PASSWORD", "****");
define("DB_DATABASE", "name");
define("DB_PORT", 1433);

And connect your database using parameter

new mysqli(DB_HOST, DB_USER, DB_PASSWORD,DB_DATABASE,DB_PORT);

answered Aug 26, 2015 at 13:18

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

1 Comment

Koen Demonie Over a year ago

yes, that did the trick. Strange though, since it used to work... msqli update perhaps ?

mdamia · Accepted Answer · 2015-08-26 13:19:00Z

1

$mysqli = new mysqli("127.0.0.1", "user", "password", "database", "port number");

answered Aug 26, 2015 at 13:19

mdamia

4,5571 gold badge27 silver badges23 bronze badges

Collectives™ on Stack Overflow

MySQLi cannot connect to db, but MySQL can

Question

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Question

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related