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

MySQL¼à¿Ø

Ô­ÎÄÍøÖ·£ºhttp://knowhow.innovatedigital.com/mysql-monitoring.html
MySQLÊÇ×îÁ÷ÐеĿª·ÅÔ´´úÂë¹ØϵÊý¾Ý¿âϵͳ¡£ÆäÐÔÄܺÍÒ×ÓÃÐÔ£¬Ê¹Æä³ÉΪLAMP¼Ü¹¹µÄÖÐÐÄÖ§ÖùÖ®Ò»¡£
       MySQL¼à¿ØÒ»Ö±ÊǹØ×¢MySQLÊý¾Ý¿âÐÔÄܺÍMySQLÊý¾Ý¿âÔËά¹ÜÀí¼¼ÊõÈËÔ±µÄ·Ç³£¸ÐÐËȤ»°Ìâ¡£ÈçºÎÈÃÄúµÄMySQLÊý¾Ý¿â°²È«¿ìËÙµÄÔËÐУ¬Hyperic HQ¾Í¿ÉÒÔͨ¹ý¼à¿ØMySQL£¬Í¨¹ý±¨¾¯·½Ê½¼°Ê±·¢ÏÖMySQLÊý¾Ý¿â´æÔÚµÄÎÊÌ⣡
        Hyperic HQ ¶Ô¿ªÔ´¼¼ÊõµÄÈ«ÃæÖ§³ÖÒâζ×ÅÄú¿ÉÒÔÇáËɹÜÀíMySQLÒÔ¼°Í¨¹ýHQ½Ó¿Ú¹ÜÀíÆäÓàµÄLAMP¶ÑÕ» ¡£Hyperic HQ¾ßÓÐÖ±¹ÛÐԺͿɼûÐÔ£¬ÕâÖֿɼûÐÔÓÉMySQLÊý¾Ý¿âÒýÇæÒÔ¼°Ã¿¸ö±íµÄ´óÁ¿¶ÈÁ¿ÖµÇý¶¯¡£
        ´ËÍ⣬HQͨ¹ý×Ô¶¯»¯ºÍÐèÇó¹ÜÀíÈÎÎñ¿ØÖÆMySQL£¬Õ⽫ÓÐÖúÓÚ±£³ÖMySQLÊý¾Ý¿âµÄ¸ßÐÔÄÜÔËÐС£ÆäÇ¿´óµÄÓ¦ÓøÅÄÄú¿ÉÒÔÖ±¹ÛµØ¼à²âÄãµÄÒµÎñÂß¼­ºÍÊý¾Ý¿â²ã±íʾ²ã£¬Í¨¹ý²âÁ¿Êý¾Ý¿ÉÒÔºâÁ¿ÄãµÄÓ¦ÓóÌÐò»ù´¡¼Ü¹¹µÄ¸÷¸ö²ãÃæÈçºÎÔÚ¿Í»§¶ËµÄ»î¶¯¡£
       Hyperic HQ ¶ÔMySQL¼à¿ØÖ÷ÒªÌåÏÖÔÚ£º
      ×Ô¶¯·¢ÏÖÄúµÄÓ²¼þºÍMySQL·þÎñÆ÷
      ¼à¿ØMySQL×ÊÔ´µÄÿһ¸ö¶ÈÁ¿Öµ£¬ÈÕÖ¾£¬ÅäÖÃ
      ÓÃ×Ô¶¯µÄ¶ÈÁ¿Öµ»ùÏßʶ±ðÎÊÌâ
      ¿ØÖÆËùÓÐMySQL×ÊÔ´ÉϵÄÃüÁµ÷¶È£¬»ò¾¯±¨»ØÓ¦
      ¾¯±¨MySQL»·¾³µÄÔÚÈκβâÁ¿£¬ÈÕÖ¾£¬»ò°²È«ÐÔʼþ
     Hyperic HQ--ÓÅÐãµÄMySQLÊý¾Ý¿â¼à¿ØÈí¼þ ,ÏàÐÅÄܸøÄú´øÀ´¸ü¶à¼ÛÖµ£¬ÈÃÄú´Ó·±ÖصŤ×÷ÖнâÍѳöÀ´£¬µÃµ½Ò»·ÝÇáËɺÍÓä¿ì£¡
    Hyperic HQÏÂÔØ£ºhttp://knowhow.innovatedigital.com/node/326
    Hyperic HQ FAQÓë½â´ð http://knowhow.innovatedigital.com/hyperic-hq
   Hyperic HQ ¼¼ÊõÂÛ̳£ºhttp://g.51cto.com/hyperichq


Ïà¹ØÎĵµ£º

MySQL Java ¿ª·¢Ì××°

MySQL Java ¿ª·¢Ì××°(·þÎñÆ÷,¹ÜÀí¹¤¾ß,JDBCÇý¶¯,ʾÀý´úÂë)
С¸üÐÂ: ΪÁ˼õÇḺµ£, Óà MySQL-Front 2.5 À´¹ÜÀí, Õâ¸öÈí¼þÎÞÖÐÎÄÎÊÌâ. Èç¹ûÒÔºó¿ªÔ´°æ±¾HeidiSQLµÄ½â¾öÁËÖÐÎÄÎÊÌâ, ¾ÍÓÿªÔ´µÄ.
ÏÂÔØ: http://tomcatmonitor.googlecode.com/files/portable_mysql5.exe  4.02MB (×Ô½âѹ°ü)
²Î¿¼Îĵµ: MySQL 5 ÂÌÉ« ......

Ô¶³ÌÁ¬½Ó MySQL l×ÊÁÏ zz


Ô¶³ÌÁ¬½Ómysql×ÊÁÏ
Ô¶³ÌÁ¬½Óµ½mysqlÐèÒª×öµÄ£º
1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
²é¿´½á¹û£¬Ö´ÐУº
   use mysql;
 & ......

mysql µ¼Èë¡¢µ¼³öÊý¾Ý¿â¡¢±í

DOS¡¡´°¿Ú
¿ªÊ¼£­£¾ÔËÐУ­£¾¡¡cmd
µ¼³öΪ£º¡¡mysqldump -u Óû§Ãû -p  --opt  Êý¾Ý¿âÓû§Ãû >
Êý¾Ý¿âÃû.sql
ÊäÈëÄãµÄÊý¾Ý¿âÃÜÂë!phpma.com
µ¼ÈëΪ£ºmysql -u Óû§Ãû -p Êý¾Ý¿âÓû§Ãû < Êý¾Ý¿âÃû.sql
£¨Òª
ÔÚµ±Ç°Ä¿Â¼Ï²Ù×÷£©
ÒªÏ뽫Îı¾Îļþ

pet.txt

×°Ôص½
pet
±íÖУ¬Ê¹Ó ......

ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨

http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......

MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á()


[Ô­´´] MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á[Ô­´´]
http://www.chinaunix.net ×÷Õß:squall1  ·¢±íÓÚ£º2007-07-23 19:01:43
¡¾·¢±íÆÀÂÛ¡¿¡¾²é¿´Ô­ÎÄ¡¿¡¾´æ´¢±¸·ÝÖ®¼ÒÌÖÂÛÇø¡¿¡¾¹Ø±Õ¡¿
×÷ÕߣºCU-squall   
·¢±íÓÚ£º2005Äê4ÔÂ18ÈÕ 8:21  ¿ÉÒÔ²»¾­×÷ÕßͬÒâ×ÔÓÉ´«²¥£¬Çë×¢Ã÷×÷Õß³ö´¦¡£
ʹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ