æ¹æ³ä¸
使ç¨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å£ä»¤å å¯çåæ ·æ¹æ³æ½è¡å£ä»¤å å¯ã
MySQL å¿è®°å£ä»¤ç解å³åæ³
å¦æ MySQL æ£å¨è¿è¡ï¼é¦å
æä¹ï¼ killall -TERM mysqldã
å¯å¨ MySQL ï¼bin/safe_mysqld --skip-grant-tables &
å°±å¯ä»¥ä¸éè¦å¯ç å°±è¿å
¥ MySQL äºã
ç¶åå°±æ¯
>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
éæ°æ MySQL ï¼ç¨æ£å¸¸æ¹æ³å¯å¨ MySQL ã
温馨提示:答案为网友推荐,仅供参考