I have MySQL 3.23 server installed on a Linux system.

My Java application is running on a Windows 2000 system.

I am connecting via the mmSQL 1.2a Type IV JDBC driver.

I can successfully connect to the server by specifying the root username and password.

However, when I try to connect to the server using any other username/password combination I receive the following error message:

Communication link failure: Bad handshake.

I have even added some users to the MySQL server that have superuser privileges set, but still can;t connect using their credentials.

Any ideas what may be causing this?

thanks
- Garry

Are you sure that when you added your mysql user you give them the host used by your windows server ?

The syntax I use is as follows:

GRANT ALL ON MYDB.* TO user1 identified by "username1"

I read than ommitting the @ symbol after the username basically means 'allow this user to connect to this server from anywhere'.

Is this correct?

Anyway, when I do specify the host name of the Windows server i.e.

GRANT ALL ON MYDB.* TO user1@winserver identified by "username1"

and subsequently attempt to connect via mysql client I receive the message:

ERROR 1045: Access denied for user: 'user1@<windows IP address>' (Using password: YES)

Any thoughts?

thanks
- Garry

you should use the ip instead of the windows name.

GRANT ALL ON <DB>.* TO <user>@<IP/hostname> IDENTIFIED BY <PASSWD>

You can replace IP/hostname by % to allow access from any IP