Á¬½ÓMySQLÕÒ²»µ½mysql.sockÎļþµÄ½â¾ö°ì·¨
ÔËÐгÌÐò¿ÉÄܻᱨ´í£ºCan’t connect to local MySQL Server through socket ‘/tmp/mysql.sock’
Õâ¸ö´íÎóµÄÌáʾÊÇ˵£¬²»ÄÜͨ¹ý’/tmp/mysql.sock’Á¬½Óµ½·þÎñÆ÷¡£Mysql.sockÊÇ´´½¨Óëmysqld·þÎñÆ÷Ïà¹ØµÄMySQLͨÐŶ˵ãËùʹÓõÄÌ×½Ó×Ö¡£¶øPHP±ê×¼ÅäÖÃÕýÊÇͨ¹ý’/tmp/mysql.sock’À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÄÜÊÇһЩmysqlµÄ°²×°·½·¨½«mysql.sock·Åµ½Á˱ðµÄµØ·½£¬¿ÉÒÔͨ¹ýÐÞ¸Ä/etc/mysql/my.cnfÎļþ£¨»òÕß/etc/my.confÎļþ£¬ºÍmysql°²×°µÄ·½·¨Óйأ¬¸ÃÅäÖÃÎļþµÄ·¾¶¿ÉÄÜ»áÓÐËù²»Í¬£©À´ÐÞ¸ÄËü£¬´ò¿ªÎļþ¿ÉÒÔ¿´µ½ÈçϵÄÓï¾ä£º
[mysqld]
Socket = /var/lib/mysql/mysql.sock
˵Ã÷mysqld.sockÎļþ·ÅÔÚÁË/var/lib/mysql/Îļþ¼ÐÏ£¬ËùÒÔ²»ÄÜÔÚ/tmp·¾¶ÏÂÕÒµ½¸ÃÎļþ£¬Í¨¹ý×öÒ»¸öÁ´½ÓÎļþ¾Í¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣺
Äú¿ÉÒÔÔÚÃüÁîÐÐÏÂÊÖ¶¯ÊäÈëÈçÏÂÃüÁ
ln -s /var/lib/mysqld/mysqld.sock /tmp/mysql.sock
ÐÞ¸ÄÍêÖ®ºó£¬³ÌÐò¾Í¿ÉÒÔÕý³£Æô¶¯ÁË¡£
Èç¹û»¹ÊDz»ÄÜÆô¶¯µÄ»°£¬¿ÉÄÜÊÇÓÉÓÚMySQL·þÎñÆ÷ûÓдò¿ª£¬Èç¹ûMySQL·þÎñÆ÷ûÓдò¿ªµÄ»°£¬ÔÚ/var/lib/mysql/Ŀ¼Ï¾Ͳ»»áÓÐmysql.sockÕâ¸öÎļþ£¬ËùÒÔ¼´Ê¹×öÁËÁ´½ÓÎļþ¾ÍûÓÐÓã¬ÒòΪËü¸ù±¾ÕÒ²»µ½/var/lib/mysql/mysql.sockÎļþ¡£ËùÒÔʹÓÃÃüÁÆôMySQL·þÎñÆ÷£º
$service mysqld start
Èç¹ûÏëÈÃMySQL·þÎñÆ÷ÔÚÿ´Î¼ÆËã»úÖØÆôʱÆô¶¯£¬¼üÈëÈçÏÂÃüÁrootÓû§Éí·Ý£©£º
$chkconfig mysqld on
Ïà¹ØÎĵµ£º
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡£
......
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......
½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔÇ°¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔÇ°ÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇΧÈÆ×ÅÕâ¸ö×éºÏ ......
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
etting up OpenLDAP with MySQL backend
ÓÃmysql×÷ºǫ́Êý¾Ý¿â°²×°openldap
author: TBONIUS
OpenLDAP is an X.500 Lightweight Directory Access Server used for
centralized authentication and directory lookups. ......