转ï¼
æ¹æ³ä¸ä½¿ç¨phpmyadminï¼è¿æ¯æç®åçäºï¼ä¿®æ¹mysqlåºçuserè¡¨ï¼ ä¸è¿å«å¿äºä½¿ç¨passwordå½æ°ã
æ¹æ³äºä½¿ç¨mysqladminï¼è¿æ¯åé¢å£°æçä¸ä¸ªç¹ä¾ã mysqladmin -u root -p password mypasswd è¾å
¥è¿ä¸ªå½ä»¤åï¼éè¦è¾å
¥rootçåå¯ç ï¼ç¶årootçå¯ç å°æ¹ä¸ºmypasswdãæå½ä»¤éçrootæ¹ä¸ºä½ çç¨æ·åï¼ä½ å°±å¯ä»¥æ¹ä½ èªå·±çå¯ç äºã å½ç¶å¦æä½ çmysqladminè¿æ¥ä¸ä¸mysql serverï¼æè
ä½ æ²¡æåæ³æ§è¡mysqladminï¼ é£ä¹è¿ç§æ¹æ³å°±æ¯æ æçã èä¸mysqladminæ æ³æå¯ç æ¸
空ãä¸é¢çæ¹æ³é½å¨mysqlæ示符ä¸ä½¿ç¨ï¼ä¸å¿
é¡»æmysqlçrootæéï¼
æ¹æ³ä¸ mysql INSERT INto mysql.user (Host,User,password) VALUES('%','jeffrey',password('biscuit')); mysql FLUSH PRIVILEGES ç¡®åå°è¯´è¿æ¯å¨å¢å ä¸ä¸ªç¨æ·ï¼ç¨æ·å为jeffreyï¼å¯ç 为biscuitã å¨ãmysqlä¸æåèæåãéæè¿ä¸ªä¾åï¼æ以æä¹å°±ååºæ¥äºã注æè¦ä½¿ç¨passwordå½æ°ï¼ç¶åè¿è¦ä½¿ç¨FLUSH PRIVILEGESã
æ¹æ³å åæ¹æ³ä¸ä¸æ ·ï¼åªæ¯ä½¿ç¨äºreplaceè¯å¥ mysql replace INto mysql.user (Host,User,password) VALUES('%','jeffrey',password('biscuit')); mysql FLUSH PRIVILEGES
æ¹æ³äº 使ç¨set passwordè¯å¥ï¼ mysql set password for jeffrey@% = password('biscuit'); ä½ ä¹å¿
须使ç¨password()å½æ°ï¼ ä½æ¯ä¸éè¦ä½¿ç¨FLUSH PRIVILEGESã
æ¹æ³å
使ç¨grant ... IDENTIFIED byè¯å¥ mysql grant USAGE on *.* to jeffrey@% IDENTIFIED by 'biscuit'; è¿éPASSWORD()å½æ°æ¯ä¸å¿
è¦çï¼ä¹ä¸éè¦ä½¿ç¨FLUSH PRIVILEGESã注æï¼ PASSWORD() [ä¸æ¯]以å¨Unixå£ä»¤å å¯çåæ ·æ¹æ³æ½è¡å£ä»¤å å¯ãuse mysql
ããupdate user set Password=password('newpassword') where User='root';
ããflush privileges;
ãã1.éè¿ä¿®æ¹MYSQLæ°æ®åºä¸MYSQLåºçUSER表
ãã å°±ç¨æ®éçUPDATEãINSERTè¯å¥å°±å¯ä»¥
ãã2.å¨å½ä»¤è¡ä¸ä½¿ç¨å¦ä¸å½ä»¤
ãã MYSQLADMIN -u root -p PASSWORD mypasswd
ãã3.å¯ä»¥ä¿®æ¹MYSQLæ件夹ä¸çMY.INIæ件
ãã4.使ç¨SET PASSWORDè¯å¥ï¼
ããmysql SET PASSWORD FOR myuser@localhost = PASSWORD('mypasswd');
温馨提示:答案为网友推荐,仅供参考