topic-37644

Posts: 3358

Joined: Fri Oct 07, 2005 08:20 PM

A question for Mr. Rao
Posted: Fri Aug 16, 2019 02:42 AM

Mr Rao:

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

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

But this one yes (There is conection)

Code (fw): Select all Collapse

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

The only diference is the host name.

Regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

joseluisysturiz

Posts: 2064

Joined: Fri Jan 06, 2006 09:28 PM

Re: A question for Mr. Rao
Posted: Fri Aug 16, 2019 01:23 PM

Armando wrote:Mr Rao:

Why this code does not work (There is not conection)
Code (fw): Select all Collapse
FWCONNECT oCn HOST "localhost" USER "root" PASSWORD "secret" DB "AppSap"
But this one yes (There is conection)
Code (fw): Select all Collapse
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...

Dios no está muerto...

Gracias a mi Dios ante todo!

Armando

Posts: 3358

Joined: Fri Oct 07, 2005 08:20 PM

Re: A question for Mr. Rao
Posted: Fri Aug 16, 2019 02:39 PM

José Luis:

También funciona, muchas gracias.

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

Saludos

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: A question for Mr. Rao
Posted: Sat Aug 17, 2019 05:38 AM

Armando wrote: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

Posts: 3358

Joined: Fri Oct 07, 2005 08:20 PM

Re: A question for Mr. Rao
Posted: Sat Aug 17, 2019 03:46 PM

anserkk:

Thanks for your answer.

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

Code (fw): Select all Collapse

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

Regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: A question for Mr. Rao
Posted: Tue Aug 20, 2019 04:19 AM

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

Posts: 3358

Joined: Fri Oct 07, 2005 08:20 PM

Re: A question for Mr. Rao
Posted: Tue Aug 20, 2019 02:58 PM

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

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: A question for Mr. Rao
Posted: Wed Aug 21, 2019 12:40 PM

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

Posts: 3358

Joined: Fri Oct 07, 2005 08:20 PM

Re: A question for Mr. Rao
Posted: Wed Aug 21, 2019 02:30 PM

anserkk:

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

root localhost

Regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero

FiveTech Support Forums

Continue the discussion