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
I'll take a few examples and I'm sure I'll get it soon.1, the original password is 123456C:>type Mysql5.bat@echo offmysql-uroot-p123456-p3306The correct format for modifying the MySQL user password is:We use it here.User: root (can be replaced by
Mysqladmin-uroot-paixocmversion -- gt; Use mysqladmin to view the database version
Mysqladmin-uroot-paixocm version -- gt; Use mysqladmin to view the database version
Mysqladmin MySQL client management tool
Flush-hosts Flush all cached hosts
In general, forgetting the password is a new mysql novice friend. Let's show you how to use mysqadmin to change the password.
In general, forgetting the password is a new mysql novice friend. Let's show you how to use mysqadmin to change the
Use shell to write a script to monitor the running status of the mysql process and test whether mysql can be connected. If not, send an email and send an alarm. As for how to monitor, there are actually many commands. For example, most of the
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
Mysqladmin MySQL client management tool
Flush-hosts Flush all cached hosts (max_connect_errors)Refresh all information in host BufferFlush-logs Flush all logsRefresh all logsFlush-status Clear status variablesClear status variablesFlush-tables Flush
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
MysqladminMysql client management tools
Flush-hosts flush all cached hosts (max_connect_errors)Refresh all information in host BufferFlush-logs flush all logsRefresh all logsFlush-status clear status variablesClear status variablesFlush-tables
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.