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, 880👍, 0💬

What Is "mysqld" Command in MySQL
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoking "mysqld" with the "--... 2018-06-01, 891👍, 0💬

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select th... 2018-06-12, 886👍, 0💬

Tools to Manage MySQL Server in MySQL
What Tools Available for Managing MySQL Server in MySQL? MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin - A command-line interface for administrators to per... 2018-06-01, 883👍, 0💬

Verify the Version of MySQL Server in MySQL
How Do You Know the Version of Your MySQL Server in MySQL? 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.... 2018-06-06, 881👍, 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, 860👍, 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, 835👍, 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, 831👍, 0💬

MySQL Server Features in MySQL
What Is MySQL in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. MySQL has the following main features: Works on many different platforms. APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available. Fully multi-threaded using ... 2018-06-12, 813👍, 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, 789👍, 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.