# yum info mysql-server # rpm -qa | grep mysqlįor Ubuntu servers, use below command # dpkg -l 'mysql-server*' Conclusion: You can use this command on Linux distributions like RHEL/CentOS. We can search packages installed on server and find out installed MySQL packages. Let’s try differently for some time by using package manager commands. Through PHP Script functions: mysqli::$server_info - mysqli_get_server_info - Returns the version of the MySQL server Just run that PHP script to find MySQL version. If you are web developer and don’t have access to server ROOT, then create small PHP script and upload to server. You can see MySQL version, configuration, sockets, uptime and run time variables through one command. MySQL admin tools # mysqladmin version # mysqladmin -V My favorite method to check MySQL version, configuration and RunTime variables. Type 'c' to clear the current input statement. Other names may be trademarks of their respective owners.Type 'help ' or 'h' for help. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Commands end with or g.Your MySQL connection id is 24511746 Server version: 5.5.52-cll MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle and/or its affiliates. It shows that present version version is Server version: 5.5.52-cll MySQL Community Server (GPL) You can see MySQL version in command output. You will be presented with complete MySQL server information like below. In this method you can use MySQL Client Tools to find version details. Mysql Ver 14.14 Distrib 5.5.52, for Linux (x86_64) using readline 5.1 Method 2: Use below commands on any Linux distribution to see MySQL version. However, some of the below methods don’t require Root logins. Then you can execute any of the following commands to see MySQL version. Requirements:įirst, you need to login to the server as a root user. Let's explore different ways to check MySQL version installed on your server. The current version of MySQL available for Linux is 5.7.6 Hold on a sec, Did you know the latest version of MySQL available for Linux? Are you trying to figure out which commands to execute to check MySQL Version on different Linux distributions like RedHat, CentOS, and Ubuntu?
0 Comments
Leave a Reply. |