![]() You can use the same commands in any Linux version. In this article, we have learnt several ways to get MySQL version in Ubuntu. Threads: 1 Questions: 839780 Slow queries: 0 Opens: 354 Flush tables: 1 Ope n tables: 347 Queries per second avg: 10.843 You can also use the STATUS command to get the same information. The easiest way is to ask RPM which version it is: rpm -q mysql-devel. Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Unx-like operating systems. To check the version your MySQL is running, type and execute mysql -V (note the uppercase V) in the command line. How can I check which version is installed. If you want to run specific queries of stored procedures, depending on the MySQL version, then you can use the above command. Windows users can employ PowerShell or the command prompt and Linux and MacOS have the Terminal. Among them, the row with variable_name=’version’ will display MySQL version.Īlternatively, you may also use the following command to get MySQL version. The above command will show several lines of output. You may also use SHOW VARIABLES command for this purpose as shown below. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Every time you log into MySQL shell, it will display the version information at the top for your reference. There are several ways to find out MySQL version from within its shell. In such cases, you can run the above command. Sometimes you may want to execute commands conditionally, depending on MySQL version. If you want to find and use the MySQL version number from within your shell script, then use this method. The above command can be used in Linux, Windows & Mac. Please remember to use capital V in the above command. Mysql Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using EditLine wrapper We will look at both these approaches.įrom terminal (in Linux/Mac) or command prompt (in Windows), you can simply call MySQL command with a -v option to get its version number. ![]() There are two ways to check MySQL version in Ubuntu – from outside and inside MySQL shell. In this article, we will learn how to check MySQL version in Ubuntu. So it is important to keep track of the MySQL version you are using to be able to make most of it. In some cases, the syntax of certain commands may also change from one version to another. It also deprecates some of the functions and features. Every MySQL version offers new features and improvements over the previous versions. MySQL is a popular database system used by many organizations and developers around the world.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |