| ²é¿´: 173 | »Ø¸´: 0 | |||
| µ±Ç°Ö÷ÌâÒѾ´æµµ¡£ | |||
miRNAÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)
Ë®ÍõÖ®Íõ£¨ÓÞÓÞѧ԰¹ÜÀíÔ±£©
|
[½»Á÷]
MysqlµÄ³£ÓÃÃüÁî
|
||
|
Ò»¡¢Á¬½ÓMYSQL¡£ ¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë 1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£ Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql> 2¡¢Àý2£ºÁ¬½Óµ½Ô¶³ÌÖ÷»úÉϵÄMYSQL¡£¼ÙÉèÔ¶³ÌÖ÷»úµÄIPΪ£º110.110.110.110£¬Óû§ÃûΪroot,ÃÜÂëΪabcd123¡£Ôò¼üÈëÒÔÏÂÃüÁ mysql -h110.110.110.110 -uroot -pabcd123 £¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£© 3¡¢Í˳öMYSQLÃüÁ exit £¨»Ø³µ£© ¶þ¡¢ÐÞ¸ÄÃÜÂë¡£ ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë 1¡¢Àý1£º¸øroot¼Ó¸öÃÜÂëab12¡£Ê×ÏÈÔÚDOSϽøÈëĿ¼mysqlbin£¬È»ºó¼üÈëÒÔÏÂÃüÁî mysqladmin -uroot -password ab12 ×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£ 2¡¢Àý2£ºÔÙ½«rootµÄÃÜÂë¸ÄΪdjg345¡£ mysqladmin -uroot -pab12 password djg345 Èý¡¢Ôö¼ÓÐÂÓû§¡££¨×¢Ò⣺ºÍÉÏÃæ²»Í¬£¬ÏÂÃæµÄÒòΪÊÇMYSQL»·¾³ÖеÄÃüÁËùÒÔºóÃæ¶¼´øÒ»¸ö·ÖºÅ×÷ΪÃüÁî½áÊø·û£© ¸ñʽ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by \"ÃÜÂë\" Àý1¡¢Ôö¼ÓÒ»¸öÓû§test1ÃÜÂëΪabc£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMYSQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ grant select,insert,update,delete on *.* to test1@\"%\" Identified by \"abc\"; µ«Àý1Ôö¼ÓµÄÓû§ÊÇÊ®·ÖΣÏյģ¬ÄãÏëÈçij¸öÈËÖªµÀtest1µÄÃÜÂ룬ÄÇôËû¾Í¿ÉÒÔÔÚinternetÉϵÄÈκÎһ̨µçÄÔÉϵǼÄãµÄmysqlÊý¾Ý¿â²¢¶ÔÄãµÄÊý¾Ý¿ÉÒÔΪËùÓûΪÁË£¬½â¾ö°ì·¨¼ûÀý2¡£ Àý2¡¢Ôö¼ÓÒ»¸öÓû§test2ÃÜÂëΪabc,ÈÃËûÖ»¿ÉÒÔÔÚlocalhostÉϵǼ£¬²¢¿ÉÒÔ¶ÔÊý¾Ý¿âmydb½øÐвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄ²Ù×÷£¨localhostÖ¸±¾µØÖ÷»ú£¬¼´MYSQLÊý¾Ý¿âËùÔÚµÄÄÇ̨Ö÷»ú£©£¬ÕâÑùÓû§¼´Ê¹ÓÃÖªµÀtest2µÄÃÜÂ룬ËûÒ²ÎÞ·¨´ÓinternetÉÏÖ±½Ó·ÃÎÊÊý¾Ý¿â£¬Ö»ÄÜͨ¹ýMYSQLÖ÷»úÉϵÄwebÒ³À´·ÃÎÊÁË¡£ grant select,insert,update,delete on mydb.* to test2@localhost identified by \"abc\"; Èç¹ûÄã²»Ïëtest2ÓÐÃÜÂ룬¿ÉÒÔÔÙ´òÒ»¸öÃüÁÃÜÂëÏûµô¡£ grant select,insert,update,delete on mydb.* to test2@localhost identified by \"\"; ÔÚÉÏÆªÎÒÃǽ²Á˵Ǽ¡¢Ôö¼ÓÓû§¡¢ÃÜÂë¸ü¸ÄµÈÎÊÌâ¡£ÏÂÆªÎÒÃÇÀ´¿´¿´MYSQLÖÐÓйØÊý¾Ý¿â·½ÃæµÄ²Ù×÷¡£×¢Ò⣺Äã±ØÐëÊ×ÏȵǼµ½MYSQLÖУ¬ÒÔϲÙ×÷¶¼ÊÇÔÚMYSQLµÄÌáʾ·ûϽøÐе쬶øÇÒÿ¸öÃüÁîÒԷֺŽáÊø¡£ Ò»¡¢²Ù×÷¼¼ÇÉ 1¡¢Èç¹ûÄã´òÃüÁîʱ£¬»Ø³µºó·¢ÏÖÍü¼Ç¼Ó·ÖºÅ£¬ÄãÎÞÐëÖØ´òÒ»±éÃüÁֻҪ´ò¸ö·ÖºÅ»Ø³µ¾Í¿ÉÒÔÁË¡£Ò²¾ÍÊÇ˵Äã¿ÉÒÔ°ÑÒ»¸öÍêÕûµÄÃüÁî·Ö³É¼¸ÐÐÀ´´ò£¬ÍêºóÓ÷ֺÅ×÷½áÊø±êÖ¾¾ÍOK¡£ 2¡¢Äã¿ÉÒÔʹÓùâ±êÉÏϼüµ÷³öÒÔǰµÄÃüÁî¡£µ«ÒÔǰÎÒÓùýµÄÒ»¸öMYSQL¾É°æ±¾²»Ö§³Ö¡£ÎÒÏÖÔÚÓõÄÊÇmysql-3.23.27-beta-win¡£ ¶þ¡¢ÏÔʾÃüÁî 1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£ show databases; ¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£ 2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áİÉú°É show tables; 3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º describe ±íÃû; 4¡¢½¨¿â£º create database ¿âÃû; 5¡¢½¨±í£º use ¿âÃû£» create table ±íÃû (×Ö¶ÎÉ趨Áбí)£» 6¡¢É¾¿âºÍɾ±í: drop database ¿âÃû; drop table ±íÃû£» 7¡¢½«±íÖмǼÇå¿Õ£º delete from ±íÃû; 8¡¢ÏÔʾ±íÖеļǼ£º select * from ±íÃû; Èý¡¢Ò»¸ö½¨¿âºÍ½¨±íÒÔ¼°²åÈëÊý¾ÝµÄʵÀý drop database if exists school; //Èç¹û´æÔÚSCHOOLÔòɾ³ý create database school; //½¨Á¢¿âSCHOOL use school; //´ò¿ª¿âSCHOOL create table teacher //½¨Á¢±íTEACHER ( id int(3) auto_increment not null primary key, name char(10) not null, address varchar(50) default ¡¯ÉîÛÚ¡¯, year date ); //½¨±í½áÊø //ÒÔÏÂΪ²åÈë×Ö¶Î insert into teacher values(¡¯¡¯,¡¯glchengang¡¯,¡¯ÉîÛÚÒ»ÖС¯,¡¯1976-10-10¡¯); insert into teacher values(¡¯¡¯,¡¯jack¡¯,¡¯ÉîÛÚÒ»ÖС¯,¡¯1975-12-23¡¯); ×¢£ºÔÚ½¨±íÖУ¨1£©½«IDÉèΪ³¤¶ÈΪ3µÄÊý×Ö×Ö¶Î:int(3)²¢ÈÃËüÿ¸ö¼Ç¼×Ô¶¯¼ÓÒ»:auto_increment²¢²»ÄÜΪ¿Õ:not null¶øÇÒÈÃËû³ÉΪÖ÷×Ö¶Îprimary key£¨2£©½«NAMEÉèΪ³¤¶ÈΪ10µÄ×Ö·û×ֶΣ¨3£©½«ADDRESSÉèΪ³¤¶È50µÄ×Ö·û×ֶΣ¬¶øÇÒȱʡֵΪÉîÛÚ¡£varcharºÍcharÓÐÊ²Ã´Çø±ðÄØ£¬Ö»ÓеÈÒÔºóµÄÎÄÕÂÔÙ˵ÁË¡££¨4£©½«YEARÉèΪÈÕÆÚ×ֶΡ£ Èç¹ûÄãÔÚmysqlÌáʾ·û¼üÈëÉÏÃæµÄÃüÁîÒ²¿ÉÒÔ£¬µ«²»·½±ãµ÷ÊÔ¡£Äã¿ÉÒÔ½«ÒÔÉÏÃüÁîÔÑùдÈëÒ»¸öÎı¾ÎļþÖмÙÉèΪschool.sql£¬È»ºó¸´ÖƵ½c:\Ï£¬²¢ÔÚDOS״̬½øÈëĿ¼\mysql\bin£¬È»ºó¼üÈëÒÔÏÂÃüÁ mysql -uroot -pÃÜÂë < c:\school.sql Èç¹û³É¹¦£¬¿Õ³öÒ»ÐÐÎÞÈκÎÏÔʾ£»ÈçÓдíÎ󣬻áÓÐÌáʾ¡££¨ÒÔÉÏÃüÁîÒѾµ÷ÊÔ£¬ÄãÖ»Òª½«//µÄ×¢ÊÍÈ¥µô¼´¿ÉʹÓã©¡£ ËÄ¡¢½«Îı¾Êý¾Ýתµ½Êý¾Ý¿âÖÐ 1¡¢Îı¾Êý¾ÝÓ¦·ûºÏµÄ¸ñʽ£º×Ö¶ÎÊý¾ÝÖ®¼äÓÃtab¼ü¸ô¿ª£¬nullÖµÓÃ\nÀ´´úÌæ. Àý£º 3 rose ÉîÛÚ¶þÖÐ 1976-10-10 4 mike ÉîÛÚÒ»ÖÐ 1975-12-23 2¡¢Êý¾Ý´«ÈëÃüÁî load data local infile \"ÎļþÃû\" into table ±íÃû; ×¢Ò⣺Äã×îºÃ½«Îļþ¸´ÖƵ½\mysql\binĿ¼Ï£¬²¢ÇÒÒªÏÈÓÃuseÃüÁî´ò±íËùÔڵĿ⡣ Îå¡¢±¸·ÝÊý¾Ý¿â£º£¨ÃüÁîÔÚDOSµÄ\mysql\binĿ¼ÏÂÖ´ÐУ© mysqldump --opt school>school.bbb ×¢ÊÍ:½«Êý¾Ý¿âschool±¸·Ýµ½school.bbbÎļþ£¬school.bbbÊÇÒ»¸öÎı¾Îļþ£¬ÎļþÃûÈÎÈ¡£¬´ò¿ª¿´¿´Äã»áÓÐз¢ÏÖ¡£ ºó¼Ç£ºÆäʵMYSQLµÄ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÓëÆäËüµÄSQLÀàÊý¾Ý¿â´óͬСÒ죬Äú×îºÃÕÒ±¾½«SQLµÄÊé¿´¿´¡£ÎÒÔÚÕâÀïÖ»½éÉÜһЩ»ù±¾µÄ£¬ÆäʵÎÒÒ²¾ÍÖ»¶®ÕâЩÁË£¬ºÇºÇ¡£×îºÃµÄMYSQL½Ì³Ì»¹ÊÇ¡°êÌ×Ó¡°ÒëµÄ¡°MYSQLÖÐÎIJο¼Êֲᡰ²»½öÃâ·Ñÿ¸öÏà¹ØÍøÕ¾¶¼ÓÐÏÂÔØ£¬¶øÇÒËüÊÇ×îȨÍþµÄ¡£¿Éϧ²»ÊÇÏó\"PHP4ÖÐÎÄÊÖ²á\"ÄÇÑùÊÇchmµÄ¸ñʽ£¬ÔÚ²éÕÒº¯ÊýÃüÁîµÄʱºò²»Ì«·½±ã [ Last edited by »ÃÓ°ÎÞºÛ on 2006-11-13 at 08:09 ] |
» ²ÂÄãϲ»¶
¿ÒÇëÓÐѧУÊÕÁô
ÒѾÓÐ6È˻ظ´
Çóµ÷¼ÁÍÆ¼ö
ÒѾÓÐ8È˻ظ´
0854Çóµ÷¼Á
ÒѾÓÐ14È˻ظ´
300Çóµ÷¼Á
ÒѾÓÐ9È˻ظ´
291Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
289 ·Ö105500ҩѧר˶Çóµ÷¼Á(ÕÒBÇøÑ§Ð£)
ÒѾÓÐ4È˻ظ´
³õÊÔ324 ÖÐҩѧ Ò»Ö¾Ô¸ÌìÖÐÒ½ Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
ҩѧÇóµ÷¼Á
ÒѾÓÐ14È˻ظ´
327Çóµ÷¼Á
ÒѾÓÐ27È˻ظ´
¼±Ðèµ÷¼Á
ÒѾÓÐ5È˻ظ´














»Ø¸´´ËÂ¥