The editor below will bring you a summary of the daily management commands of mysqladmin under mysql (a must-read article). The editor thinks it is quite good, so I will share it with you now and give it as a reference for everyone. Let’s follow the editor and take a look.
Mysqladmin tool usage format:
mysqladmin [option] command [command option] command ......
Parameter options:
-c number Statistics of automatic running times, must be used together with -i
-i number How long is the interval between repeated executions
0) Each two Check the status of the server once every second, repeating 5 times in total.
[root@test-huanqiu ~]# mysqladmin -uroot -p -i 2 -c 5 status
1) Check the status of the server: status
[root@test-huanqiu ~]# mysqladmin -uroot -p status
2) Modify the root password:
[root@test-huanqiu ~]# mysqladmin -u root -p原密码 password 'newpassword'
3) Check whether mysqlserver is available:
[root@test-huanqiu ~]# mysqladmin -uroot -p ping
4) Query Server version
[root@test-huanqiu ~]# mysqladmin -uroot -p version
5) View the current value of the server status:
[root@test-huanqiu ~]# mysqladmin -uroot -p extended-status
6) Query the server System variables Value:
[root@test-huanqiu ~]# mysqladmin -uroot -p variables
7) Display all running processes on the server:
[root@test-huanqiu ~]# mysqladmin -uroot -p process list [root@test-huanqiu ~]# mysqladmin -uroot -p-i 1 processlist //每秒刷新一次
[root@test-huanqiu ~]# mysqladmin -uroot -p create daba-test
9)Display all databases on the server
[root@test-huanqiu ~]# mysqlshow -uroot -p
10) Display the tables under the database daba-test:
[root@test-huanqiu ~]# mysqlshow -uroot -p daba-test
11) Statistics of the summary of database table columns under daba-test
[root@test-huanqiu ~]# mysqlshow -uroot -p daba-test -v
12) Statistics of the number of columns and rows of the database table under daba-test
[root@test-huanqiu ~]# mysqlshow -uroot -p daba-test -v -v
13) Delete database daba-test
[root@test-huanqiu ~]# mysqladmin -uroot -p drop daba-test
14)ReloadPermission information
[root@test-huanqiu ~]# mysqladmin -uroot -p reload
15) Refresh all tablescache, and close and open log
[root@test-huanqiu ~]# mysqladmin -uroot -p refresh
16) Use safe modeClose the database
[root@test-huanqiu ~]# mysqladmin -uroot -p shutdown
17) Refresh commands mysqladmin flush commands
[root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-hosts [root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-logs [root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-privileges [root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-status [root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-tables [root@test-huanqiu ~]# mysqladmin -u root -ptmppassword flush-threads
18) mysqladmin executes the kill process :
[root@test-huanqiu ~]# mysqladmin -uroot -p processlist [root@test-huanqiu ~]# mysqladmin -uroot -p kill idnum
19) Stop and start MySQL replication on a slave server
[root@test-huanqiu ~]# mysqladmin -u root -p s top -slave [root@test-huanqiu ~]# mysqladmin -u root -p start-slave
20) Execute multiple at the same time Command
[root@test-huanqiu ~]# mysqladmin -u root -p process status version
The above is the detailed content of Code sharing of daily management commands of mysqladmin under mysql. For more information, please follow other related articles on the PHP Chinese website!