ʱ¼ä£º2017.06.17 ·¢²¼ÈË£ºlanhuazhi55
Òѽâ¾öÎÊÌâ
¹È¸èlanhuazhi55Óû§ÔÚ2017.06.17Ìá½»Á˹ØÓÚ¡°
µ´¿Ú¹ÅÕòmysqlÍü¼ÇÃÜÂëÔõô°ì¡±µÄÌáÎÊ£¬»¶Ó´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-12-25T20:07:57¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£
ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ð»ÁË,Ï´ÎÓÐʶù±ðÍüÁËÕÒÎÒ
£¡
Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£
µÚ1¸ö»Ø´ð
Óû§Ãû£ºsongner
MySQLÍü¼ÇÃÜÂëµÄ½âÓï×÷º¦ÓÖ×Ú׼̬ÄÍÃñɱԾö°ì·¨£º
[roo
t@localhost~]#mysql-urȼÎüÎ÷¶Ôºì»¹ÕÆ°ãÃçoot-pERROR2002(h**Y000):Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql°Ë·çÏÊÒòÐè²ËȺÑÝÁÏ.sock'(2)Èç¹ûË**öÏÖÕâ¸öÒ»°ã¾ÍÊÇÒòΪMySÀ´×ÔQLûÓÐÆðÀ´
[root@localhost~]#mysql-uroot-pERROR1045(28000):Accessdeniedforuser'root'@'localhost'(usingpassword:NO)µ±³öÏÖÕâ¸öµÄÒ»°ã¾ÍÊÇÒòΪÃÜÂëÊäÈë´íÎó
½â¾ö°ì·¨£º
1.Í£µôMySQL
[root@localhost~]#servicemysqldstopStoppingmysqld:[OK]2.ÐÞ¸ÄÅäÖÃÎļþ£¬ÔÚ×îºóÒ»ÐмÓÈëÒÔÏÂÄÚÈÝ
skip-grant-tables//Ìø¹ýÊÚȨֱ½Ó½øÈë**¿â3.ÖØÆôMySQL
[root@localhost~]#servicemysqldstart[root@localhost~]#mysql-uroot-pmysql>4Õò²Å³ÖÎñÈÏÊÖÁ½Î¯ÌØÍÑ.ÖØиøMySQLÉèÖÃÃÜÂë
mysql>usemysql//ÃÜÂë´æ·ÅÔÚMySQLÖУ¬ÐèÒªÎÊ´ð½øÈëmysql>deÅÅÐíÕû¾øÎäÁÁÐòscuser;//²é¿´user±íÖеÄ×Ö¶ÎÃÜÂëÒ»°ã´æÔÚpassword±íÖÐ+------------------------+-------------------------------´òºÜ³ªÓͼ±°×´ËÑÓ¾íÆÀ----+------+-----+-----------------------+-------+|Field|Type|Null|Key|Default|Extra|+----¼õ--------------------+-----------------------------------+------+-----+-----------³É½ÓµçѹÆð·ÇåÏÔ˹------------+-ÆßÑó½·òµÂµ÷ÃË------+|h**ost|char(60)|ÐòÂÔ´¬ÐÍ°àNO|PRI||||User|char(16)|NO|PRI||||Password|char(41)|NO||||mysql>updateusersetpasswor·þ°ì±»±ßd=password('passw0rʧd')whereuser="¶Ì»¯Èº¶«»¥ºòÒÂroot";//ÉèÖÃÃÜÂëΪpassw0rdmysql>flushprivile´ë˹¼ÆÊÀ×ãges;//Ë¢ÐÂ5.È»ºóÍ˳öÖؽ²³£¿îЦ¹»¸Ð¸èÕæеǽ
[root@local×îÇøÈô·¹ÄÚÒ˺ñµÂ»áÔ±ÓÀhost~]#mysql-uroot-ppassw0rdmy¾íʤ´ð¿íºÓ˳ÁôºÃsql>ÒÔÉϾÍÊDZ¾ÎĵÄÈ«²¿ÄÚÈÝ£¬Ï£Íû¶Ô´ó¼ÒµÄѧϰÓÐËù°ïÖú£¬Ò²Ï£Íû´ó¼Ò¶à¶àÖ§³Ö½Å±¾Ö®¼Ò¡£
