SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Guru
    Join Date
    Jun 2009
    Posts
    820
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    what version of MySQL do I have??

    I'm trying to install Drupal, how do I find out what version of MySQL I have?

    I don't use a GUI Admin... I connect, apart from doing so with PHP and JSP, thru unix shell.... (this is locally on my mac)
    is there a command in command-line client to find out what version I have?

    I went to MySQL folder where it's installed but couldn't find in there..

    thank you..


    oh man.... NEVER MIND.... it tells you when you log in.. I had never noticed this... ;-)

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I see you found the answer. Here's another: Run the query "SHOW VARIABLES", and look at the "version" line.

  3. #3
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    and another, from the mysql command prompt type
    SELECT version()

  4. #4
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    357
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure where it's documented, but like sql server, mysql supports select @@version
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon


Bookmarks

Posting Permissions

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