MySQL Server hypervisor mysqladmin command

mysqladmin commands are management programs for MySQL servers that you can use to perform system administration operations such as checking profiles, checking service status, shutting down servers, creating databases, deleting databases, and so on.

1) look at the list of threads that the MySQL server is running as shown below.

[Email protected] ~]# mysqladmin-uroot-p processlist

Enter Password:

+----+------+-----------+----+---------+------+-------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+----+------+-----------+----+---------+------+-------+------------------+

| 18 | Root |    localhost | | Query |       0 | | Show Processlist |

+----+------+-----------+----+---------+------+-------+------------------+

2 ) Check if the MySQL service is running

[[email protected] ~]# mysqladmin–u root-p Ping

Enter Password:

mysqld is alive # Service is running

3 ) Change Password

[email protected] ~]# mysqladmin-u root-p password ' New Password '

This article is from the "Linux~dba~mba" blog, make sure to keep this source http://sky9896.blog.51cto.com/2330653/1605108

MySQL Server hypervisor mysqladmin command