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

[ÊÕ¼¯]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


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. 
¿ ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

mysqlÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3) ......

Ò»¸ömysqlµÄÎÊÌâ

ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î
id    class(ѧÉú°à¼¶)    studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®)  studentName(ѧÉúÐÔÃû)

¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶,
ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ