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

MySQLС¼¼ÇÉ 1

1,Íü¼ÇrootÃÜÂë,Èç¹ûÄÜ»¹ÄܽøÈëmysqlÇÒ»¹ÓÐmysql¿âµÄȨÏÞ,ÄÇô¾ÍÖ±½ÓÖ´ÐÐ update user set password=password(¡®XXX¡¯) where user=¡¯root¡¯ and host=¡¯XX¡¯; flush privileges; ¼´¿É.Èç¹û²»ÄܽøÈëmysql,ÐèÒªÓÐmysqlÆô¶¯µÄȨÏÞ,ÔÚÆô¶¯mysqlµÄʱºò¼ÓÉÏ--skip-grant-tablesÑ¡Ïî,´Ëʱ½øÈëmysqlÎÞÐèÃÜÂë,ÔÙÖØ¸´ÉÏÊö²Ù×÷¼´¿É. 2,Èç¹ûÓÐÄÚ´æ±í,ÓÃÀ´²éѯÓõĿì±í,ÄÇôÐèÒªÆô¶¯µÄʱºò°ÑÊý¾Ýµ¼ÈëÄÚ´æ±í,mysqlÓиöÑ¡Ïî½Ð--init-fileÑ¡ÏîÕâʱºòºÜ¹ÜÓÃ,°ÑÒªÖ´ÐеÄsqlдµÀÎļþÖÐ,È»ºóÆô¶¯¼ÓÉÏinit-file='/path/to/file'¿ÉÒÔдµÀmy.cnfÖÐ,ÕâÑù¾Í²»±ØÃ¿´Î¶¼×Ô¼ºÊÖдÁË.


Ïà¹ØÎĵµ£º

[MySQLÓÅ»¯] ÈçºÎÁ˽âSQLµÄÖ´ÐÐÆµÂÊ


[MySQLÓÅ»¯] -- ÈçºÎÁ˽âSQLµÄÖ´ÐÐÆµÂÊ
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chuxu
MySQL ¿Í»§¶ËÁ¬½Ó³É¹¦ºó£¬Í¨¹ý show [session|global]status ÃüÁî ¿ÉÒÔÌṩ·þÎñÆ÷״̬ÐÅÏ¢£¬Ò²¿ÉÒÔÔÚ²Ù×÷ϵͳÉÏʹÓà mysqladmin extended-status ÃüÁî»ñµÃÕâЩÏûÏ¢¡£ show [session|global] status ¿ÉÒÔ¸ù¾ÝÐèÒª¼ÓÉϲÎÊý&ldquo ......

MySQLÖÐÐÞ¸ÄÃÜÂë¼°·ÃÎÊÏÞÖÆÉèÖÃÏê½â

¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......

mysql front ×¢²áÂë

gNBpPFgyOw9Rwt/ozsnjgM7tJNo2 bhaaAThangemMkaz2tQhq3/f7dZ7 Vj29WeGHjuupj/AhYqymjAuokhYi X1T/fG+q1yR22PdcEP39dxU3ovEo lLLzwIZlQr9oJYwUf5eG4x5e1bMP nfIaIl8reszQPHFNbrxBjCVrBEXL TyBLehxzUpVI672t3LjX8q4ytCRC ezcoZQfMAc0DulJzNREbwlcf0Rco N0zW3ojBUxGsplBBZZPrD7/bPhkM rjtS8Bxym+HeV1TJDTXuiL8QLg== ......

tomcat 6.0 + mysql + jndi Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃ

1¡¢Ð½¨¶¯Ì¬webÏîÄ¿¡£
2¡¢Ìí¼Ójar°ü
    ½«mysql jdbcÇý¶¯Ìí¼Óµ½tomcat°²×°Ä¿Â¼ÏµÄlibĿ¼¡£
3¡¢ÔÚMETA-INFÏÂÌí¼Ócontent.xmlÎļþ¡£ÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<!-- Default set of monitored resources - ......

mysql procedure ·µ»Ø½á¹û¼¯

mysql procedure ûÓÐreturn²ÎÊý ¿ÉÒÔoutÒ»¸ö±äÁ¿¸ø¿Í»§¶Ë µ«ÊÇout²ÎÊýÓÖ²»Ö§³ÖÓαêÀàÐÍ£¬ÈçºÎÄÜout³öÒ»¸ö½á¹û¼¯ÄØ£¿
·½·¨ºÜ¼òµ¥ ¾ÍÊÇÔÚprocedureÀïÖ´ÐÐÒ»¸öselect £¨select ....  from ...£©
eg.
CREATE PROCEDURE `CREATE_ACCOUNT`(
ACCOUNT CHAR(32),
PASSWORD CHAR(32), ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ