資源描述:
《mysql密碼丟失解決和密碼重置》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。
1、mysql密碼丟失解決和密碼重置(MySQLpasswordlossresolutionandpasswordreset)ThisMySQLisabitstrange,andsuddenlytheoriginalaccountcannotbelanded(specificreasonsareunknown,knowtotellme);sodecidedtomodifytheoriginalpassword.1.stopMySQL,andthenwithnoauthorizationtorestarttheMy
2、SQLcommand:Linux,/usr/local/mysql/bin/mysqld_safe&--skip-grant-tablesWindows,runX:/MySQL/bin/mysqld--skip-grant-tablesonthecommandline2.loginwithMySQL-u-rootundercommandline3.,modifythepasswordbar,ablogger(http://blog.chinaunix.net/u/29134/showart_373855.ht
3、ml)writingmethodismorecomplete,Iwillnotwordy.EitherofthethreemethodswilldoBeginnersofteneasyfanerrorinthiscause,cannotentertheMYSQL,thewholeverydepressed.Idobelievethatafewexamplessoonunderstood.1,theoriginalpasswordis123456C:>typemysql5.bat@echooffMySQL-u
4、root-p123456-P3306RighttomodifytheuserpasswordformatisMYSQL:WeuseithereUser:root(canbechangedtoother)Password:woshiduideTodemonstratethenewpassword.C:>mysqladmin-uroot-ppasswordwoshiduideEnterpassword:*Sothemodificationwassuccessful.Payattentiontothespaceb
5、ehindthePASSWORDkeywordAlotofpeoplehavechangedthisway:C:>mysqladmin-uroot-ppassword'woshiduide'Enterpassword:*C:>mysqladmin-uroot-ppassword'woshiduide'Enteratpassword:Warning:singlequoteswerenottrimmedfromthepasswordbyyourcommandLineclient,asyoumighthavee
6、xpected.Butthistimetherealpasswordis'woshiduide'C:>mysql-uroot-p'woshiduide'WelcometotheMySQLmonitor.Commandsendwith;org.YourMySQLconnectionIDis18Serverversion:5.1.17-beta-community-nt-debugMySQLCommunityServer(GPL)Type'help;or'h'forhelp.Type''c'toclear
7、thebuffer.Mysql>Andnovicesoftendo:C:>mysql-uroot-pwoshiduideERROR1045(28000):Accessdeniedforuser'root'@'localhost'(usingpassword:YES)Itisverydepressed,BAIDUandGOOGLEfoundalotof.I'llchangethecodebacknow.C:>mysqladmin-uroot-p'woshiduide'password1234562,ther
8、eisthatyoucanentertheMYSQLdirectly,andthenmodifythepassword.Mysql>useMySQLDatabasechangedMysql>updateusersetPASSWORD=PASSWORD('woshiduide')whereUSER='root'andHOST='localhost';QueryOK,1rowaffected(0.05s