Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error No. 2007 – Protocol Mismatch

forums forums SQLyog Using SQLyog Error No. 2007 – Protocol Mismatch

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • #8694
      bcrumrin
      Member

      When I try to connect to the MySQL server I get an error. Error No. 2007 – Protocol mismatch; server version = 9, client version = 10

      I realize this is because we are running a very old version of MySQL, but we have no way to change this today as it is not our server. We are in the process of upgrading (it's not going to be a quick thing) – we are evaluating MySQL clustering (ND:cool:.

      In reading through some of the past posts there were some references to the problem I am experiencing. The solution was to get a special build of SQLyog that supported the older client library. It is still possibly to get this?

      Thanks,

      Brian

    • #16674
      Ritesh
      Member

      Which version of MySQL are you connecting to?

      Depending upon the MySQL version I can ask my development team to release a special build for you.

    • #16675
      bcrumrin
      Member

      This is the version from mysql –version:

      mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

      We have tried HTTP tunneling as well without luck, SQLyog gets some data then just hangs there on subsequent queries.

      Thanks,

      Brian

    • #16676
      Shadow
      Member

      The newer builds of PHP have trubles to connect to older versions of MySql as well. Even if they did, the returned results would not be in the format expected by SQLyog.

    • #16677
      bcrumrin
      Member

      We are running an older build of PHP as well, so there are no connection problems there. It's probably just the results are not understandable by SQLyog.

      Brian

    • #16678
      Ritesh
      Member

      Can you send me the URL of your SQLyogTunnel.php page?

      Is it possible to get temporary access to your MySQL server so that we can work on the problem and fix the bugs (if there are any).

Viewing 5 reply threads
  • You must be logged in to reply to this topic.