Mysqladmin use format for tools:mysqladmin [option] command [command option] command ...Parameter options:-C Number Auto run count, must be used with-IHow long does the-I number interval repeat1, each two seconds to view the status of the server, a
mysqladminuse format for tool:mysqladmin [option] command [command option] command ...Parameter options:- C number Auto Run count, must and - I. used together How long does the-I number interval repeat0 ) View the status of the server every two
Mysqladmin use format for tools:mysqladmin [option] command [command option] command ...Parameter options:-C Number Auto run count, must be used with-IHow long does the-I number interval repeat0) Check the status of the server every two seconds and
Mysqladmin-help command Where command is a one or more of: (Commands may be shortened)
Create databasename Create a new database
Debug Instruct server to write debug information to log
Drop databasename Delete a database and all its
On the server where mysql is installed locally, open cmd and cd to the bin directory under the mysql installation directory. Multiple executable files can be seen in the bin directory, mysqladmin can be used to remotely close the mysql service.
The
Change Password:1. For example, your root user does not now have a password and you want the password to be changed to 123456, then the command is:Mysqladmin-u Root Password 1234562. If your root now has a password (123456), then the command to
Show MySQL status every two seconds, showing 5 times.# mysqladmin-uroot-p-I 2-c 5 statusTo view the running status of MySQL:#mysqladmin-uroot-p PingMysqladmin Ver 8.42 distrib 5.1.73, for Redhat-linux-gnu on x86_64Copyright (c) and/or, Oracle, its
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.