Shulou(Shulou.com)06/02 Report--

Editor to share with you the use of linux's mysqladmin command MySQL server client management tool, I hope you will learn a lot after reading this article, let's discuss it together!

The mysqladmin command is a client tool for MySQL server management tasks. It can check the configuration and current working status of the MySQL server, create and delete databases, create users and change user passwords.

Syntax format: mysqladmin [parameters] [Management commands]

Common parameters:

-hMySQL server hostname or ip address-u user name to connect to the MySQL server-password to connect to the MySQL server-help displays help information

The mysqladmin command supports a wealth of MySQL server management commands, which can be displayed through "--help".

Reference example

View the current status of the server:

[root@linuxcool] # mysqladmin-u root-p statusEnter password: Uptime: 26 Threads: 1 Questions: 2 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.076

Change the root password:

[root@linuxcool] # mysqladmin-u root-poldpassword password 'linuxcool'

Check that mysqlserver is available:

[root@linuxcool] # mysqladmin-u root-p pingmysqld is alive

Create a new database:

[root@linuxcool] # mysqladmin-u root-p create mysql_linuxcool has finished reading this article, I believe you have some understanding of using linux's mysqladmin command MySQL server client management tool, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.