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

Linux Ï mysql µÄÏà¹ØÃüÁî

1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
  
   ÒѾ­ÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
   ÎÊÌ⣺
   cat  /etc/mysql/my.conf
   ÕÒµ½ÏÂÃæÒ»ÐÐ
   bind-address   = 127.0.0.1
   ΪÁËÊý¾ÝµÄ°²È«£¬Ä¬ÈÏMySQLÖ»ÊغòÔÚ127.0.0.1ÉÏ£¬Ç°ÃæÊÇûÓÐ×¢Ê͵ģ¬ËùÒÔ¾ÍÖ»Äܱ¾»ú·ÃÎÊ¡£
   ½â¾ö°ì·¨£º
   ÔÚbind-address  Ç°Ãæ¼ÓÉÏ×¢ÊÍ£¬ÖØÆðMYSQL¾ÍOKÁË
   
   µÚ¶þ²½£º
  
    mysql>use mysql;
    mysql>update user set host = '%'   where user ='root';
    mysql>flush privileges;
    mysql>select 'host','user' from user where user='root';
    ÓÃÉÏÃæµÄÃüÁîÐ޸ģ¡ ÖØÆômysql
  
3. Êý¾Ý¿âµ¼³öºÍµ¼Èë
ÏÂÃæµÄÀý×ÓÏÔʾÔõÑùµ¼³öÒ»¸öMySQLÊý¾Ý¿â£¬¾­³£½«Êý¾Ýµ¼³ö×ö¸ö±¸·Ý»¹ÊDZØÒªµÄ£¬puttyµÇ½·þÎñÆ÷£¬½øÈëÄãÒª±¸·ÝÊý¾Ý¿âµÄĿ¼£¬±¸·ÝÍê±Ïºó£¬Êý¾Ý¿âÎļþ½«±£´æÔÚ¸ÃĿ¼£¬ÔÚÃüÁîÐеIJÙ×÷²½ÖèÈçÏ£º
(1). mysqldump -u username -p database_name > 20090708.sql
(2). »Ø³µ
(3). ÌáʾÊäÈëÃÜÂë
(4). ÊäÈëÃÜÂ룬»Ø³µ.
ÉÏ´«MySQLÊý¾Ý¿â±¸·ÝÎļþ(±ÈÈçÉÏÃæµ¼³öµÄÎļþ20090708.sql)µ½ÄãµÄ·þÎñÆ÷ÉÏ£¬»òÕß´ÓÄãµÄзþÎñÆ÷ͨ¹ýwgetÃüÁî(ÉÏÃæÓÐÌáµ½)Ö±½ÓÏÂÔØÊý¾Ý¿âÎļþµ½Ð·þÎñÆ÷£¬È»ºóÖ´ÐÐÈçÏÂÃüÁ
(1). mysql -u username -p database_name < 20090708.sql
(2). »Ø³µ
(3). ÌáʾÊäÈëÃÜÂë
(4). ÊäÈëÓû§Ãû¶ÔÓ¦µÄÃÜÂ룬»Ø³µ.
ÆäÖÐusername, password ºÍ database_name ¾ÍÊÇMySQLÊý¾Ý¿âµÄÓû§Ãû¡¢ÃÜÂë ºÍ Êý¾Ý¿âÃû¡£Îļþbak.sql¾ÍÊÇMySQLÊý¾Ý¿âµÄ±¸·ÝÎļþÃû³Æ¡£µ¼È뵽зþÎñÆ÷µÄʱºò£¬Êý¾Ý¿âÃû³ÆºÍÓû§Ãû³Æ×¢ÒâÒª¸úеÄÆ¥Åä¡£


Ïà¹ØÎĵµ£º

mysql°²×°µÄ¹ý³Ì

   ½ñÌìÖØÐÂ×°ÁËÒ»ÏÂmysqlÊý¾Ý¿â£¬½ØÖ¹µ½ÏÖÔÚÒѺÄʱ2£º30£¬ÓôÃÆ£¡£¡£¡£¡£¨ÎÒÔ­À´²»ÖªµÀ×°¹ý¶àÉÙ´Îmysql£©
   ËùÒÔÎÒ¾ö¶¨£¬°Ñ¹ØÓÚmysqlÊý¾Ý¿âµÄ³õʼ»¯²Ù×÷½éÉÜÒ»ÏÂ
£º
    1.°²×°mysqlÊý¾Ý¿â
       http://www.duote.com/tech/1/2430_1.html
  ......

MySQL µÄ´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢º¯Êý¡¢ÊÓͼʵÑé

    ±¾ÊµÑéÍê³ÉÈçϽá¹û£º
    0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
    1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
    2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
    3. ¸ù¾ ......

linuxÄÚºËÇé¾°·ÖÎö{ÐźŠ½ø³Ì}

Allocaº¯Êý£¬ÓÃÓÚÔÚÕ»ÉÏ·ÖÅäÄڴ棬
gcc
µÄ¶¯Ì¬Êý×é¾ÍÊÇͨ¹ýËüÀ´Ö§³ÖµÄ¡£
ÖжϺÍÐźŵĸÅÄîÊDz»Í¬µÄ£¬ÐźÅÊÇ·¢¸ø½ø³ÌµÄ£¬Ó²ÖжÏÊÇÄں˺ÍÓ²¼þÖ®¼ä£¬¶¼ÊÇÒì²½µÄ£¬²»¿ÉÔ¤ÖªµÄ¡£
ϵͳµ÷ÓýøÈëÄÚºËÊDz»·¢Éú½ø³ÌÇл»µÄ¡£DIRECT_IO
²»Ê¹ÓÃϵͳ
IO
»º´æ£¬»¹Òª±£Ö¤»º³åÇøÄÚ´æ²»±»
swap
£¬Õâ¸öÓÃÓÚÄÇЩÓû§²ã½øÐлº´æµÄÓ¦ÓÃ³Ì ......

linuxÏ°²×°php_mbstringÀ©Õ¹


phpMyAdminÌáʾû×Ö·û´®±àÂëºÍ×Ö·û´®´¦Àí¿âphp_mbstring
SSHÁ¬½ÓÉϺó£ºyum install php-mbstring°²×°À©Õ¹
vi usr/local/lxlabs/ext/php/etc/php.ini±à¼­PHP.iniÎļþ
È¥µôÒ»ÐеÄ×¢ÊÍ£ºextension=mbstring.so
(ÓÐЩ¿ÉÒÔ²»ÓÃÉèÖÃÕâÁ½ÐУ¬php.iniÖв»´æÔÚ£»extension=mbstring.so
£¬
Ö»ÒªmbStringÀ©Õ¹°²×°µ½ÁËextension ......

Linux¿ª»úÆô¶¯Oracle

ÔÚ/etc/rc.localÖÐÌí¼Ó
su - oracle "-c dbstart"
ÔÚ´Ë֮ǰÄãҪȷ±£¸ÃÃüÁî¿ÉÒÔÆô¶¯ÄãÐèÒªµÄÊý¾Ý¿â, ÐèÒª²âÊÔÒ»ÏÂ
su - oracle "-c dbstart"
dbstartÃüÁîÕý³£ÔËÐÐÐèÒªÅäÖÃ/etc/oratab,ÀïÃæ¿ÉÒÔÅäÖöà¸öÊý¾Ý¿âʵÀý,ÿ¸öµÄ¸ñʽ:
$ORACLE_SID:$ORACLE_HOME:<N|Y>
Õý³£Çé¿öÏÂÅäÖúÃ/etc/oratab, dbstartÃüÁî¾Í¿ÉÒÔÕý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ