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

Linux °²×°mysql

 
1¡¢¶þ½øÖÆÎļþ£¨tar.gz£©°²×°
ÏÈ´´½¨Óû§ºÍÓû§×é
 su - root
groupadd mysql
useradd -g mysql mysql
½âѹ¶þ½øÖÆÎļþ¡£
gunzip -c filename | tar -xf -
¸´ÖÆĿ¼/home/mysqlµ½/usr/local£»
´´½¨mysqlÐí¿É±í£º
linux:/usr/local/mysql #scripts/mysql_install_db --user=mysql
ÉèÖöþ½øÖÆËùÓÐȨ£¬Ê¹Ö®¹érootËùÓУ¬²¢ÊôÓÚmysqlËùÔÚ¹ÜÀí×飺
linux:/usr/local/mysql # chown -R root /usr/local/mysql
linux:/usr/local/mysql # chgrp -R mysql/usr/local/mysql
½«Êý¾ÝĿ¼µÄËùÓÐȨÉèÖÃΪmysql¹ÜÀíÓû§£º
linux:/usr/local/mysql # chown -R mysql /usr/local/mysql/data
Æô¶¯·þÎñÆ÷£º
linux:/usr/local/mysql # bin/mysqld_safe --user=mysql &
µÇÈ룺
linux:/usr/local/mysql # bin/mysql -u mysql
mysql>show databases;
×î³õÖ»ÓÐÁ½¸ö£ºtest£¬information_schema£»
ÒÔrootÉí·ÝµÇÈëÔòÓÐËĸö¡£
ÔËÐÐÃüÁîbin/mysql -u root -p£¬´Ëʱ½«³öÏÖpassword:£¨ÒªÇóÊäÈëÃÜÂ룩£¬µ«Ä¬ÈÏÇé¿öÏÂrootÓû§Ã»ÓÐÃÜÂ룬ËùÒԻسµ¼´¿É¡£´Ëʱ½«½øÈëMySQL½çÃ棬µ±È»ÈÔȻֻÊǸöÃüÁîÐд°¿Ú¶øÒÔ¡£
 
2¡¢´´½¨Óû§²¢ÊÚȨ
´´½¨Ò»¸ö¿ÉÒÔ´ÓÈκεط½Á¬½Ó·þÎñÆ÷µÄÒ»¸öÍêÈ«µÄ³¬¼¶Óû§£¬µ«ÊDZØÐëʹÓÃÒ»¸ö¿ÚÁîuas×öÕâ¸ö
mysql> grant all privileges on *.* to uas@’%’ identified by ’uas with;
×¢Ò⣺ÔÚmysqlÊý¾Ý¿âÖеÄuser±íÖУ¬½øÐв鿴£¬É¾³ýÖظ´Êý¾ÝºÍ²»ºÏ·¨µÄÊý¾Ý
ÈçÏàͬµÄhostÏÂÓÐÏàͬµÄÓû§»òÕßÓû§ÃûΪ¿Õ
3¡¢ÐÞ¸Ä×Ö·û¼¯
 
windowsÏÂÊÇmy.ini
linuxÏÂÊÇmy.cnf
 
locate my.cnf¾Í³öÀ´ÁË£¨Ã»ÓеĻ°ÏÈupdatedb£©
Ôö¼Ó»òÐÞ¸ÄÈçÏÂÅäÖÃ
[mysqld]
default-character-set=utf8
 
[mysql.server]
default-character-set=utf8
 
[mysqld_safe]
 
default-character-set=utf8
 
[client]
default-character-set=utf8
 
[mysql]
default-character-set=utf8
 
½øÈëmysqlÊý¾Ý¿âÓÃstatus;¿´¿´×´Ì¬¡£ÓÃÃüÁîÐ޸ĵÄÉèÖã¬ÔÚmysqlÖØÐÂÆô¶¯ºó»Ø±ä»ØĬÈÏÖµ
 
4¡¢µ¼ÈëÊý¾Ý¿â±í½á¹¹
ÏÈ´´½¨Êý¾Ý¿â£¬ÔÙÔÚÕâ¸öÊý¾Ý¿âϵ¼Èë±í½á¹¹¸ñʽÈçÏ£º
create database name; ´´½¨Êý¾Ý¿â
mysql > mysql -h myhost -u root -p database < sql.txt
 
ÀýÈ磺
mysql > create database uas;
mysql > mysql -h myhost -u root -p uas < sq


Ïà¹ØÎĵµ£º

LinuxÌØÊâÎļþ£¨2£©——Á´½ÓÎļþ

µÚ¶þÕ Á´½ÓÎļþ
¡¡¡¡Á´½ÓÎļþÓеãÀàËÆÓÚWindows µÄËùν¿ì½Ý·½Ê½£¬µ«²¢²»ÍêÈ«Ò»Ñù¡£Á´½ÓÓÐÁ½ÖÖ·½Ê½£¬ÈíÁ´½ÓºÍÓ²Á´½Ó¡£
¡¡¡¡ÈíÁ´½ÓÎļþ
¡¡¡¡ÈíÁ´½ÓÓֽзûºÅÁ´½Ó£¬Õâ¸öÎļþ°üº¬ÁËÁíÒ»¸öÎļþµÄ·¾¶Ãû¡£¿ÉÒÔÊÇÈÎÒâÎļþ»òĿ¼£¬¿ÉÒÔÁ´½Ó²»Í¬ÎļþϵͳµÄÎļþ¡£Á´½ÓÎļþÉõÖÁ¿ÉÒÔÁ´½Ó²»´æÔÚµÄÎļþ£¬Õâ¾Í²úÉúÒ»°ã³Æ֮Ϊ"¶ÏÁ´"µÄÎÊÌ ......

LinuxÖÐfind³£¼ûÓ÷¨Ê¾Àý


·find   path   -option   [   -print ]   [ -exec   -ok   command ]   {} \;
#-print ½«²éÕÒµ½µÄÎļþÊä³öµ½±ê×¼Êä³ö
#-exec   command   {} \;      -----½«²éµ½µ ......

linuxÆô¶¯¹ý³ÌdzÎö(1)


ûÓÐÔĶÁ¹ýÔ´Âë֮ǰ,¶Ô²Ù×÷ϵͳ×ÜÊDZ§ÓÐÉñÃظÐ,×ÜÊÇÈÏΪ²Ù×÷ϵͳÊǺܰÂÃîµÄ¶«Î÷. Æäʵ,¶ÔÓÚÒ»¸öÓÐÒ»¶¨±à³Ì»ù´¡ºÍϵͳ֪ʶµÄ³ÌÐòÔ±,²Ù×÷ϵͳ²¢²»ÊÇ¿ÉÍû¶ø²»¿É¼°µÄ¶«Î÷. ²Ù×÷ϵͳµÄ×îÖÕÄ¿±êÖ»ÊÇÔÚÓ¦ÓóÌÐò²ãÃæÓëÓ²¼þ²ãÃæÖ®¼ä×öµÄÒ»²ãЭµ÷,¿ÉÄÜÕâ¸ö¶¨ÒåÓÐЩƬÃæ,µ«±¾×ÅÕâÑùµÄ˼Ïë¶Á´úÂëÓ¦¸Ã»áÇáËÉÒ»µã.
ÓÉÓÚ·¢Õ¹µ½ÏÖÔÚ,LINU ......

linuxÆô¶¯¹ý³ÌdzÎö(2)

ÔÚ±¾ÎĵĵÚһƪÖÐ,ÎÒÖ÷Òª¶Ôbootsect.s½øÐÐÁ˽²Êö. ÔÚµÚ¶þ²¿·ÖÖÐ,ÎÒ½«¶Ôsetup.s½øÐÐÃèÊö,ÎÒ½«ÆäÊÓΪÊÇLinuxÆô¶¯µÄµÚ¶þ²½Öè.
²Ù×÷ϵͳµÄÆô¶¯¹ý³ÌÊÇÒ»¸öÂþ³¤¶øÓÐÐòµÄ¹ý³Ì,¸÷¸ö½×¶Î¶¼ÓÐÆ䲻ͬµÄ×÷ÓÃ. boot;setup;initËäÈ»¿´Ëƺܽӽü,µ«ÊÇÈ´ÊÇÍêÈ«²»Í¬µÄ¹ý³Ì.ËûÃǸ÷˾ÆäÖ°,°´²¿¾Í°à.boot±È½Ï׼ȷµÄ·­ÒëÓ¦¸ÃÊÇÒýµ¼,¶øsetupµÄ·­Òë ......

LinuxÏÂperlÄ£¿éµÄ°²×°

ÏȲο´Ò»ÏÂĿ¼ÏµÄREADMEÎĵµ
Ö÷ÒªÓÐÒÔϼ¸¸ö²½Ö裺
1) perl **.PL  Éú³Émakefile Îļþ
2) make
3) make test (this is optional£¬Èç¹ûÕⲽûɶÎÊÌâ,»áÏÔʾһÇÐok)
4) make install
³öÏÖµÄÎÊÌ⣬¶à¿´ÏÂÌáʾ£¬Ò»°ã¶¼ÊÇȱ°üÉÙ¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ