MySQL客户端mysqladmin命令
#1.设置密码
[root@db02 ~]# mysqladmin -uroot password
New password:
Confirm new password:
#2.修改密码
[root@db02 ~]# mysqladmin -uroot -p password
Enter password:
New password:
Confirm new password:
[root@db02 ~]# mysqladmin -uroot -p shutdown
Enter password: 123
[root@db02 ~]# mysqladmin -uroot -p123 create database222222
[root@db02 ~]# mysqladmin -uroot -p123 drop database222222
Warning: Using a password on the command line interface can be insecure.
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'database222222' database [y/N] y
Database "database222222" dropped
[root@db02 ~]# mysqladmin -uroot -p123 variables | grep -w server_id
[root@db02 ~]# mysqladmin -uroot -p ping
Enter password:
mysqld is alive
[root@db02 ~]# mysqladmin -uroot -p123 status
Warning: Using a password on the command line interface can be insecure.
Uptime: 130 Threads: 1 Questions: 94 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.723
Slow queries: 0
Queries per second avg: 0.723
[root@db02 ~]# mysqladmin -uroot -p123 reload
本文来自博客园,作者:六月OvO,转载请注明原文链接:https://www.cnblogs.com/chenlifan/p/13874966.html