ºìÁªLinuxÃÅ»§
Linux°ïÖú

LINUXÏ°²×°MYSQL³£¼ûÎÊÌâ´¦Àí

·¢²¼Ê±¼ä:2008-06-20 01:34:03À´Ô´:ºìÁª×÷Õß:gaiebian
×°ÍêºóÆô¶¯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;

ÔÙÁ¬½Ó¾ÍûÎÊÌâÁË¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ