mysqlÔ¶³ÌµÇ¼´íÎó
°²×°×îеÄmysql 5.1.38°æ±¾£¬·þÎñÆ÷ÊÇCentOs£¬ÔÚ·þÎñÆ÷ÉÏ¿ÉÒÔÓÃrootÕʺŵǼ¡£
È»ºóÓÃgrant all PRIVILEGESÃüÁî¸ø´´½¨ÕʺÅadmin£¬show grantsÓï¾ä½á¹ûÈçÏ£º
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257
µ«ÊÇÓÃSQLyog¹¤¾ß¾ÍÊÇÁ¬½Ó²»ÁËmysql£¬³öÏÖCan't connect to MySQL server on '192.168.101.134' (10061)
ÓÐÈËÖªµÀÊÇʲôÔÒòÂð£¿
ÒòΪÎÒûÓиøadminµÄlocalhostµÇ½ȨÏÞ£¬ÓÃadminÔÚ·þÎñÆ÷ÉÏÊǵǽ²»ÉÏÈ¥µÄ
SQLyogÓõÄÊÇadminÕʺÅ
Òѽâ¾ö£¬·À»ðǽµÄÎÊÌâ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
Java code:
Statement sta=co.createStatement();
String na=te1.getText();
String pa=te2.getText();
String sql=& ......