Remote mysql question

Discussion in 'MySQL' started by raamee, Aug 11, 2011.

0
  1. #1
    Hello,

    I have a mysql server which I need some clients to connect to that remotely. I have created databases and users. The users are able to connect via phpmyadmin to their databases . But when they try connecting from telnet they get "bad handshake error" and the connection lost. How do solve it? I have opened port 3306.

    Thanks.
     
    raamee, Aug 11, 2011 IP
  2. helpinghost

    helpinghost Active Member

    Messages:
    36
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    53
    #2
    I'm unsure if you are saying that they are using telnet just to test the connection or if you are saying they are connecting with telnet to manage/work with the MySQL instance.
    If the later is the case, MySQL requires you to use a mysql client tool NOT telnet to connect to it.
    Look into tools like MySQLYog or Navicat to work on Mysql remotely.

    However, I personally would strongly suggest to only open port 3306 to the exact people you want to give access to the server.
    Opening port 3306 to the world is NOT a good idea.
     
    helpinghost, Aug 15, 2011 IP
  3. rndm

    rndm Greenhorn

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    I prefer to give people limited ssh accounts and instructions on how to tunnel for port 3306. It's pretty easy once you've done it a few times and it doesn't require opening ports.
     
    rndm, Aug 21, 2011 IP