Á¬½Ó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
Ïà¹ØÎĵµ£º
PHPÊÖ²áÉÏÌṩÁËÒÔÏÂһЩÖ÷ÒªµÄmysqlÊý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃǰһ´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user -- ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_c ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
ÐÞ¸Ä /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. ......