Kangry.com [insert cool graphic here]
home | Topics | Logout | Search | Contact | ?? Kangry ?? | Bandwitdh
Topics:
DVR
nvrec
Mplayer
Links
Misc
Commands
Humor

Name

Password

New user

uploaded files
(links)-> (Parent)->find out version of mysql in linux machine via command line or query submited by Russell Thu 19 Jan 06
Edited Fri 30 Mar 12
Web kangry.com
In responce to: " find out version of mysql in linux machine via command line"

To get the version number from the command line use:
mysql -V
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
This is the version of the client you have installed. Typcialy the server and the client should be the same version. You can check all the files with the rpm command:
rpm -q --all |grep mysql
php-mysql-4.3.11-2.8
mysql-devel-3.23.58-16.FC3.1
mod_auth_mysql-20030510-5
mysql-3.23.58-16.FC3.1
mysql-bench-3.23.58-16.FC3.1
libdbi-dbd-mysql-0.6.5-9
mysql-server-3.23.58-16.FC3.1
These commands should work on any rpm based product ( Redhat , Fedora Core 1,2,3,4 ... , RHEL 1,2,3,4 ... )

Another way to figure out the version of the server is to connect to it. ( this will work even if the server isn't local, so long as you have access)
mysql -u username -h servername -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3491937 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
The Version number of the server is displayed on the welcome message.
Now if you want an application to be able to make choices based on the my sql version number you can also query the server for it's version number.
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.86    | 
+-----------+
1 row in set (0.00 sec)

mysql> 



Add comment or question...:
Subject:
Submited by: NOT email address. Leave blank for anonymous    (Spam Policy)

Enter Text: (text must match image for posting)




This file (the script that presented the data, not the data itself) , last modified Tuesday 06th of March 2018 11:41:12 PM
your client: claudebot
current time: Thursday 28th of March 2024 05:00:41 AM