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Îļþϵͳ֮Îļþ¡¢·ÖÇø´óСÏÞÖÆ
ÒÔÏÂΪºìñext3ÎļþϵͳËùÖ§³ÖµÄmax file sizeºÍmax filesystem size£º
¶ÔÎļþϵͳ
µÄÏÞÖÆÈçÏ£º
ext3 Îļþϵͳ£¬ºìñÆóÒµ°æ Linux 3 µÄÎļþϵͳ×î´óÊÇ 2TB£¨ÒÑÑéÖ¤£©£¬ºìñÆóÒµ°æ Linux 4 ºÍ 5 Ìá¸ßµ½ÁË
8TB£¨ÒÑÑéÖ¤£©£¬ºìñÆóÒµ°æ Linux 5 Ö§³ÖÎļþϵͳµÄÀíÂÛÖµÊÇ 16TB¡£
GFS ......
Ò»¡¢É豸Îļþ
¡¡¡¡LinuxϵÄ/dev Ŀ¼ÖÐÓдóÁ¿µÄÉ豸Îļþ¡£Ö÷ÒªÊÇ¿éÉ豸ÎļþºÍ×Ö·ûÉ豸Îļþ¡£¡¡¡¡¿éÉ豸Îļþ¡¡¡¡ÔÚ¹ýÈ¥£¬ÔÚÌí¼ÓдÅÅ̺ó£¬ÍùÍùÐèÒªÊÖ¶¯Ôö¼Ó¿éÉ豸Îļþ¡£ÏÖÔÚͨ³£ÎÒÃDz»ÐèÒªÊÖ¶¯Ôö¼Ó¿éÉ豸Îļþ£¬ÔËÐÐÒ»ÏÂservice kudzu start £¬ÏµÍ³¾Í»á×Ô¶¯ÎªÄúÅäÖÃÏàÓ¦µÄÉ豸¡£¿éÉ豸µÄÖ÷ÒªÌØµãÊÇ¿ÉÒÔËæ»ú¶Áд£¬¶ø×î³£¼ûµ ......
¸ÅÊö
1. “/etc/profile”Îļþ
2. “bdflush”²ÎÊý
3. “ip_local_port_range”²ÎÊý
4. “/etc/nsswitch.conf”Îļþ
5. “/proc”Îļþϵͳ
6. “ulimit”²ÎÊý
7. Ôö¼Óϵͳ´ò¿ªµÄÎļþÊýÄ¿
8. Îļþ“atime”ÊôÐÔ
9. ÎļþµÄ“noatime&rd ......
×÷Õߣº¸ßÕÅÔ¶Öõ(HiLoveS)
²©¿Í£ºhttp://www.cnblogs.com/hiloves/
×ªÔØÇë±£Áô¸ÃÐÅÏ¢
XManager ÊÇÒ»¸ö¼òµ¥Ò×ÓõĸßÐÔÄܵÄÔËÐÐÔÚWindowsƽ̨ÉϵÄX-ServerÈí¼þ£¬¶øGnomeºÍKDE¾ÍÊÇX-Client£¬LinuxϵÄX- ServerÔòΪXorg¡£ËüÄܰÑÔ¶¶ËUnix/LinuxµÄ×ÀÃæÎÞ·ìµØ´øµ½ÄãµÄWindowsÉÏ£¬ÉõÖÁµ±ÄãµÄµçÄÔÊÇÔÚÄÚÍø»ò·À»ðǽºó£¬ÄãÒ²ÄÜͨ ......
ÏȲο´Ò»ÏÂĿ¼ÏµÄREADMEÎĵµ
Ö÷ÒªÓÐÒÔϼ¸¸ö²½Ö裺
1) perl **.PL Éú³Émakefile Îļþ
2) make
3) make test (this is optional£¬Èç¹ûÕⲽûɶÎÊÌâ,»áÏÔʾһÇÐok)
4) make install
³öÏÖµÄÎÊÌ⣬¶à¿´ÏÂÌáʾ£¬Ò»°ã¶¼ÊÇȱ°üÉÙ¿â ......