cmdä¸åæ¢å° mysql å®è£
ç®å½
ä¾
d:/mysql/bin
åæï¼mysqlç¨æ·rootå¯ç 为空.
è¾å
¥ mysql -u root mysql
mysql> ç¶æä¸è¾å
¥ update user set password=password('æ°å¯ç ') where user='root';
åæ¾
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> ç¶æä¸è¾å
¥ FLUSH PRIVILEGES;
åæ¾
Query OK, 0 rows affected (0.00 sec)
mysql> ç¶æä¸è¾å
¥ quit
éåº sql
注ææ¯ä¸ªå½ä»¤åé½è¦å ä¸ä¸ä¸ªåå· ";"
mysql æå¼å§æ§è¡è¯¥è¡å½ä»¤
è第äºä¸ªæ令ä¼è®©å·²è½½å
¥è®°å¿ä½ç mysql ç³»ç»èµæåºæ´æ°
éèµ· mysql .
å¨æ´æ° root å¯ç å¾ï¼æ¥å¾è¦ä¸ MySQL è¿çº¿çæ¹æ³ä¸ºï¼
mysql -uroot -pæ°å¯ç
é¦å
è¦å£°æä¸ç¹ï¼å¤§é¨åæ
åµä¸ï¼ä¿®æ¹MySQLæ¯éè¦æmysqléçrootæéçï¼æ以ä¸è¬ç¨æ·æ æ³æ´æ¹å¯ç ï¼é¤é请æ±ç®¡çåã
æ¹æ³ä¸
使ç¨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( iscuit));
mysql> FLUSH PRIVILEGES
ç¡®åå°è¯´è¿æ¯å¨å¢å ä¸ä¸ªç¨æ·ï¼ç¨æ·å为jeffreyï¼å¯ç 为biscuitã
å¨ãmysqlä¸æåèæåãéæè¿ä¸ªä¾åï¼æ以æä¹å°±ååºæ¥äºã
注æè¦ä½¿ç¨PASSWORDå½æ°ï¼ç¶åè¿è¦ä½¿ç¨FLUSH PRIVILEGESã
æ¹æ³å
åæ¹æ³ä¸ä¸æ ·ï¼åªæ¯ä½¿ç¨äºREPLACEè¯å¥
mysql> REPLACE INTO mysql.user (Host,User,Password)
VALUES(\%,jeffrey,PASSWORD( iscuit));
mysql> FLUSH PRIVILEGES
æ¹æ³äº
使ç¨SET PASSWORDè¯å¥ï¼
mysql> SET PASSWORD FOR jeffrey@"%" = PASSWORD( iscuit);
ä½ ä¹å¿
须使ç¨PASSWORD()å½æ°ï¼
ä½æ¯ä¸éè¦ä½¿ç¨FLUSH PRIVILEGESã
æ¹æ³å
使ç¨GRANT ... IDENTIFIED BYè¯å¥
mysql> GRANT USAGE ON *.* TO jeffrey@"%" IDENTIFIED BY iscuit;
è¿éPASSWORD()å½æ°æ¯ä¸å¿
è¦çï¼ä¹ä¸éè¦ä½¿ç¨FLUSH PRIVILEGESã
注æï¼ PASSWORD() [ä¸æ¯]以å¨Unixå£ä»¤å å¯çåæ ·æ¹æ³æ½è¡å£ä»¤å å¯ã
温馨提示:答案为网友推荐,仅供参考