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

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 [at] m.gmane.org

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

the remote system over the network. You'll need to know the full IP address=

or system name. If you're not familiar with ping, pop your cmd window and=

issue ping command as in either of the examples below:

ping 123.234.34.4 <http://123.234.34.4>

or

ping remote.host.com <http://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=

available data connectors?
3. Is the userid and password set on the remote computer? You should NOT be=

using root on the remote computer. You should have another MySQL userid set=

up on the remote computer with its own password. You'll need to log into th=
e
remote computer as root and use the GRANT to set up the other MySQL userid.=

Nearly always, I make a native system userid on the remote system called
mysql-pseudodude as to remind me that I have a database cooking there to
provide remote services.

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

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

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