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

linuxÏÂÆô¶¯mysqlµÄÃüÁî

 
Ò»¡¢×ܽáһϣº
1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
   mysqladmin start
/ect/init.d/mysql start (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
   mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
   mysqladmin shutdown
   /ect/init.d/mysql   shutdown (Ç°ÃæÎªmysqlµÄ°²×°Â·¾¶)
4.Á¬½Ó±¾»úÉϵÄmysql£º
½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÊäÈëÃÜÂë¡£
Í˳ömysqlÃüÁexit£¨»Ø³µ£©
5.ÐÞ¸ÄmysqlÃÜÂ룺
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
»ò½øÈëmysqlÃüÁîÐÐSET PASSWORD FOR root=PASSWORD("root");
6.Ôö¼ÓÐÂÓû§¡££¨×¢Ò⣺mysql»·¾³ÖеÄÃüÁîºóÃæ¶¼´øÒ»¸ö·ÖºÅ×÷ΪÃüÁî½áÊø·û£©
grant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
ÈçÔö¼ÓÒ»¸öÓû§testÃÜÂëΪ123£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬ ²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬Èëmysql£¬È»ºó¼üÈëÒÔÏÂÃüÁ
grant select,insert,update,delete on *.* to " Identified by "123";
¶þ¡¢ÓйØmysqlÊý¾Ý¿â·½ÃæµÄ²Ù×÷
      ±ØÐëÊ×ÏȵǼµ½mysqlÖУ¬ÓйزÙ×÷¶¼ÊÇÔÚmysqlµÄÌáʾ·ûϽøÐУ¬¶øÇÒÿ¸öÃüÁîÒԷֺŽáÊø
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
     show databases;
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
      use mysql£» £¯£¯´ò¿ª¿â
      show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
    describe ±íÃû;
4¡¢½¨¿â£º
    create database ¿âÃû;
5¡¢½¨±í£º
    use ¿âÃû£»
    create table ±íÃû(×Ö¶ÎÉ趨Áбí)£»
6¡¢É¾¿âºÍɾ±í:
     drop database ¿âÃû;
      drop table ±íÃû£»
7¡¢½«±íÖмǼÇå¿Õ£º
     delete from ±íÃû;
8¡¢ÏÔʾ±íÖеļǼ£º
    select * from ±íÃû;
9¡¢±àÂëµÄÐÞ¸Ä
Èç¹ûÒª¸Ä±äÕû¸ömysqlµÄ±àÂë¸ñʽ£º
Æô¶¯mysqlµÄʱºò£¬mysqld_safeÃüÁîÐмÓÈë
--default-character-set=gbk
Èç¹ûÒª¸Ä±äij¸ö¿âµÄ±àÂë¸ñʽ£ºÔÚmysqlÌáʾ·ûºóÊäÈëÃüÁî
alter database db_name default cha


Ïà¹ØÎĵµ£º

LinuxÍø¹Üѧϰ±Ê¼Ç£¨23£©¼¸µãѧϰÌå»á£¨´ýÐø£©

    µÚÒ»£¬¶à¿´¿´LinuxµÄ¶¯ÏòÐÂÎÅ£¬ÖªµÀLinuxµÄǰ½ø£¬ÒòΪÕâÁªÏµµ½ÁËÓ¦Óõȡ£ÕâЩ¶Ô¾ÍÒµ»òÕßÊÇÑ¡ÔñLinuxÎªÍ»ÆÆµÄÈËÏ൱ÓаïÖú¡£
µÚ¶þ£¬¶àѧϰ»ù´¡µÄ¼¼Äܶ«Î÷£¬Ïñºìñ×ÓÓкܶàµÄLinux»ù´¡µÄ¶«Î÷£¬ÌرðÓÐÀûÓÚѧϰ£¬ÕâµãÎÒÏëºÜ¶àÈ˶¼Õâô˵£¬ºìÁªµÄÈ·¾ÍÊÇLinux½Ì³ÌµÄÉçÇø¡£
µÚÈý£¬Ò»¶¨ÒªÑ§ºÃÃüÁ¼ ......

Linux shell I/OÖØ¶¨ÏòÏê½â

 I/OÖØ¶¨ÏòÏê½â¼°Ó¦ÓÃʵÀý
1¡¢ »ù±¾¸ÅÄÕâÊÇÀí½âºóÃæµÄ֪ʶµÄǰÌᣬÇëÎñ±ØÀí½â£©
a¡¢ I/OÖØ¶¨Ïòͨ³£Óë FDÓйأ¬shellµÄFDͨ³£Îª10¸ö£¬¼´ 0¡«9£»
b¡¢ ³£ÓÃFDÓÐ3¸ö£¬Îª0£¨stdin£¬±ê×¼ÊäÈ룩¡¢1£¨stdout£¬±ê×¼Êä³ö£©¡¢2£¨stderr£¬±ê×¼´íÎóÊä³ö£©£¬Ä¬ÈÏÓëkeyboard¡¢monitor¡¢monitorÓйأ»
c¡¢ Óà < À´¸Ä±ä¶Á½øµÄ ......

linux Íø¿¨Çý¶¯

Tg3 Gbit NIC Driver Analysis
Ôڴ˽ö½öÌÖÂÛÍøÂçÉ豸Çý¶¯µÄÒ»°ãд·¨£¬ÓйØÓ²¼þ²¿·ÖµÄÏà¹Ø´úÂëÓÉÓÚÓ²¼þ¹æ¸ñ²»Í¬£¬ÓèÒÔÊ¡ÂÔ¡£ÓÐʲôµØ·½´íÎ󣬻ò²¹³ä£¬»¶Ó­´ó¼ÒÌá³ö¡£
1, Çý¶¯Ä£¿éµÄ¼ÓÔØºÍÐ¶ÔØ
Èç¹ûÍøÂçÉ豸£¨°üÀ¨wireless£©ÊÇPCI¹æ·¶µÄ£¬ÔòÏÈÊÇÏòÄÚºË×¢²á¸ÃPCIÉ豸(pci_register_driver)£¬È»ºóÓÉpci_driverÊý¾Ý½á¹¹Öе ......

Rebuild GRUB ÕÒ»ØÊ§È¥µÄlinuxϵͳ

 
 
ÎҵĵçÄÔÒ»¸öÓ²ÅÌ£¬×°XP+Fedora8£¬Ç°¶Îʱ¼äXPÄÖ±ðŤ£¬ÎÞÄÎÏÂ֨װÁËXP£¬¿ÉÕâÑù¾Í½ø²»ÁËFedoraÁË¡£ һֱûɶÊ£¬ËùÒÔÒ²¾Íû¹Ü¡£
×î½üÐèÒªÓõ½linuxÁË£¬ÓÖ²»Ïë֨װFedora8£¨°²×°ºÃÂý£¬»¹ÒªÉý¼¶É¶µÄ£©£¬ÓÚÊÇÉÏÍøÕÒ½â¾ö°ì·¨£¬»¹Õæ¾ÍÕâÑù¸ãºÃÁË£¬Ë³Àû½øÈëÁËFedora£¬²»ÓÃ֨װ£¬Ë¬¡«  ·½·¨ÈçÏ£º
1.Fedora°² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ