[TOC] #### 1. 使用 `alter user` 命令修改密码 --- ```sql ALTER USER root@'localhost' IDENTIFIED BY '123456'; ``` #### 2. 使用 `set password for` 命令修改密码 --- ```sql set password for root@localhost = '123456'; ``` 已弃用的方法 ``` set password for 用户名@localhost = password('新密码'); ``` ```sql set password for root@localhost = password('123456'); ``` #### 3. 使用 `mysqladmin` 命令修改密码 --- **命令格式** ```sql mysqladmin -u用户名 -p[密码] password [新密码] ``` **示例一:输入当前密码、新密码、确认新密码** ```sql mysqladmin -uroot -p password ``` ![](https://img.itqaq.com/art/content/69ddf43e2c8bb3692e25ec049627785f.png) **示例二:新密码写在命令中** ![](https://img.itqaq.com/art/content/f570d4f2215cd6c5e7035dfeca6b14c9.png) **示例三:当前密码和新密码都写在命令中,一步到位** ![](https://img.itqaq.com/art/content/b8720235148c4031ec7c8d338219c764.png) **mysqladmin: [Warning] Using a password on the command line interface can be insecure.** mysqladmin:[警告]在命令行界面上使用密码可能不安全。 **Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.** 警告:由于密码将以明文形式发送到服务器,请使用ssl连接以确保密码安全。 #### 4. 设置密码为空密码 --- mysqladmin 命令中设置新密码为空密码时,直接回车即可 特别注意:在命令行中设定空密码是有问题的 `password ''` 新密码实际是 `'` ![](https://img.itqaq.com/art/content/94a2cf6e99da7e104d67f18eb8cbdfc1.png)