MySQL修改root⽤户密码
三种修改root⽤户密码的⽅式:
如何更改宽带密码⽅法⼀: 使⽤set password命令
⾸先登录MySQL，使⽤mysql⾃带的客户端连接mysql，命令如:mysql -uroot -p
会提⽰你输⼊当前root密码，默认为空，直接回车就可以了.
格式: mysql> set password for ⽤户名@localhost=password('新密码');
例⼦: mysql> set password for root@localhost=password('666');
这⾥password('666')中的password会⾃动进⾏加密.
⽅法⼆：使⽤mysqladmin 执⾏管理操作的客户端程序
格式: C:\Users\Administrator>mysqladmin -u⽤户名 -p旧密码 password 新密码
例⼦: C:\Users\Administrator>mysqladmin -uroot -p666 password 新密码(也可以不输⼊，直接回车，提⽰的时候再输⼊，这样会安全些，别⼈⽆法通过dos下的doskey/history查看到你的新密码)
如下⾯的例⼦中的Warning: Using a password on the command line interface can be insecure. 就是安全提⽰
C:\Users\Administrator>mysqladmin -uroot -p666 password
Warning: Using a password on the command line interface can be insecure.
何韵诗歌曲New password: ***
Confirm new password: ***
C:\Users\Administrator>doskey/history (查看历史记录命令)
mysql -uroot -p
mysqladmin -uroot -p666 password
doskey/history
⽅法三: update直接修改mysql库中的user表
佟丽娅老公张煜枫mysql> update user set password=password('888') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 3  Changed: 2  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
----------------------------------------------------------------忘记root密码，怎么办?----------------------------------------------------------------
这⾥需要重启mysqld服务端
C:\Users\Administrator>net stop mysqld
mysqld 服务正在停⽌.
mysqld 服务已成功停⽌。
C:\Users\Administrator>mysqld --skip-grant-tables  (跳过⽤户认证权限表)
2019-06-18 10:54:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2019-06-18 10:54:24 0 [Note] --secure-file-priv is set to NULL. Operations relat
ed to importing and exporting data are disabled
2019-06-18 10:54:24 0 [Note] mysqld (mysqld 5.6.44) starting as process 2004 ...
重新打开⼀个dos窗⼝
C:\Users\Administrator>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.44 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| mysql              |
| oldboydb          |
| performance_schema |
| test              |
火锅连锁
+--------------------+
5 rows in set (0.01 sec)
mysql> use mysql;
Database changed
mysql> update user set password=password('666') where user='root'; Query OK, 0 rows affected (0.00 sec)
Rows matched: 3  Changed: 0  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
李军 陈红
mysql> quit;
Bye
C:\Users\Administrator>tasklist | findstr mysql
福建旅游景点推荐
<                    2004 Console                    1    454,756 K
C:\Users\Administrator>taskkill /F /PID 2004
成功: 已终⽌ PID 为 2004 的进程。
C:\Users\Administrator>net start mysqld
mysqld 服务正在启动 .
mysqld 服务已经启动成功。