How to retrieve the current version of a MySQL database management system DBMS

0 votes
What command returns the current version of a MySQL database?
Sep 19 in Database by Kithuzzz
• 20,660 points
50 views

1 answer to this question.

0 votes

Many responses advise using mysql —version. But the client is the MySQL software. Mysqld is the server. The command should therefore be:

mysqld --version

or

mysqld --help

On both Windows and Debian, that works for me.

When using a client to connect to a MySQL server, you can utilize:

select version()

or

select @@version

I hope this helps you. 

answered Sep 20 by narikkadan
• 37,660 points

Related Questions In Database

0 votes
1 answer

What are the steps performed by Migration Wizard while migrating a database to MySQL?

The following are the steps  performed by ...READ MORE

answered Dec 10, 2018 in Database by Sahiti
• 6,380 points
355 views
0 votes
1 answer

How to display the queries executed by a particular user in MySQL?

From the version 5.1.7 onward, MySQL allows ...READ MORE

answered Mar 7, 2019 in Database by Mishti
• 480 points
2,101 views
0 votes
2 answers
0 votes
1 answer

How to load data of .csv file in MySQL Database Table?

At first, put the dataset in the ...READ MORE

answered Jul 5, 2019 in Database by Reshma
807 views
0 votes
1 answer

Want a command to be executed in Salt only if a directory is empty

You should consider using this inside your ...READ MORE

answered Jun 12, 2018 in DevOps Tools by Damon Salvatore
• 5,980 points
845 views
0 votes
1 answer

Creating A New MySQL User In Amazon RDS Environment

AWS RDS security groups documentation (a common ...READ MORE

answered Jul 18, 2018 in AWS by Priyaj
• 58,100 points
1,417 views
0 votes
1 answer

Using conditional to execute a command in salt

You can use unless inside your state ...READ MORE

answered Jul 23, 2018 in Other DevOps Questions by DareDev
• 6,890 points
906 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

answered Sep 12 in Database by narikkadan
• 37,660 points
61 views
0 votes
1 answer

Why do I need to configure the SQL dialect of a data source?

Dialect is defined as "a language's variety." ...READ MORE

answered Sep 18 in Database by narikkadan
• 37,660 points
81 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP