1.关闭mysql 服务
点击(此处)折叠或打开
- net stop mysql57
2.执行mysqld
- 打开cmd窗口,切换至mysql安装目录
点击(此处)折叠或打开
- cd C:\Program Files\MySQL\MySQL Server 5.7\bin
- C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --skip-grant-tables
3.新开启cmd,登录root
-不用输入password,直接回车
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
Enter password:
4.修改root密码
点击(此处)折叠或打开
- mysql> use mysql;
- Database changed
- mysql> update mysql.user set authentication_string=password('root') where user='root' ;
- Query OK, 1 row affected, 1 warning (0.01 sec)
- Rows matched: 1 Changed: 1 Warnings: 1
- mysql> flush privileges;
- Query OK, 0 rows affected (0.02 sec)
5.使用新密码登录root
点击(此处)折叠或打开
- C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
- Enter password: ****
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 6
- Server version: 5.7.19 MySQL Community Server (GPL)
- Copyright (c) 2000, 2017, 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 database;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
- corresponds to your MySQL server version for the right syntax to use near 'datab
- ase' at line 1
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | fortress |
- | mysql |
- | performance_schema |
- | python |
- | stuman |
- | stuman2 |
- | sys |
- | www |
- +--------------------+
- 9 rows in set (0.00 sec)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15412087/viewspace-2151346/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15412087/viewspace-2151346/