How to check MySql version in Ubuntu

Check MySql version in Ubuntu

To check the version of MySQL installed on an Ubuntu system, you can use the following command:

mysql -V

This command will display the version of the MySQL server that is currently installed on the system.

Alternatively, you can use the following command to check the version of MySQL:

mysql --version

This command will display the version of MySQL in the following format: mysql Ver x.x.x for ubuntu x.x on x86_64 (Ubuntu x.x-x)

In summary, checking the version of MySQL installed on an Ubuntu system is a simple process that can be easily accomplished using the mysql -V or mysql –version command. These commands will display the version of MySQL that is currently installed on the system.

Share on: Share YogiRaj B.Ed Study Notes on twitter Share YogiRaj B.Ed Study Notes on facebook Share YogiRaj B.Ed Study Notes on WhatsApp

Suggested Posts

What is MySQL – A Relational Database Management System (RDBMS)
What is MySQL – A Relational Database Management System (RDBMS)
 What is mysql MySQL is a free, open-source relational database management system (RDBMS) that is widely used in web applications ..
Query optimization in Sql
Query optimization in Sql
 Query optimization Query optimization is the process of improving the performance of SQL queries. This is done by identifying and..
How to insert date in MySql using php
How to insert date in MySql using php
 Connect to the MySQL database using the mysqli_connect() function, which takes the database server hostname, username, password, ..
What is rollback in Sql
What is rollback in Sql
 In SQL, a rollback is the operation of canceling or undoing the effects of a previous transaction. A transaction is a group of SQL..
SQL joins
SQL joins
 Types of SQL Joins In SQL, a join is a way to combine data from multiple tables based on a common field between them. This allows..
MySql – how to connect to database
MySql – how to connect to database
 How to connect to database in MySql To connect to a MySQL database, you need to use a MySQL client. Here is an example of how to ..
Update query in mysql php | Complete explaination of Sql Update query
Update query in mysql php | Complete explaination of Sql Update query
 To update data in a MySQL database using PHP, you can use the following steps: Connect to the MySQL database using the ..
Sql commands with example
Sql commands with example
 SQL (Structured Query Language) is a programming language used for managing and accessing data stored in relational databases. SQL..
Sql merge statement with example
Sql merge statement with example
 SQL MERGE statement In SQL, the MERGE statement is used to combine data from two or more tables into a single table. It allows ..
What is Sql | Examples of common SQL queries
What is Sql | Examples of common SQL queries
 SQL (Structured Query Language) is a programming language used for managing and accessing data stored in relational databases. It ..
How to export MySql data to excel using php
How to export MySql data to excel using php

Exporting data from a MySQL database to Excel is a common task for many users, and it can be easily accomplished using PHP. PHP is a popular scripting language that is often used for web development, and it has built-in support for working with MySQL databases.

Read full article
What is Computer – Definition and Basic Concept of a Computer
What is Computer – Definition and Basic Concept of a Computer

Definition and Basic Concept of Computer
Introduction to a Computer
In general speaking the computer is simply a calculating device. The name Computer is derived from a Latin word computare which mean “to compute”. As we know the Computer is a special type of programing machine having some basic characteristics like –

Read full article
How to delete duplicate records in Sql
How to delete duplicate records in Sql

To delete duplicate records in SQL, you can use the following syntax:
DELETE FROM [table_name] WHERE [primary_key] IN (SELECT [primary_key] FROM [table_name] GROUP BY [primary_key] HAVING COUNT(*) > 1);

Read full article
How To Install MySQL on Ubuntu
How To Install MySQL on Ubuntu

Installing MySQL on Ubuntu is a straightforward process that can be easily accomplished using the apt package manager. Ubuntu is a popular Linux operating system that is often used for web development, and it comes with a built-in package manager that makes it easy to install and manage software packages.

Read full article

Some important study notes