æ¹æ³1ï¼ ç¨SET PASSWORDå½ä»¤
é¦å ç»å½MySQLã æ ¼å¼ï¼mysql> set password for ç¨æ·å@localhost = password(âæ°å¯ç â); ä¾åï¼mysql> set password for root@localhost = password(â123â);
æ¹æ³2ï¼ç¨mysqladmin
æ ¼å¼ï¼mysqladmin -uç¨æ·å -pæ§å¯ç password æ°å¯ç ä¾åï¼mysqladmin -uroot -p123456 password 123
æ¹æ³3ï¼ç¨UPDATEç´æ¥ç¼è¾user表
é¦å ç»å½MySQLã mysql> use mysql; mysql> update user set password=password(â123â) where user=ârootâ and host=âlocalhostâ; mysql> flush privileges;
æ¹æ³4ï¼å¨å¿è®°rootå¯ç çæ¶åï¼å¯ä»¥è¿æ · 以windows为ä¾ï¼
1. å ³éæ£å¨è¿è¡çMySQLæå¡ã 2. æå¼DOSçªå£ï¼è½¬å°mysql\binç®å½ã 3. è¾å ¥mysqld âskip-grant-tables å车ãâskip-grant-tables çæææ¯å¯å¨MySQLæå¡çæ¶åè·³è¿æé表认è¯ã 4. åå¼ä¸ä¸ªDOSçªå£ï¼å 为åæé£ä¸ªDOSçªå£å·²ç»ä¸è½å¨äºï¼ï¼è½¬å°mysql\binç®å½ã 5. è¾å ¥mysqlå车ï¼å¦ææåï¼å°åºç°MySQLæ示符 >ã 6. è¿æ¥æéæ°æ®åºï¼ use mysql; ã 6. æ¹å¯ç ï¼update user set password=password(â123â) where user=ârootâ;ï¼å«å¿äºæåå åå·ï¼ ã 7. å·æ°æéï¼å¿ é¡»æ¥éª¤ï¼ï¼flush privileges;ãã 8. éåº quitã 9. 注éç³»ç»ï¼åè¿å ¥ï¼ä½¿ç¨ç¨æ·årootååæ设置çæ°å¯ç 123ç»å½ã