×°ÍêºóÆô¶¯mysqlÀÏÊǵȴý£¬Æô¶¯²»ÁË
´¦Àí£º¿´¿´MYSQLÈÕÖ¾£¨/var/lib/mysql/user.err£©£¬×î³£¼ûµÄÇé¿öÊÇȨÏÞÎÊÌ⣬Ҳ¾ÍÊÇ˵¸Õ×°Íê»úÆ÷£¬Ã»ÓÐmysqlÓû§£¬ÄÇô½¨Á¢Ò»¸ömysqlÓû§¾ÍOK¡£
°²×°ÍêºóÖ±½ÓÓÃmysqlûÓз´Ó¦
´¦Àí£ºÕâÊÇÒòΪperlÒѾ²»ÍêÕûµÄÔµ¹Ê£¬¿ÉÄÜÊÇɾ³ýÀÏ°æ±¾µÄʱºò£¬°ÑperlµÄÒ»²¿·Ö¶«Î÷¸øɾ³ýÁË£¬Æäʵûʲô£¬Ö±½ÓÓÃ/usr/local/mysql/bin/mysql ½øÈë¾ÍOK¡£
½øÈëmysqlÒÔºó£¬Á¬½Ómysql½á¹ûÌáʾ£ºcan t connect to local mysql server through socket /var/lib/mysql/mysql.sock£¨111£©
´¦Àí£º´ò¿ª/etc/my.cnf,È»ºóÔÚ[mysqld]ºÍ[client]ϵÄsocket¶¼¸Ä£º socket = /var/lib/mysql/mysql.sock
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
˵Ã÷:»òÕßÊÇln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock ,¿´×Ô¼ºµÄÇé¿öÀ´¶¨.
¸ÄÍêÖ®ºó£¬Á¬½ÓMYSQLµÄʱºòÈç¹û±¨£ºClient does not support authentication protocol requested by server.....
´¦Àí£º½øÈëmysql£¬Ö±½ÓÊäÈë UPDATE mysql.user SET Password = OLD_PASSWORD('ÐÂÃÜÂë') WHERE Host = 'localhost' AND User = 'Óû§Ãû';
È»ºóÖØÖãºFLUSH PRIVILEGES;
ÔÙÁ¬½Ó¾ÍûÎÊÌâÁË¡£