1. Home
  2. Technology
  3. MySQL
  4. Determine If MySQL Installed is 32 or 64 Bit Version

Determine If MySQL Installed is 32 or 64 Bit Version

On Windows, locate the folder where the file “mysqld.exe” exist – it is often in the folder “C:\Program Files>MySQL>MySQL Server 5.6>bin

Open the command prompt in Windows

Click Start and enter ‘cmd’ in the Run window

In the command window, change the working directory to that of where the “mysql.exe” file is located:

In this example the folder path is C:\Program Files\MySQL\MySQL Server 5.6\bin

Launch the MySQL Command Line Console and specify “root” as the username to login with

C:\>Program Files>MySQL>MySQL Server 5.6>bin>mysql -u root -p

Enter the password for this user

Once logged in, enter the command “s;” and the output will indicate if it’s Win64:

mysql> s;
————–
mysql Ver 14.14 Distrib 5.6.10, for Win64 (x86_64)

Updated on March 30, 2020

Related Articles