mysql admin_MySQL管理工具 mysqladmin

修改用户密码：

[root@db02 ~]# mysql -uroot -p123 -e 'select user,host,password from mysql.user'

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

| user | host | password |

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

| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

| root | 127.0.0.1 | |

| root | 10.0.0.% | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

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

修改密码为123456

[root@db02 ~]# mysqladmin -uroot -p123 password '123456'

Warning: Using a password on the command line interface can be insecure.

# 提示错误，密码不符合

[root@db02 ~]# mysql -uroot -p123 -e 'select user,host,password from mysql.user'

Warning: Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

# 使用修改后的密码

[root@db02 ~]# mysql -uroot -p123456 -e 'select user,host,password from mysql.user'

Warning: Using a password on the command line interface can be insecure.

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

| user | host | password |

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

| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| root | 127.0.0.1 | |

| root | 10.0.0.% | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |

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