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

MySQLѧϰ(6)SHOW,USER

1.SELECT USER();
»ñµÃµ±Ç°µÇ½Óû§µÄÓû§ÃûÓëÖ÷»úÐÅÏ¢£¬Ê¹ÓøÃÃüÁî»áÏÔʾÀàËÆÓÚÈçÏÂÐÅÏ¢£ºroot@zxj.lest.vicp.cc£¬@Ç°ÃæÊÇÓû§Ãû£¬ºóÃæÊÇÖ÷»úÃû¡£
2.SHOWÓ÷¨£¬
SHOW DATABASES--ÏÔʾ¶àÉÙ¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔ½Ð×ö±í¿Õ¼ä¡£
SHOW TABLES--ÏÔʾÓжàÉÙ¸ö±í¡£
SHOW VARIABLES--ÏÔʾÊý¾Ý¿â±äÁ¿¡£
SHOW MASTER STATUS.
SHOW CREATE TABLE£¬SHOW CREATE DATABASE£¬
SHOW PROCEDURE CODE proc_name.
³£ÓõĻ¹ÓУ¬
USE DATABASE,SHOW @@i,@@ÊÇÏÔʾϵͳ±äÁ¿¡£
CREATE EVENT E_SHOW ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SHOW DATABASES.
һСʱºóÖ´ÐÐSHOW DATABASES²Ù×÷¡£


Ïà¹ØÎĵµ£º

java¶ÔmysqlÊý¾Ý¿âµÄµ¼Èëµ¼³ö

//µ¼³ö
String mysql="mysqldump -uroot -proot  --opt databasename > d:/test.sql";    
java.lang.Runtime.getRuntime().exec("cmd /c "+mysql);   
//µ¼Èë
String mysql="mysqladmin -uroot -proot create databasename";    
java.lang.Runt ......

(ת)MySQL¸ü¸Ä/ÐÞ¸ÄrootÃÜÂëµÄÈýÖÖ·½·¨

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖУº
/e ......

MySQL 3.23 ÖÐÎIJο¼ÊÖ²á

mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£ 
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£ 
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£ 
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£ 
mysql_create_db() ´´½¨Ò ......

mysqlÈÕÖ¾

http://hi.baidu.com/ubuntu2me/blog/item/e1bd54de9a428f1862279828.html
¡¾IT168¼¼ÊõÎĵµ
¡¿ÈκÎÒ»ÖÖÊý¾Ý¿âÖУ¬¶¼Óи÷ÖÖ¸÷ÑùµÄÈÕÖ¾¡£MysqlÒ²²»ÀýÍ⣬ÔÚMysqlÖÐÓÐ4ÖÖ²»Í¬µÄÈÕÖ¾¡¢·Ö±ð´íÎóÈÕÖ¾¡¢¶þ½øÖÆÈÕÖ¾¡¢²éѯÈÕÖ¾ºÍÂý²éѯÈÕÖ¾¡£ÕâЩÈÕÖ¾¼Ç¼×ÅMysqlÊý¾Ý¿â²»Í¬·½ÃæµÄ×Ù¼£¡£ÏÂÎĽ«½éÉÜÕâ4ÖÖ²»Í¬µÄÈÕÖ¾×÷ÓúÍÓÃ;¡£
¡¡¡ ......

nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ


nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄܼà¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»Äܼà¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾ­Í£Ö¹£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ