[ÊÕ¼¯]mysql ÎÞ·¨Áª½Ó¹ÊÕÏÏÖÏó¼°ÔÒò
³õѧµÄmysqlÍøÓѺÃÏó¾³£»áÅöµ½mysqlÎÞ·¨Á¬½ÓµÄ´íÎó¡£ÌØ¿ªÌùÊÕ¼¯ÕâÑùÎÊÌâµÄÏÖÏóºÍÔÒò¡£ ÏÈ×Ô¼ºÈÓ¿éשͷ³öÀ´¡£ ===================================================================================================== ¹ÊÕÏÏÖÏó : ÎÞ·¨Á¬½Ó mysql ´íÎóÐÅÏ¢ £ºERROR 2003 (HY000): Can't connect to MySQL server on 'hostxxxxx' (10061) ÔÒò : mysqldÊý¾Ý¿â·þÎñûÓÐÆô¶¯¡£ ¼ì²é £ºÔÚwindows µÄÈÎÎñ¹ÜÀíÆ÷£¬»òÕß unix/linux Ï ps -aux | grep mysql ¿´Ò»Ï¡£È·ÈÏ·þÎñÒѾÆô¶¯¡£ ´¦Àí £ºÆô¶¯mysqld ·þÎñ =====================================================================================================
Õ¼¸öɳ·¢ÏÈ£¡ÒýÓà ÓÐʱºò´´½¨µÄÓû§²»ÄܵǼÊý¾Ý¿â,ÆäÖÐÓпÉÄÜÊÇÓû§±¾ÉíûÓÐȨÏÞ´´½¨Óû§,Çë°æÖ÷½âÊÍÒ»ÏÂʲôȨÏÞµÄÓû§²Å¿ÉÒÔ´´½¨Óû§¡£ ===================================================================================================== ¹ÊÕÏÏÖÏó : ÎÞ·¨Á¬½Ó mysql ´íÎóÐÅÏ¢ £ºERROR 1045 (28000): Access denied for user 'usera'@'localhost' (using password:YES) ÔÒò : Óû§Õ˺Ų¢Î´´´½¨ ¼ì²é £ºÒÔ¹ÜÀíÔ±ROOTµÇ¼ºó£¬show grants for 'usera'@'localhost'; »òÕß select user from mysql.user; È·ÈÏÓû§Õ˺ÅÊÇ·ñ´æÔÚ¡£ ´¦Àí £º´´½¨Óû§Õ˺š£ ===================================================================================================== ʲôȨÏÞµÄÓû§²Å¿ÉÒÔ´´½¨Óû§¡£ The
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º 1£© ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......); 2£© ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í 3) ......
ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î id class(ѧÉú°à¼¶) studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®) studentName(ѧÉúÐÔÃû) ¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶, ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£© ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......