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

Mysql ÃüÁîʵÀý

1. Mysql Åàѵ
1.1. ÅàѵĿµÄ
±¾ÎĵµÊÇÕë¶ÔMySQL Êý¾Ý¿â·½ÃæµÄ»ù´¡Åàѵ£¬ÎªÁËʹÏîÄ¿×é³ÉÔ±Äܹ»´ïµ½Ê¹ÓÃMySQL Êý¾Ý¿âµÄÄ¿µÄ¡£
1.2. Åàѵ¶ÔÏó
¿ª·¢ÈËÔ±
1.3. ³£Óôʼ°·ûºÅ˵Ã÷
³£Óôʣº
Mysql£ºÒ»ÖÖÃâ·ÑµÄ¿çƽ̨µÄÊý¾Ý¿âϵͳ
E:\mysql£º±íʾÊÇÔÚdos ÃüÁî´°¿ÚÏÂÃæ
mysql> ±íʾÊÇÔÚmysql µÄÃüÁîÐÐÏÂ
1.4. ²Î¿¼ÐÅÏ¢
http://dev.mysql.com/doc/refman/5.0/en/index.html
2. MYSQL
2.1. Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
Á¬½ÓÔ¶³Ì»úÆ÷£º
E:\mysql>mysql -h10.4.3.188 -uptsdb -p
µÈ¼Ûд·¨
E:\mysql>mysql --host=10.4.3.188 --user=ptsdb --password
Á¬½Ó±¾µØ»úÆ÷£º
E:\mysql>mysql -uroot -p
µÈ¼Ûд·¨
E:\mysql>mysql --user=root -password
£¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
×¢ÒâÊÂÏ»·¾³±äÁ¿path ÀïÃæÒªÉ趨mysqlµÄbinµÄ·¾¶£º
C:\Program Files\MySQL\MySQL Server 5.0\bin
2.2. ÐÞ¸ÄÃÜÂë
·½·¨Ò»£ºÊ¹ÓÃmysqladmin
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
Àý1£ºE:\mysql>mysqladmin -uroot password root
×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
Àý2£ºÔÙ½«rootµÄÃÜÂë¸ÄΪroot123¡£
E:\mysql>mysqladmin -uroot -proot password root123
·½·¨¶þ£ºÖ±½Ó¸üРuser ±í
mysql>UPDATE user SET password=PASSWORD("test123") WHERE user='test';
mysql> FLUSH PRIVILEGES;
mysql> SET PASSWORD FOR test=PASSWORD('test123');
mysql> FLUSH PRIVILEGES;
·½·¨Èý£ºÊ¹Óà grant
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿â.±í¸ñ| ÆäËû to Óû§@Ö÷»ú IDENTIFIED BY ¿ÚÁî
Àý1£º¸øtestÓû§ÔÚ±¾µØlocalhost ËùÓÐȨÏÞ(³ýÁËGRANT OPTION)£¬¿ÚÁîΪ test
(Ï൱ÓÚÐÞ¸ÄÁËtest Óû§µÄ¿ÚÁî)
mysql>grant all on *.* to test@localhost identified by "test";
µÈͬÓÚ
mysql>grant all on *.* to test @localhost identified by PASSWORD " *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 ";
Àý2¡¢Ôö¼ÓÒ»¸öÓû§testÃÜÂëΪabc£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔtestÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMYSQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ
mysql>grant select,insert,update,delete on test.* to test@"%" Identified by "abc";
ÔÚmysql.user ±íÖУ¬ÓÐÁ½¸ötest Óû§
Ò


Ïà¹ØÎĵµ£º

MySQLÖеÄCREATE VIEWÓï·¨

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......

mysql Óαê

¶¨ÒåÓαê 
DECLARE cur_Ãû³Æ CURSOR
FOR
SELECT ×Ö¶Î1,×Ö¶Î2,...×Ö¶În from ±í where ×Ö¶Î1=±äÁ¿;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET ±äÁ¿1=null,±äÁ¿2=null;
OPEN cur_Ãû³Æ;
FETCH cur_Ãû³Æ INTO ±äÁ¿1,±äÁ¿2...;
WHILE ( ±äÁ¿1  IS NOT NULL) DO
 &nbs ......

Nagios£º¼à¿ØMysql·þÎñÆ÷

ʱ¼ä£º2009-03-12 12:38:24  À´Ô´£ºLinuxÁªÃË
  ×÷Õߣº
 À´Ô´£ºit168.com
   
    ×÷ÕߣºÌïÒÝ(sery@163.com)
    Ë×»°Ëµ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷.Òª×öºÃϵͳ¹ÜÀí,ʹ×Ô¼ºµÄ¹¤×÷¸üÇáËɸüÓÐЧµÄ»°£¬Ò»¸öºÃµÄ¼à¿Ø¹¤¾ßÊDZز»¿ÉÉÙµÄÁË¡£ÔÚÕâÀïÎÒÏò ......

MySQL¹ÜÀíÔ±Ö¸ÄÏÖ®

Îȹʶø֪У¬×î½üÓÖÓõ½ÁË£¬²Ý²ÝÄÃÀ´ÎÂϰһϣº×ª×Ô http://www.bccn.net/Article/sjk/mysql/jc/200601/3411.html
MySQL¹ÜÀíÔ±Ó¦¸ÃÖªµÀÈçºÎÉèÖÃMySQLÓû§Õ˺ţ¬Ö¸³öÄĸöÓû§¿ÉÒÔÁ¬½Ó·þÎñÆ÷£¬´ÓÄÄÀïÁ¬½Ó£¬Á¬½ÓºóÄÜ×öʲô¡£MySQL
3.22.11¿ªÊ¼ÒýÈëÁ½ÌõÓï¾äʹµÃÕâÏ×÷¸üÈÝÒ××ö£ºGRANTÓï¾ä´´½¨MySQLÓû§²¢Ö¸¶¨ÆäȨÏÞ£¬¶øREV ......

mysql ÕÒ»ØÃÜÂë

 
1.  Í£µ½ÔËÐеÄmysql:    /etc/init.d/mysql stop
2.  ʹÓÃskip-grant-tablesÕâ¸öÑ¡ÏîÆô¶¯MySQL£º  /usr/bin/mysqld_safe --skip-grant-tables &
3.  ÏÖÔÚ¿ÉÒÔ²»ÓÃÃÜÂë½øÈëmysql ÁË¡£
     #  myql
    >   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ