[RESOLVED] MYSQL Setting

[oceanebelle]

What setting or steps needs to be done such that the
LOCALHOST value for the DBHost in MYSQL will be disabled? (That is, those connecting, like PHP, should use the actual HOST IP Address)

sorry this is a settings problem and since MYsql is almost always coupled with PHP i thought i should raise this one here.

Help will be much appreciated.

[penagate]

For MySQL, you need to add the --skip-name-resolve option either to the command line parameters of the MySQL service or in my.ini.

I am not sure if this disables name resolution from the PHP MySQL connector though.

Seems a strange issue?

[CornedBee]

Shouldn't the mysql extension never resolve localhost in the first place but use it as the trigger to access the Unix domain socket?

What do you actually want to achieve, and perhaps more importantly in this case, why do you want to achieve it?

[oceanebelle]

I am not particularly knowledgeable in this subject... but just last week, we connected to mysql using localhost then a few days ago it was not able to connect anymore. i just want to know what settings used ( i guess like pg mentioned ) in the my.ini.

so for connecting to localhost the ip address must be specified.

[CornedBee]

Perhaps the mysql server was completely down?