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:
Other People Are Reading
Things you need
Open a terminal or access the command line on the server your MySQL database is installed on.
Type "which mysqld" to locate where the database is installed. The command line will return a path similar to "/bin/mysql."
Type "file <path>" into the command line and press "Enter." Replace "<path>" with the installation path found in the previous step.
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."
Run MySQL and use the MySQL query command line to determine the installation version.
Type "SHOW GLOBAL VARIABLES LIKE 'version_compile_machine';" into the prompt and press "Enter" to execute the query.
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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for