![]() ![]() ![]() Short of querying the package manager (kind of hard to do in a script if you have many systems running different distributions) it seems a very reliable way to tell. The following command will display the MariaDB version: 1 mysql The output for the above command would look like the following: 1 2 3 Welcome to the MariaDB monitor. The `which' program may not be installed, so check for it via: # which which Regardless of your Linux distribution, the command to identify your running server version is the same. Now, check for the existence of the actual client and server: # which # which # Its very rare that someone would install the shared objects only, without installing at least the client. This tells you that there's a very good chance that MySQL is installed. Libmysqlclient.so (libc6) => /usr/lib/libmysqlclient.so Libmysqlclient.so.10 (libc6) => /usr/lib/libmysqlclient.so.10 Method 1: Displaying the MySQL version using commands The fastest way to display the installed version of MySQL is to use the mysql command with which you can, among other things, access the shell, but also execute commands. Libmysqlclient.so.12 (libc6) => /usr/lib/libmysqlclient.so.12 However, licensing changes made by Oracle, the new parent company established an alternative to MySQL called MariaDB. I see iblogfile0, iblogfile1, and ibdata1 on the linux MySQL data folder, but am not sure if it was truly running InnoDB or not. Then, MySQL was probably the only database server used in the majority of the open-source projects. I do not know what version of MySQL was installed on the linux box. Libmysqlclient.so.14 (libc6) => /usr/lib/libmysqlclient.so.14 I am currently trying to retrieve the latest data from the linux MySQL data folder and import it into the current database but I am having problems. Libmysqlclient.so.15 (libc6) => /usr/lib/libmysqlclient.so.15 Libmysqlclient_r.so (libc6) => /usr/lib/libmysqlclient_r.so Libmysqlclient_r.so.10 (libc6) => /usr/lib/libmysqlclient_r.so.10 Libmysqlclient_r.so.12 (libc6) => /usr/lib/libmysqlclient_r.so.12 Libmysqlclient_r.so.14 (libc6) => /usr/lib/libmysqlclient_r.so.14 Libmysqlclient_r.so.15 (libc6) => /usr/lib/libmysqlclient_r.so.15 You can check for this by using the ldconfig tool, which will query to see if the object is installed: ldconfig -p | grep mysqlclient How To Check MySQL Version How To Check MySQL Version MySQL MySQLi Database Let us understand how to check the version of MySQL that the user is currently running Before entering queries on the console, it is important to ensure that the user is connected to the server. On every distribution that I know of, MySQL installs some shared libraries for its client, named appropriately limbysqlclient. ![]()
0 Comments
Leave a Reply. |