Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Îļþϵͳ֮Îļþ¡¢·ÖÇø´óСÏÞÖÆ


LinuxÎļþϵͳ֮Îļþ¡¢·ÖÇø´óСÏÞÖÆ
ÒÔÏÂΪºìñext3ÎļþϵͳËùÖ§³ÖµÄmax file sizeºÍmax filesystem size£º
¶ÔÎļþϵͳ
µÄÏÞÖÆÈçÏ£º
ext3 Îļþϵͳ£¬ºìñÆóÒµ°æ Linux 3 µÄÎļþϵͳ×î´óÊÇ 2TB£¨ÒÑÑéÖ¤£©£¬ºìñÆóÒµ°æ Linux 4 ºÍ 5 Ìá¸ßµ½ÁË
8TB£¨ÒÑÑéÖ¤£©£¬ºìñÆóÒµ°æ Linux 5 Ö§³ÖÎļþϵͳµÄÀíÂÛÖµÊÇ 16TB¡£
GFS ......

LinuxÃüÁîÐÐÐÔÄܼì²â¹¤¾ß

Ô­ÎÄÁ´½Ó£ºhttp://bbs.linuxtone.org/thread-1986-1-1.html ITÔËάר¼ÒÍø--"×ÔÓÉÆ½µÈ£¬»¥Öú·ÖÏí£¡"
ÉÏÃæÒýÓÃÁËIBMºìƤÊé½éÉܵĹØÓÚLinuxÐÔÄÜÐèÒª¿¼ÂǵÄÄÚÈÝ¡£½ñÌì¼ÌÐø½ØÑ¡ºÍÐÞ¸ÄÎĵµÖйØÓÚ¼ì²â²¿·ÖµÄ½éÉÜ£¬µ«Õⲿ·Ö²»ÊǺÜÏêϸ£¬½ñºóÓÐʱ¼äÎÒ»áÔÙ²¹³äһЩ²Î¿¼×ÊÁÏ¡£
¡ù×¢£ºÏÂÃæ¸½Í¼µÄÃüÁîÊä³öÐÅÏ¢£¬ÒÔºìÆìDC Server 5.0 fo ......

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


ÕâÊDZ¾ÎĵõÚÈý²¿·Ö,ÔÚǰÁ½²¿·ÖÖÐ,ÎÒÒѾ­½²ÊöÁËLinux²Ù×÷ϵͳÊÇÈçºÎ±»»úÆ÷bootµ½,²¢ÇÒloadµ½Öƶ¨µÄÄÚ´æµØÖ·µÄ.ÎÒÃǽ«¼ÌÐøµÚ¶þ²¿·ÖµÄÄÚ
ÈÝ,¿´¿´²Ù×÷ϵͳÔÚÍê³ÉÁËbootsect.sºÍsetup.sµÄÔËÐкó,ÔÚhead.sÖÐ×öÁËЩʲô.
ÈÃÎÒÃÇ»ØÒäÒ»ÏÂ,ÔÚsetup.sÖÐ,ÎÒÃǰÑÕû¸ösystemÄ£¿é´ÓµØÖ·0x10000³öÍùÏÂÒÆ¶¯ÁË0x10000µÄ¾àÀë,Ò²¾ÍÊÇ˵,ÏÖ ......

linuxÉ豸Çý¶¯Ñ§Ï°ÐèÒªÕÆÎյĻù´¡¼¼Êõ

      linuxÉ豸Çý¶¯µÄѧϰÊÇÒ»ÏîºÆ´óµÄ¹¤³Ì,¶ÁÕßÐèÒªÊ×ÏÈÕÆÎÕÒÔÏ»ù´¡:
 
1.Á¼ºÃµÄÓ²¼þ»ù´¡,¶®µÃSRAM,FLASH,SDRAM,Ó²Å̵ĶÁд·½Ê½,UART,I2C,USBµÈÉ豸½Ó    ¿Ú,ÂÖѯ,ÖжÏ,DMAµÄÔ­Àí,PCI×ÜÏߵŤ×÷·½Ê½ÒÔ¼°CPUµÄÄÚ´æ¹ÜÀíµ¥Ôª(MMU)µÈ.
 
2.Á¼ºÃµÄCÓïÑÔ»ù´¡,ÄÜÁé»îµØÔ ......

ÈÃlinuxÆô¶¯ºó×Ô¶¯½øÈëͼÐνçÃæ»òÎı¾½çÃæ£¨×ªÔØ£©


a.¿ª»ú½øÈëͼÐνçÃæ£º°²×°Ê±Ñ¡Í¼ÐÎÆô¶¯·½Ê½»ò°Ñ/etc /inittabµÄid:x:initdefault:ÕâÐиijÉid:5:initdefault:¡£
b.¿ª»ú²»½øÈëͼÐνçÃæ£º°²×°Ê±Ñ¡Îı¾Æô¶¯·½Ê½»ò°Ñ/etc/inittabµÄid:x:initdefault:ÕâÐиijÉid:3:initdefault:¡£
*inittabÊÇ×öʲôµÄ£¿
ÔÚKERNELÆðÀ´Ö®ºó£¬½«Éú³ÉµÚÒ»¸ö½ø³Ì——init£¬Êµ¼ÊÉÏÊÇÖ´Ð ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ