资源描述：
《windows平台下如何修改mysql数据库密码（how to modify the mysql database password under the windows platform）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、windows平台下如何修改mysql数据库密码（HowtomodifytheMySQLdatabasepasswordunderthewindowsplatform）HowtomodifytheMySQLdatabasepasswordunderthewindowsplatformThefirstthingtodeclareisthatinmostcases,modifyingMySQLrequiresrootprivilegesinmysql,Sotheaverageusercannotchangethepasswordunlesstheadministratorisre
2、quested.MethodoneUsingphpMyAdmin,thisistheeasiesttomodifytheusertablesoftheMySQLlibrary,Butdon'tforgettousethePASSWORDfunction.MethodtwoUsingmysqladmin,thisisaspecialcasethatwaspreviouslydeclared.Mysqladmin,-u,root,-p,password,mypasswdSuchas:D:Mysqlbin>mysqladmin,-u,root,-p,password,admin
3、Enterpassword:(enteryourpasswordhere)Afterenteringthiscommand,youneedtoentertheoriginalpasswordforroot,andthenthepasswordforrootwillbechangedtomypasswd.Changetherootinthecommandtoyourusername,soyoucanchangeyourownpassword.Ofcourse,ifyourmysqladmindoesn'tconnecttoMySQLserver,oryoucan'texecut
4、emysqladmin,Thenthismethodisinvalid.Andmysqladmincan'temptythepassword.ThefollowingmethodsareusedattheMySQLpromptandmusthaveMySQLpermissionsforroot:MethodthreeMysql>,Insert,INTO,mysql.user(Host,User,Password)VALUES(%,'jeffrey',PASSWORD('biscuit'));Mysql>FLUSHPRIVILEGESTobeexact,thisisadding
5、auserwhoseusernameisJeffreyandthepasswordisbiscuit.IntheMySQLChinesereferencemanual,thereisthisexample,soIwroteitout.NotethatyouusethePASSWORDfunction,andthenusetheFLUSHPRIVILEGES.MethodfourAndmethod31,justusetheREPLACEstatementMysql>,REPLACE,INTO,mysql.user(Host,User,Password)VALUES(%,'jef
6、frey',PASSWORD('biscuit'));Mysql>FLUSHPRIVILEGESMethodfiveUsingtheSETPASSWORDstatement,Mysql>,SET,PASSWORD,FOR,jeffrey@,%=PASSWORD('biscuit');ItisalsonecessarytousethePASSWORD()function,Butyoudon'tneedtouseFLUSHPRIVILEGES.MethodsixUsingtheGRANT...IDENTIFIEDBYstatementMysql>GRANTUSAGEONTOjef
7、frey@.*"%"IDENTIFIEDBY'biscuit';ThePASSWORD()functionisnotnecessaryhere,nordoesitrequiretheuseofFLUSHPRIVILEGES.Note:PASSWORD()[not]appliespasswordencryptioninthesamewaythattheUnixpasswordisencrypted.MySQL'ssolutiontoaforgottenpasswordIfMySQLisrunning,ki
