mysql忘记root密码怎么做
发布时间：2022-01-11 17:28:36 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要介绍了mysql忘记root密码怎么办，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。 1.关闭mysql 服务 点击(此处)折叠或打开 net stop mysql57 2.执行mysqld - 打开cmd窗口，切
|
这篇文章主要介绍了mysql忘记root密码怎么办，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。 1.关闭mysql 服务 点击(此处)折叠或打开 net stop mysql57 2.执行mysqld - 打开cmd窗口，切换至mysql安装目录 点击(此处)折叠或打开 cd C:Program FilesMySQLMySQL Server 5.7bin C:Program FilesMySQLMySQL Server 5.7bin>mysqld --defaults-file="C:ProgramDataMySQLMySQL Server 5.7my.ini" --skip-grant-tables 3.新开启cmd,登录root -不用输入password，直接回车 C:Program FilesMySQLMySQL Server 5.7bin>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 FilesMySQLMySQL Server 5.7bin>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) 感谢你能够认真阅读完这篇文章，希望小编分享的“mysql忘记root密码怎么办”这篇文章对大家有帮助。 （编辑：威海站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
