Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Á¬½Ó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 rootÃÜÂ룿

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 Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

1.Í£µômysqld
  service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
  service mysqld start --skip-networking --skip-grant-tables
  »òÕß
  /opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
  /opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
  skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊ ......

¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾

Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......

MYSQL ±¸Íü¼

MySQL client programs:
mysql
The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section 4.5.1, “mysql — The MySQL Command-Line Tool”.
mysqladmin
A client that performs administrative operations, such as crea ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ