How Do You Know the Version of Your MySQL Server

Q

How Do You Know the Version of Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows

✍: 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.

2007-05-10, 5238👍, 0💬

How To Add a New User Account
How To Add a New User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is... 2007-05-10, 6243👍, 0💬

What Is MySQL
What Is MySQL? - MySQL FAQs - Downloading and Installing MySQL on Windows 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, ... 2007-05-10, 5860👍, 0💬

What Are the Predefined User Accounts
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes ... 2007-05-10, 5526👍, 0💬

How To Install MySQL
How To Install MySQL? - MySQL FAQs - Downloading and Installing MySQL on Windows 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.my... 2007-05-10, 5360👍, 0💬

How Do You Know the Version of Your MySQL Server
How Do You Know the Version of Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows 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 ve... 2007-05-10, 5239👍, 0💬

What Is a User Account
What Is a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, In... 2007-05-10, 5210👍, 0💬

How To Start MySQL Server
How To Start MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows 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 c... 2007-05-10, 5157👍, 0💬

How To Shutdown MySQL Server
How To Shutdown MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows 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 2007-05-10, 5148👍, 0💬

How To Create a Test Table in Your MySQL Server
How To Create a Test Table in Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows 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 My... 2007-05-10, 5051👍, 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.