In this command line client window, you need to provide the root password in the password prompt. To check the MySQL server version installed in Windows, we need to open the mysql command line client.
#MYSQL VERSION HOW TO#
How to check MySQL version in windows via CLI Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.30 MySQL Community Server - GPLĬopyright (c) 2000, 2022, Oracle and/or its affiliates.
#MYSQL VERSION FULL VERSION#
This command will output the full version details of MySQL in Windows.Ĭopy Code Copied Use a different Browser Enter password: **********
Now open a command prompt and change the directory to that path. Copy the whole path including the bin directory. C:\Program Files\MySQL\MySQL Server 8.0 in our case. Next, move to the MySQL installation folder as per MySQL version in Windows (e.g. Just by looking at the name of the folder inside it, you can guess the MySQL version in Windows. So for checking the MySQL version in Windows, you need to first look into the C:\Program Files\MySQL folder. If the MySQL version in Windows is 8.0, then the installation path will be C:\Program Files\MySQL\MySQL Server 8.0. The installation path is also dependent on the MySQL version in Windows. To check the MySQL version installed in windows, you first need to find the MySQL installation path on Windows. This makes checking the MySQL version in Windows a bit different. But in Windows mysqld is placed in the MySQL installation directory, which may not be present in the PATH environment variable. In a Linux environment mysqld is always within the executable path. But things are not so simple on Windows, where you need to check the MySQL version. The common Linux way of finding the MySQL version is by running the status command ‘mysqld –version’ in the shell prompt. Moreover most of the MySQL tutorials and guides are focused on the Linux installation of MySQL version. This is so because there is a substantial difference between Linux and Windows installation of MySQL server. How to check MySQL version in Windows can be a bit of a task.
0 kommentar(er)
