mysql数据库密码修改！方便修改密码，不在为忘记密码而烦恼！
20169 mysq数据库忘记密码时如何修改_百度经验 管理员: WINdows\system32 cmd.exe-myo Server version: 5. 6. 17 ySQL Conmunity Server(GPL) opyright (c)2000, 2014, Oracle and/or its affiliates. All rights reserved. racle is a registered trademark of Oracle Corporation and/or its affiliates. Other names nay be trademarks of their respective 次直接国 owners, Type'help; 'or 'th' for help. Type '\e to clear the current input statement. sql show databases Database information_ schena mysql neU performance schema te园t 7 rous in set (0. 09 sec) mysql> Bai 6.6 其中mysq1库就是保存用户名的地方。输入 use mysql;选择mysq1数据库 I Ewamp\bin\mysqlymysq l56.17\bin\mysqlLexe too Database infornation schema t bb bitch boo lay creasy dedecms performance_ schema I test rous in set (0.07 sec) mysql> use ysql: Database changed you Bai 经验 ingan baidu. com show tables查看所有表,会发现有个user表,这里存放的就是用户名,密码,权限等等账户信息。 http://jinGyan.baidu.com/article/454316ab4e9e65f7a/c03ad1.html 3/7 20169 mysq数据库忘记密码时如何修改_百度经验 D E\wamplbinlmysal\ 5.6.17.exe ysql> show tables; Tables_in_mysql columns. pr⊥v db event func general_log he lp_category he lp ke word help re lation help_topic innodb index stats innodb table stats ndb bin log_ index plug in proc procs- prev proxies_priv servers slave naster info slave_ relay_ log_ info s lave worker info s low_log tables priv time zone time_ zone_ leap_ second time_ zone_name time zone transition time zone transition-type user 8 rows in set <0. 00 sec) mysqL> Baid经验 jingyanbaidu.com 输入 select user,host, password from user;来查看账户信息。 言理员:C: \Windows\ system32 cmd.exe- mysql time zone transition time_zone transi tion type user 28 rowe in set (o o1 see) mysql> select username, host, password from user ERROR 1054(42522): Unknowm column ', in'field list L ysql> select user, host, password fron user user password root localhost root127.0.0.1 ot::1 localhost root|6o.168.68.2|*Bs4837EB74329105EE4568DD7DC67ED2cA2Ang rows in set (o oo sec) ysql> Ba尚经 tingyan baidu. c 9. http://jinGyan.baidu.com/article/454316ab4e9e65f7a/c03ad1.html 47 20169 mysq数据库忘记密码时如何修改_百度经验 更改root密码,输入 update user set password= password('123456’) where user='root’and host= loca lhost 医管理员 WINdows\systen32 cmd. exe-myq c user I host asso d root localhost root127,0.0,1 root 1 localhost root|6o.16.68.2|*Bb4837E74329105EE4568 DDATDO6TED2CA2A9 rows in set (o 0o sec) sql> update user set password=password 123456)where user='root and host uery OK, 1 row affected(o 15 sec) ows matched: 1 Changed: 1 Warnings: o sql> Bad经 10.10 再次查看账户信息, select user,host; password from user;可以看到密码已被修改 西曾理员: WINdows\system32 cmd.exe-mysql root127.0.0.1 root:: 1 localhost root|6o.168.88.2|6BB4837E74329105EE4568DDA7DoG7ED2A2AD 5 rows in set (0. oo sec) mysql> update user set password=password(123456)where usera'rootand host= localhost ery OK, 1 row affected (0. 15 sec) Rows matched: 1 Changed: 1 Warnings: o mysql> select user, host, password fron user user I host password x° ot localhost *6BB4837EB74329105EE4568DDA7DOS7ED2CA2AD9 root|127.0.0.1 root∷ localhost root|6.168.68.2|B4837E74329105E4568DA7DTED2CA2An9 5 rows in set(o oo sec) 2q1 Bad经 11.11 退出命令行,重启mysq1数据库,用新密码尝试登录 http://jinGyan.baidu.com/article/454316ab4e9e65f7a/c03ad1.html 5/7 20169 mysq数据库忘记密码时如何修改_百度经验 管理员:令提示符· mysql -uroot-p123456 crosoft wande[版本6.1,7601 版权所有(c)200" icrosoft Corporation。保留所有权利。 \Users\Adninistrator>d D: \ed D: \warp\bin \mysql\nysq15 6. 17\bin D: wamp \bin \mysql \ysq15 6 17\bin> p: wamp \bin\mysql\mysql5. 6.17\bin mysql -uroot"p123456 arning: Using a password on the command line interface can be insecure 用新密 elcome to the Ny SQL monitor. Commands end with: or our MysQL connection id is 2 erver version: 5.6. 17 My SQL Community Server (GPL) opyright (c)2000, 2014, Oracle and/or its affiliates. All rights reserved. oracle is a registered trademark of Oracle Corporation and/or its ffiliates, other names may be trademarks of their respective overs. Type help: or\h for help. Type"\e to clear the current input statement Bai jingyan. bai 12.12 测试不带密码登录 mysql,发现还是能够登陆上,但显示数据库时只能看到两个数据库了,说明重启之后跳过 密码验证已经被取消了 四理员 C:Windows\system32\cmd. D:\>ed D: \wamp\binmysql\mysql5. 6. 17\bin D: \wan\bin\mysql \nysq156 17\binmysql Welcone to the My SQL monitor. Commands end with: or ke. Your Jy SQL connection id is 1 Server version: 5.6. 17 IySQL Comnunity Server (GPL) opyright (c)2000, 2014, 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 ome s. Type'help; 'or'wh' for help. Type '\e' to clear the current input statement. mysql> show databases Database information schena test rovs in set(o oo sec) Ba经 我这地方重启数据库之后之所以不带密码任然能够登录是因为我的数据斥里存在设无须口令的账户。 http://jinGyan.baidu.com/article/454316ab4e9e65f7a/c03ad1.html 6/7 20169 mysq数据库忘记密码时如何修改百度经验 shttp:inganbaidu.com/edit/contentatypeadraftadid= 西管理员: CAWindows\system32 cmd.exe- mysql -uroot-p Server version: 5. 6. 17 MySQL Comnunity Server (GPL) opyright (c)2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other nanes nay be trademarks of their respective owners Type help: ' or 'Wh for help. Type '\c' to clear the current input statement. 是能 ysql) use mysql 中证E Database changed ysql> select user, host, password fron user usbhost password roet1。 calmest *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 xoot127.0.0.1 localhost root 60. 168.68.2*6BB4837EB74329105EE4568DDAYDC5YED2CA2AD9 5 rows in set (0. 00 sec) 下带壁 注意事项 注意其中需要重启数据库的几个地方 经验内容仅供参考,如果您需解决具体问题(尤其法律、医学等领域),建议您详细咨询相关领域专业人士, http://jinGyan.baidu.com/article/454316ab4e9e65f7a/c03ad1.html 77