How to Tell if MySQL Is 32- or 64-Bit

Written by william nagel
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Tell if MySQL Is 32- or 64-Bit
Find out which version of MySQL is installed on your server. (Thinkstock Images/Comstock/Getty Images)

MySQL is an open-source SQL database available for free and capable of running on a wide variety of system platforms. Depending on the hardware specifications of the computer, MySQL can be installed in either a 32- or 64-bit version. Functionally, both versions perform the same tasks, but minor differences in the way the 32- and 64-bit versions handle data can change the way you interact with the system. To determine which version is installed on your server, use the command line to query the database.

Skill level:

Things you need

  • MySQL

Show MoreHide


  1. 1

    Open a terminal or access the command line on the server your MySQL database is installed on.

  2. 2

    Type "which mysqld" to locate where the database is installed. The command line will return a path similar to "/bin/mysql."

  3. 3

    Type "file <path>" into the command line and press "Enter." Replace "<path>" with the installation path found in the previous step.

  4. 4

    Examine the data returned by the system. If you have a 32-bit version of MySQL installed, the line will begin "ELF 32-bit LSB executable." If you have a 64-bit version of MySQL, the line will read "ELF 64-bit LSB executable."

  1. 1

    Run MySQL and use the MySQL query command line to determine the installation version.

  2. 2

    Type "SHOW GLOBAL VARIABLES LIKE 'version_compile_machine';" into the prompt and press "Enter" to execute the query.

  3. 3

    Examine the query results to determine the version of MySQL you are running. A 32-bit version will display "i686" in the results next to "version_compile_machine." A 64-bit version will display "x86_64" in the results next to "version_compile_machine."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.