MySQL - Verify the Version of MySQL Server in MySQL

Verify the Version of MySQL Server in MySQL

Q

How Do You Know the Version of Your MySQL Server in MySQL?

✍: FYIcenter.com

A

If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysqladmin -u root version
mysqladmin  Ver 8.41 Distrib 5.0.24, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB
 & TCX DataKonsult AB
...
Server version          5.0.24-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 25 min 9 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 12 
Flush tables: 1  Open tables: 6 
Queries per second avg: 0.001

The output in the above example tells you that the version number is 5.0.24.

⇒Downloading and Installing MySQL on Windows

⇒⇒MySQL Database Tutorials

2018-06-06, 788👍, 0💬

Creating a Test Table in MySQL Server in MySQL
How To Create a Test Table in Your MySQL Server in MySQL? If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysql -u root Welcome to the MySQL monitor. Commands end with ; or ... 2018-06-06, 756👍, 0💬

Starting MySQL Server in MySQL
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqld "mysqld" will run quietly without printing any message in you command window. So you will see nothi... 2018-06-12, 746👍, 0💬

Verify MySQL Server Status in MySQL
How Do You Know If Your MySQL Server Is Alive in MySQL? If you want to know whether your MySQL server is alive, you can use the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin -u root ping mysqld is alive The "mysqld is alive" mes... 2018-06-06, 745👍, 0💬

Shutting Down MySQL Server in MySQL
How To Shutdown MySQL Server in MySQL? If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin shutdown ⇒Downloading and Installing MySQL on Windows ⇒⇒MySQL Database Tutorials 2018-06-06, 698👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.