Problems in connecting to remote mysql host from vc++ code

--0-357026498-1125645667=:28246
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

i am getting problems connecting to remote mysql host from vc++. i can connect and do all other mysql stuff on my localhost, but can not connect to remote mysql host. The error i get when i use mysql_real_connect is "bad handshake".


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--0-357026498-1125645667=:28246--

Re: Problems in connecting to remote mysql host from vc++ code

Hi,

did you try to connect from that machine with any other program except
yours?

Erich

vishal d wrote:
> i am getting problems connecting to remote mysql host from vc++. i can connect and do all other mysql stuff on my localhost, but can not connect to remote mysql host. The error i get when i use mysql_real_connect is "bad handshake".
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

--
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

Re: Problems in connecting to remote mysql host from vc++ code

------=_Part_6900_1336066.1125861109561
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi -

The fact that you're getting bad handshake suggests several things to me:

0. If you can, ping the remote host just to be sure you actually can reach=
=20
the remote system over the network. You'll need to know the full IP address=
=20
or system name. If you're not familiar with ping, pop your cmd window and=
=20
issue ping command as in either of the examples below:

ping 123.234.34.4

or

ping remote.host.com

1. Is ODBC set up on the remote host?
2. Does your local system show the ODBC on the remote host in its list of=
=20
available data connectors?
3. Is the userid and password set on the remote computer? You should NOT be=
=20
using root on the remote computer. You should have another MySQL userid set=
=20
up on the remote computer with its own password. You'll need to log into th=
e=20
remote computer as root and use the GRANT to set up the other MySQL userid.=
=20
Nearly always, I make a native system userid on the remote system called=20
mysql-pseudodude as to remind me that I have a database cooking there to=20
provide remote services.=20

HTH and let us know what it turns out to be. We all learn from knowing.

virginia
--=20
\ / Virginia R. Hetrick, here in sunny California
0 Voicemail: 310.471.1766 Email: drjuice@gte.net
Oo "There is always hope."
Keeping track of the weather:=20
http://www.washington.edu/cambots/camera1_l.gif

------=_Part_6900_1336066.1125861109561--