macä¸mysql rootå¯ç å¿è®°ææéé误ç解å³åæ³
1ï¼è£
mysql workbench ãå¯è§åçé¢ç´æ¥æä½ã
2ï¼è¹æ->ç³»ç»å好设置->æä¸è¾¹ç¹mysql å¨å¼¹åºé¡µé¢ä¸ å
³émysqlæå¡
3ï¼è¿å
¥ç»ç«¯
è¾å
¥ï¼
cd /usr/local/mysql/bin/
å车å ç»å½ç®¡çåæé
sudo su
å车åè¾å
¥ä»¥ä¸å½ä»¤æ¥ç¦æ¢mysqléªè¯åè½
./mysqld_safe --skip-grant-tables &
å车åmysqlä¼èªå¨éå¯ï¼éå¯å¥½äºä¹åè¿å
¥mysql workbench é便å建ä¸ä¸ªè¿æ¥ï¼ç¶åç¨æ·åå¡«root ï¼æ³¨æè¿éä¸ä¼éªè¯å¯ç ï¼æ以填åªè¦åå¨çè´¦æ·å°±å¯ä»¥ï¼ã
åå建ä¸ä¸ªserver administrationï¼éæ©åå建çè¿æ¥ã
åå»server administration
左侧ç¹å»securityï¼å³ä¾§å°±å¯ä»¥çå°ææç¨æ·æé表äºï¼è¿ä¸ªæ¶åæ³æä¹å¹²é½è¡äº
以ä¸æ¯é¨å说æï¼
ç¨æ·æé表ä¸
Limit Connectivity to Hosts Matching 表示ç»å½å°åéå¶ï¼å°±æ¯ç»å½æ¶åçipå°å ï¼â%â代表任æ
Adminstrative Rolesæ¯æéï¼å¦æåç°ä½ çroot没æ管çåæéäºï¼å°±ç¹è¿ä¸ªé项å¡å
¨é¨å¾é
以ä¸æ¯å
¶ä»å½ä»¤
./mysqladmin -u root -p password 123 //æ´æ¹rootç¨æ·å¯ç
./mysql -uroot -p //rootç¨æ·ç»å½mysql
以ä¸æ¯å¸¸è§é误
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
说æä½ çrootæéä¸å¤ï¼å°±å¯ä»¥åèä¸é¢çæ¥éª¤è®¾ç½®æé
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
说æä½ çrootæéä¸å¤ï¼å°±å¯ä»¥åèä¸é¢çæ¥éª¤è®¾ç½®æé
温馨提示:答案为网友推荐,仅供参考