Mysql Error #2002: Can't connect to local
ÔÚSentOS 5ÖУº
>>yum install mysql
°²×°Íê±Ïºó£¬
>>mysql
error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)";
½ñÌì·þÎñÆ÷Óöµ½ÁËÒ»¸öºÜÊìϤµÄÎÊÌâ
ÊäÈë
#mysql -u root -p
ERROR 2002 (HY000):Can't connect to local MySQL server
Ëæ¼´ÉÏÍøÕÒÑ°´ð°¸,µ«ÊǶ¼²»ÊÇ£¬ÎÊÌâÊÇÎÒ°²×°µÄmysqlÊÇÓÐÎÊÌâµÄ£¬Ó¦¸ÃÊÇ£º
>>yum install mysql-server
ÕâÑù¾ÍûÎÊÌâÁË£¡
¸ù¾Ý´ó¼ÒÌṩµÄ·½·¨ÎÒÖðÒ»³¢ÊÔ
·½°¸1.
1.#ps -A|grep mysql
ÏÔʾÀàËÆ£º
1829 ? 00:00:00 mysqld_safe
1876 ? 00:00:31 mysqld
2.#kill -9 1829
3.#kill -9 1876
4.#/etc/init.d/mysql restart
5.#mysql -u root -p
ËûµÄÂé·³½â¾öÁË,ÎҵĻ¹Ã»½â¾ö!
¼ÌÐøÕÒ
·½°¸2
ÏȲ鿴 /etc/rc.d/init.d/mysqld status ¿´¿´m y s q l ÊÇ·ñÒѾÆô¶¯.
ÁíÍâ¿´¿´ÊDz»ÊÇȨÏÞÎÊÌâ.
------------------------------------------------------------------------------------
[root@localhost beinan]#chown -R mysql:mysql /var/lib/mysql
[root@localhost beinan]# /etc/init.d/mysqld start
Æô¶¯ MySQL£º [ È·¶¨ ]
[root@localhost lib]# mysqladmin -uroot password '123456'
[root@localhost lib]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.11
Type 'help;' or '\h' for help. Type '\c' to clear the buffe
ËûµÄÒ²½â¾öÁË,ÎÒµÄÂé·³»¹ÔÚ¼ÌÐø,ÒÀÈ»¼ÌÐøÑ°ÕÒ
·½°¸3
ÎÊÌâ½â¾öÁË£¬¾¹È»ÊÇmax_connections=1000 Ëû˵̫¶àÁË£¬È»ºó¸Ä³É500Ҳ˵¶à£¬ÎÞÄÎɾ֮ÎÊÌâ½â¾öÁË¡£
»¹ÊDz»ÐÐ
·½°¸4
/var/lib/mysql ËùÓÐÎļþȨÏÞ ¸Ä³Émysql.mysql
²»Ðв»ÐÐ
·½°¸5
ÕªÒª£º½â¾ö²»ÄÜͨ¹ýmysql .sockÁ¬½ÓMySQLÎÊÌâ Õâ¸öÎÊÌâÖ÷ÒªÌáʾÊÇ£¬²»ÄÜͨ¹ý '/tmp/mysql .sock'Á¬µ½·þÎñÆ÷£¬¶øphp±ê×¼ÅäÖÃÕýÊÇÓùý'/tmp/mysql .
Ïà¹ØÎĵµ£º
Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔÀ´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......
ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æȨÉùÃ÷£º¿ÉÒÔÈÎÒâתÔØ£¬×ªÔØʱÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......
ÔÚ×ÀÃæÉÏн¨Ò»¸ö¿ÕµÄÎı¾Îļþmysql.txt,ÖØÃüÃûΪmysql.udl,Ë«»÷Õâ¸ömysql.udlÎļþ£¬´ò¿ª“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ìṩ³ÌÐò”ҳѡÔñ”Micrsoft Ole DB Provider for ODBC Drivers“£¬ µã»÷ÏÂÒ»²½£¬ÔÚ“Á¬½Ó”Ò³µÄ,"Ö¸¶¨Êý¾ÝÔ´"Ñ¡Ôñ"ʹÓÃÁ¬½Ó×Ö·û´®",µã» ......
1.ÏÂÔØ MySQL 6.0Ãâ°²×°°æ
http://dev.mysql.com/get/Downloads/MySQL-6.0/mysql-noinstall-6.0.9-alpha-win32.zip/from/pick#mirrors
2.½« MySQL6.0 ½âѹµ½´ý°²×°Ä¿Â¼(×Ô¼º¾ö¶¨·Åµ½ÄÄ£©¡£½âѹºóĬÈÏÎļþ¼ÐÃû³ÆΪ£ºmysql-6.0.9-alpha-win32£¨µ±È»¿ÉÒÔ×Ô¼º¸ü¸Ä£©£¬È»ºóÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¨ÕâÑù£¬ÒÔºó¿ÉÒÔÓÃ%MYSQL ......