MYSQL清空表,I...
2021-03-19
1、打开命令窗口:
mysql -uroot -p
2、输入密码登录
Enter password: ****
3、登录成功后
mysql> use mysql
4、Database changed
5、输入命令:
mysql> update user set password=password("rootnewpass") where user="root";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
6、mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
7、mysql> exit
2021-03-19
2021-09-30
2021-01-11
2021-01-11
2021-01-11
2021-06-27
2021-01-11
2021-01-11
评论