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

How can I determine the exact version of mysql?

forums › forums › SQLyog › Using SQLyog › How can I determine the exact version of mysql?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 24, 2005 at 4:19 pm #9007
      walkman
      Member

      Both my local and server are supposedly 4.1, but I'm not sure if there is a dot difference that is causing an incompatibility.

    • May 24, 2005 at 4:38 pm #17938
      Ritesh
      Member

      Execute

      Code:
      select version()
    • May 24, 2005 at 4:49 pm #17939
      peterlaursen
      Participant

      another possibility is:

      Get “MySQL Administrator” from http://www.mysql.com. It provides you with a lot useful information of the server and abitlities to change settings. But you must be able to connect directly to the MySQL port to use it. It offers no tunnelling options.

      The two tools thast I wouldn't be without when running a local server is “MySQL Administrator” and “SQLyog”. There is a little bit of overlapping functions (user management, backup), by MA is particularlu usefull when working with the server environment, Sqlyog is particularly usefull when working with data.

    • May 25, 2005 at 8:41 am #17940
      Shadow
      Member

      And there were quite a lot of changes in sub-versions of 4.1 series…

      SHOW VARIABLES LIKE '%version%'; command will tell you more details about MySql.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.