Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Posts
    22

    Unanswered: cannot connect to MySQL server, otherthan via root user

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Are you sure that when you added your mysql user you give them the host used by your windows server ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Apr 2002
    Posts
    22
    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

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    you should use the ip instead of the windows name.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Jun 2003
    Posts
    9
    GRANT ALL ON <DB>.* TO <user>@<IP/hostname> IDENTIFIED BY <PASSWD>

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •