A question for Mr. Rao

[Armando]

Mr Rao:

Why this code does not work (There is not conection)

Code: Select all  Expand view

FWCONNECT oCn HOST "localhost" USER "root" PASSWORD "secret" DB "AppSap"
 

But this one yes (There is conection)

Code: Select all  Expand view

FWCONNECT oCn HOST "192.178.100.3" USER "root" PASSWORD "secret" DB "AppSap"
 

The only diference is the host name.

Regards

[joseluisysturiz]

Mr Rao:

Why this code does not work (There is not conection)

Code: Select all  Expand view

FWCONNECT oCn HOST "localhost" USER "root" PASSWORD "secret" DB "AppSap"
 

But this one yes (There is conection)

Code: Select all  Expand view

FWCONNECT oCn HOST "192.178.100.3" USER "root" PASSWORD "secret" DB "AppSap"
 

The only diference is the host name.

Regards

Armando no soy Mr.Rao, pero para localhost prueba con 127.0.0.1, saludos, gracias...

[Armando]

José Luis:

También funciona, muchas gracias.

Solo queda la incógnita, por que con localhost no?

Saludos

[anserkk]

José Luis:

También funciona, muchas gracias.

Solo queda la incógnita, por que con localhost no?

Saludos

Check your hosts file in the path \Windows\system32\drivers\etc

[Armando]

anserkk:

Thanks for your answer.

I made the change as follow but there is no way.

Code: Select all  Expand view

# localhost name resolution is handled within DNS itself.
    127.0.0.1       localhost
#   ::1             localhost
 

Regards

[anserkk]

You said that it is working fine if you try 127.0.0.1 instead of localhost, right ?

Can I get the exact error message that you get when you try to connect to localhost ?

There are few possibilities for this issue, based on the error we shall try to identify the problem

[Armando]

anserkk:

You said that it is working fine if you try 127.0.0.1 instead of localhost, right ?
Yes that's right.

The message is

2003
Can't connect to MySQL server on 'localhost' (10061)

Thanks for your help

Regards

[anserkk]

What is the value of the entry
bind-address
in my.cnf (in case your OS is linux) or my.ini

Is that uncommented or commented?

The users in the DB ?

[Armando]

anserkk:

There is no bind-address entry in mysql.ini (I have windows 10)
and the users is

root localhost

Regards