如题所述
è¿ä¸ªé®é¢æ¯è¯´ä½ è¿æ¥mysqlçæ¶å没æå¡«åå¯ç ï¼
ç½é¡µä¸è¿ä¸ä¸ï¼é£åºè¯¥æ¯ä½ é ç½®æ件ä¸ç设å®ä¸ MySQL é»è®¤æéè´¦æ·(没æå¯ç ç root)ä¸å¯¹åºé æçã
å¨phpMyAdminä¸ï¼ä½¿ç¨æ件config.inc.phpä¿åç¨æ·ååå¯ç ï¼å½éè¦æ´æ¢ç¨æ·æç¨æ·å£ä»¤æ´æ¹æ¶ï¼å¿ 须修æ¹config.inc.phpæ件ï¼ç¶ååä¸ä¼ ãä½ å»æ´æ¹ä¸é ç½®æ件 è¯è¯æã
æ¹æ³ä¸ï¼
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(ânewpasswordâ) where USER=ârootâ;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <è¾å ¥æ°è®¾çå¯ç newpassword>
mysql>
æ¹æ³äºï¼
ç´æ¥ä½¿ç¨/etc/mysql/debian.cnfæ件ä¸[client]èæä¾çç¨æ·ååå¯ç :
# mysql -udebian-sys-maint -p
Enter password: <è¾å ¥[client]èçå¯ç >
mysql> UPDATE user SET Password=PASSWORD(ânewpasswordâ) where USER=ârootâ;
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <è¾å ¥æ°è®¾çå¯ç newpassword>
mysql>
å¦ä¸ä¸ªæ¹æ³
Windows:
1. 管çåç»éç³»ç»,åæ¢mysqlæå¡æè ç»æmysqld-ntè¿ç¨
2. è¿å ¥å½ä»¤è¡,æ¥å°mysqlçå®è£ ç®å½.å设å®è£ ç®å½ä¸º d:\mysql\ , CMDè¿å ¥å½ä»¤è¡
3. è¿è¡ d:\mysql\bin\mysqld-nt --skip-grant-tables å¯å¨mysql,å ³éæéçæ£æ¥
4. è¿è¡ d:\mysql\bin\mysqladmin -u root flush-privileges password "newpassword" é设rootå¯ç
5. éæ°å¯å¨mysqlæå¡
ç½é¡µä¸è¿ä¸ä¸ï¼é£åºè¯¥æ¯ä½ é ç½®æ件ä¸ç设å®ä¸ MySQL é»è®¤æéè´¦æ·(没æå¯ç ç root)ä¸å¯¹åºé æçã
å¨phpMyAdminä¸ï¼ä½¿ç¨æ件config.inc.phpä¿åç¨æ·ååå¯ç ï¼å½éè¦æ´æ¢ç¨æ·æç¨æ·å£ä»¤æ´æ¹æ¶ï¼å¿ 须修æ¹config.inc.phpæ件ï¼ç¶ååä¸ä¼ ãä½ å»æ´æ¹ä¸é ç½®æ件 è¯è¯æã
æ¹æ³ä¸ï¼
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(ânewpasswordâ) where USER=ârootâ;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <è¾å ¥æ°è®¾çå¯ç newpassword>
mysql>
æ¹æ³äºï¼
ç´æ¥ä½¿ç¨/etc/mysql/debian.cnfæ件ä¸[client]èæä¾çç¨æ·ååå¯ç :
# mysql -udebian-sys-maint -p
Enter password: <è¾å ¥[client]èçå¯ç >
mysql> UPDATE user SET Password=PASSWORD(ânewpasswordâ) where USER=ârootâ;
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <è¾å ¥æ°è®¾çå¯ç newpassword>
mysql>
å¦ä¸ä¸ªæ¹æ³
Windows:
1. 管çåç»éç³»ç»,åæ¢mysqlæå¡æè ç»æmysqld-ntè¿ç¨
2. è¿å ¥å½ä»¤è¡,æ¥å°mysqlçå®è£ ç®å½.å设å®è£ ç®å½ä¸º d:\mysql\ , CMDè¿å ¥å½ä»¤è¡
3. è¿è¡ d:\mysql\bin\mysqld-nt --skip-grant-tables å¯å¨mysql,å ³éæéçæ£æ¥
4. è¿è¡ d:\mysql\bin\mysqladmin -u root flush-privileges password "newpassword" é设rootå¯ç
5. éæ°å¯å¨mysqlæå¡
温馨提示:答案为网友推荐,仅供参考