I cannot connect to the MySQL server from a remote web-host

------_=_NextPart_001_01C56666.3CD3ADC8
Content-Type: text/plain;
charset="windows-1253"
Content-Transfer-Encoding: quoted-printable

I cannot connect to the MySQL server from a remote host (with proper =
privileges and IP/host or % as host). =20

=20

I have installed successfully MySQL (version 4.1) on a windows 2000 =
server and works fine. I have no problem connecting to MySQL when I =
run my web page locally (MySQL host).

"urn:schemas-microsoft-com:office:office" />

Reading through the MySQL manual I found that, a similar problem exists =
for Linux installation and the problem can be resolved by commenting the =
line bind-address 127.0.0.1 in the my.cnf. The problem is that there is =
no such line in the windows version of my.cnf.

=20

Any suggestions?

Thanks

TS


------_=_NextPart_001_01C56666.3CD3ADC8--

Re: I cannot connect to the MySQL server from a remote web-host

Have you checked the internal firewall or any blocking traffic apps
that you could have in your system? What about a router or similar
device on your network? Do you have static IP? I guess we all need
more information in order to help you, like your environment for
example.

I sincerely think this is more a system configuration problem than a
MySQL one. How are you connecting to your machine when you locally
test your page? If you're using localhost or 127.0.0.1 then try using
your real IP or address and check if they are not being translated at
the HOST table.

Good luck,

On 6/1/05, Stratopoulos, Theo wrote:
> I cannot connect to the MySQL server from a remote host (with proper priv=
ileges and IP/host or % as host).
>=20
>=20
>=20
> I have installed successfully MySQL (version 4.1) on a windows 2000 serve=
r and works fine. I have no problem connecting to MySQL when I run my web=
page locally (MySQL host).
>=20
> fice" />
>=20
> Reading through the MySQL manual I found that, a similar problem exists f=
or Linux installation and the problem can be resolved by commenting the lin=
e bind-address 127.0.0.1 in the my.cnf. The problem is that there is no su=
ch line in the windows version of my.cnf.
>=20
>=20
>=20
> Any suggestions?
>=20
> Thanks
>=20
> TS
>=20
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: I cannot connect to the MySQL server from a remote web-host

Hi ,
look at usage of parameter skip-name-resolve.

here for example http://bugs.mysql.com/bug.php?id=4229
or better in the mysql docs.

see also the effect of password encryption (maybe old_password rather than
password).

Mathias

Selon Daniel da Veiga :

> Have you checked the internal firewall or any blocking traffic apps
> that you could have in your system? What about a router or similar
> device on your network? Do you have static IP? I guess we all need
> more information in order to help you, like your environment for
> example.
>
> I sincerely think this is more a system configuration problem than a
> MySQL one. How are you connecting to your machine when you locally
> test your page? If you're using localhost or 127.0.0.1 then try using
> your real IP or address and check if they are not being translated at
> the HOST table.
>
> Good luck,
>
> On 6/1/05, Stratopoulos, Theo wrote:
> > I cannot connect to the MySQL server from a remote host (with proper
> privileges and IP/host or % as host).
> >
> >
> >
> > I have installed successfully MySQL (version 4.1) on a windows 2000 server
> and works fine. I have no problem connecting to MySQL when I run my web
> page locally (MySQL host).
> >
> > > />
> >
> > Reading through the MySQL manual I found that, a similar problem exists for
> Linux installation and the problem can be resolved by commenting the line
> bind-address 127.0.0.1 in the my.cnf. The problem is that there is no such
> line in the windows version of my.cnf.
> >
> >
> >
> > Any suggestions?
> >
> > Thanks
> >
> > TS
> >
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=mfatene@free.fr
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org