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

This article mainly introduces the Linux mysqladmin command how to use the relevant knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe that we read this Linux mysqladmin command how to use the article will have a harvest, let's take a look.

Linux common commands mysqladmin command is a client tool for MySQL server management tasks. It can check the configuration and current working status of 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 mysqladmin commands support MySQL server management commands are very rich, you can use "--help" to display available management commands.

Refer to the instance to view the current status of the server:

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

[root@linux265 ~] # mysqladmin-u root-poldpassword password 'linux265' check whether mysqlserver is available:

[root@linux265 ~] # mysqladmin-u root-p ping mysqld is alive create a new database:

[root@linux265] # mysqladmin-u root-p create mysql_linux265 article on "how to use Linux's mysqladmin command" ends here, thank you for reading! I believe you all have a certain understanding of the knowledge of "how to use the mysqladmin command of Linux". If you want to learn more, you are welcome to follow the industry information channel.

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.