Mysql´íÎ󼯽õ£¨Linux£©
1£º Can’t connect to [local] MySQL server´íÎó
Ò»¸öMySQL¿Í»§¿ÉÒÔÁ½ÖÖ²»Í¬µÄ·½Ê½Á¬½Ómysqld·þÎñÆ÷£ºUnixÌ×½Ó×Ö£¬Ëüͨ¹ýÔÚÎļþϵͳÖеÄÒ»¸öÎļþ(ȱʡ“/tmp /mysqld.sock”)½øÐÐÁ¬½Ó£»»òTCP/IP£¬Ëüͨ¹ýÒ»¸ö¶Ë¿ÚºÅÁ¬½Ó¡£UnixÌ×½Ó×Ö±ÈTCP/IP¸ü¿ì£¬µ«ÊÇÖ»ÓÐÓÃÔÚÁ¬½Óͬһ̨¼ÆËã»úÉϵķþÎñÆ÷¡£Èç¹ûÄã²»Ö¸¶¨Ö÷»úÃû»òÈç¹ûÄãÖ¸¶¨ÌØÊâµÄÖ÷»úÃûlocalhost£¬Ê¹ÓÃUnixÌ×½Ó×Ö¡£
´íÎó(2002£©Can’t connect to ...ͨ³£Òâζ×ÅûÓÐÒ»¸öMySQL·þÎñÆ÷ÔËÐÐÔÚϵͳÉÏ»òµ±ÊÔͼÁ¬½Ómysqld·þÎñÆ÷ʱ£¬ÄãÕýÔÚʹÓÃÒ»¸ö´íÎóµÄÌ×½Ó×ÖÎļþ»òTCP/IP¶Ë¿Ú¡£
Óɼì²é(ʹÓÃps)ÔÚÄãµÄ·þÎñÆ÷ÉÏÓÐÒ»¸öÃûΪmysqldµÄ½ø³ÌÆô¶¯£¡Èç¹ûûÓÐÈκÎmysqld¹ý³Ì£¬ÄãÓ¦¸ÃÆô¶¯Ò»¸ö¡£¼û4.15.2 Æô¶¯MySQL·þÎñÆ÷µÄÎÊÌâ¡£
Èç¹ûÒ»¸ömysqld¹ý³ÌÕýÔÚÔËÐУ¬Äã¿ÉÒÔͨ¹ý³¢ÊÔÕâЩ²»Í¬µÄÁ¬½ÓÀ´¼ì²é·þÎñÆ÷(µ±È»£¬¶Ë¿ÚºÅºÍÌ×½Ó×Ö·¾¶Ãû¿ÉÄÜÔÚÄãµÄ°²×°ÖÐÊDz»Í¬µÄ)£º
shell> mysqladmin version
shell> mysqladmin variables
shell> mysqladmin -h `hostname` version variables
shell> mysqladmin -h `hostname` --port=3306 version
shell> mysqladmin -h ’ip for your host’ version
shell> mysqladmin --socket=/tmp/mysql.sock version
×¢ÒâhostnameÃüÁîʹÓ÷´ÒýºÅ“`”¶ø·ÇÕýÒýºÅ“’”£»ÕâЩµ¼ÖÂhostnameÊä³ö£¨¼´£¬µ±Ç°Ö÷»úÃû)±»´úÌæ½ømysqladminÃüÁîÖС£
ÕâÊÇ¿ÉÄÜÔì³ÉCan’t connect to local MySQL server´íÎóµÄһЩÔÒò£º
mysqld²»ÔÚÔËÐС£
ÄãÕýÔÚʹÓÃMIT-pthreadsµÄÒ»¸öϵͳÉÏÔËÐС£Èç¹ûÕýÔÚÔËÐÐÔÚÒ»¸öûÓÐÔÉúÏ̵߳ÄϵͳÉÏ£¬mysqldʹÓà MIT-pthreads Èí¼þ°ü¡£¼û4.2 ÓÉMySQLÖ§³ÖµÄ²Ù×÷ϵͳ¡£È»¶ø£¬MIT-pthreads²»Ö§³ÖUnixÌ×½Ó×Ö£¬Òò´Ëµ±Óë·þÎñÆ÷Á¬½Óʱ£¬ÔÚÕâÑùÒ»¸öϵͳÉÏ£¬Äã×ÜÊDZØÐëÃ÷È·µØÖ¸¶¨Ö÷»úÃû¡£ÊÔÊÔʹÓÃÕâ¸öÃüÁî¼ì²éµ½·þÎñÆ÷µÄÁ¬½Ó£º
shell> mysqladmin -h `hostname` version
ijÈËɾ³ýÁËmysqldʹÓõÄUnixÌ×½Ó×Ö(ȱʡ“/tmp/mysqld.sock”)¡£Äã¿ÉÄÜÓÐÒ»¸öcronÈÎÎñɾ³ýÁËMySQLÌ×½Ó×Ö(ÀýÈ磬һ¸ö°Ñ¾ÉÎļþ´Ó“/tmp”Ŀ¼ÖÐɾ³ýµÄÈÎÎñ)¡£Äã×ÜÊÇ¿ÉÒÔÔËÐÐmysqladmin version²¢ÇÒ¼ì²émysqladminÕýÔÚÊÔͼʹÓõÄÌ×½Ó×Öȷʵ´æÔÚ¡£ÔÚÕâÖÖÇé¿öÏ£¬ÐÞ¸´·½·¨ÊÇɾ³ýcronÈÎÎñ¶ø²»É¾³ý“mysqld.sock »ò½«Ì×½Ó×Ö·ÅÔÚÆäËûµØ·½¡£ÄãÄÜÓÃÕâ¸öÃüÁ
Ïà¹ØÎĵµ£º
ÒÔϵÄÎÄÕÂÊÇMySQL grantÓï·¨µÄÏêϸ½âÎö£¬Èç¹ûÄã¶ÔMySQL grantÓï·¨µÄÏà¹ØµÄʵ¼Ê²Ù×÷ÓÐÐËȤµÄ»°£¬Äã¾Í¿ÉÒÔ¶ÔÒÔϵÄÎÄÕµã»÷¹Û¿´ÁË¡£ÎÒÃÇ´ó¼Ò¶¼ÖªµÀMySQLÊý¾Ý¿â¸³ÓèÓû§È¨ÏÞÃüÁîµÄ¼òµ¥¸ñʽ¿É¸ÅÀ¨Îª£º
grant ȨÏÞ on Êý¾Ý¿â¶ÔÏó to Óû§
Ò»¡¢grant ÆÕͨÊý¾ÝÓû§£¬²éѯ¡¢²åÈë¡¢¸üС¢É¾³ý Êý¾Ý¿âÖÐËùÓбíÊý¾ÝµÄȨÀû¡£
grant ......
¸ømysql¿ªÒ»¸ö¿ÉÒÔÔ¶³Ì·ÃÎʵÄÓû§ÃüÁîÈçÏÂ:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
"*.*" ±íʾÊý¾Ý¿âÖÐËùÓеıí,Ò²¿ÉÒÔ»»³ÉÖ¸¶¨µÄ±íÈçtest.*
"myuser" ±íʾµÄÊÇ·ÃÎʵÄÓû§Ãû;
"%" ±íʾËùÓеÄÖ÷»ú¼´ÈκεÄÖ÷»ú¶¼¿ÉÒÔͨ¹ýÕâ¸öÓû§Ãû·ÃÎÊÎÒµÄÊý¾Ý¿â,Ò²¿ÉÒԸóÉÌØ¶¨µ ......
дÈëʱ£¬ÏÈ×öencode£º
public static String encode(String src) {
String result = null;
try {
result = new String(src.getBytes("gbk"), "ISO-8859-1");
} catch (UnsupportedEncodingException uee) {
System.err.println(uee);
}
return result;
}
¶Á³öʱ£¬ÔÙ×ödecode£º
public static String deco ......
Ò»Ö±Ïëдµã¶«Î÷£¬µ«È´³Ù³ÙûÓпªÊ¼£¬½ñÌìÎÞÒâÖлص½ERP100Õâ¸öÍøÕ¾£¬·¢ÏÖÓÐÁËQADµÄ×¨Çø£¬ÓÚÊÇ£¬Ò»Ê±ÈÈѪ·ÐÌÚ£¬Ð´Á˵㶫Î÷£¬¾Í½è´Ë»ú»á½«ÄÚÈÝÒ²·¢µ½ÕâÀï°É£¬ºÇºÇ¡£
ÆäʵÄÚÈݶ¼ÊDZ¾ÈËдµÄ£¬²»¹ýΪÁËͼ·½±ã£¬ÔÚERP100ÖÐдÍêÁË£¬È»ºóÖ±½ÓCopyµ½ÕâÀ͵Á˵ãÀÁ£¬ºÇºÇ¡£
ÒÔÏÂÊÇÕýÎÄ£¬ÔÚERP100ÖеĵØÖ·ÊÇ
http://bbs.erp100.com ......
LinuxÎļþ²éÕÒÃüÁîfind,xargsÏêÊö
×ܽ᣺zhy2111314
À´×Ô£ºLinuxSir.Org
ÕûÀí£º±±ÄÏÄϱ±
ÕªÒª£º ±¾ÎÄÊÇfind ÃüÁîµÄÏêϸ˵Ã÷£¬¿É¹óµÄÊÇÕë¶Ô²ÎÊý¾ÙÁ˺ܶàµÄʵÀý£¬´óÁ¿µÄÀýÖ¤£¬ÈóõѧÕ߸üΪÈÝÒ×Àí½â£»±¾ÎÄÊÇzhyflyÐÖÌùÔÚÂÛ̳ÖУ»ÎÒ¶Ô±¾ÎĽøÐÐÁËÔÙ´ÎÕûÀí£¬Îª·½±ã´ó¼ÒÔĶÁ£»
Ŀ¼
°æÈ¨ÉùÃ÷
ǰÑÔ£º¹ØÓÚfindÃüÁî
Ò»¡¢ ......