红帽Linux企业内训之二

1.Linux01.1.1.1.MySQLEditedBy00002010-6-401.01.01.01.linuxLLLL)SAMBA,NFS,FTPL2)SAMBA//IP13)NFS.LL,windows.4)NFSmount-tnfsIP:/15)FTPftpIP11)/etc/exportsNFSIP/tmp192.168.102.0/255.255.255.0(rw,sync)192.168.102.0/241/tmpsync.步2)serviceportmaprestartservicenfsrestart3)exportfs-arv01(.exportsinfs)4)1mount-tnfsNFSIP:/1mount-tnfs192.168.102.4:/tmp/home192.168.102.4/tmp/home/etc/fstabNFSip:nfsdefaults005)/etc/exports/tmp192.168.0.0/255.255.0.0(ro).192.168.0.0/16LinuxservicenfsstopNFSserviceportmaprestartPortmapservicenfsrestartNFSshowmount-eIP/NFSnfsmount-tnfsIP:/mount-tnfs192.168.200.101:/tmp/abc2FTPFTPFileTransferProtocalftpwu-ftpd,vsftpd,proftpd,server-uwu-ftpdvsftpverysecureftpvsftp:servicevsftpdstartvi/etc/vsftpd/vsftpd.confftplftpIP:lftpftpgetmget*.cftpexit/var/ftp/avsftpd.confuserlist_deny=YESuserlist_file=/etc/vsftpd/user_list:dirmessage_enable=YESpam_service_name=vsftpduserlist_enable=YESbanonymous_enable=NOcuseraddftp,passwdvipw(selinuxftphome;selinuxsetenforce0,setenforce1permissivegetenforce;duid=500;eselinuxselinux;LinuxfLinuxwget-p://yp1:@192.168.x.x/b.cftp://:@IP3SAMBA1)/etc/samba/smb.confSAMBAabc,/mys,yp-1()#=======================GlobalSettings=====================================[global]workgroup=MYGROUPsecurity=user#share[abc]comment=Mary'sandFred'sstuffpath=/mysvalidusers=yp-1;validusers=@ypyp;smbpasswd;public=no;writable=yes;chmod,selinuxprintable=no#browseable=no;\\IP\#browseable=yes;createmask=0765windowsnetuse*/delete2)SMBsmbpasswd-auseraddsmbpasswd3)servicesmbrestart:servicesmbreloadrestart4)aLinuxsmb://IPbwindows\\IP4Linux1--windowsvncserver2vncrpmvncvieweraIP:0(linux)bvncviewerIP(windows)vncviewer-viauser@hostlocalhost:1#vnc359005WEBLinux+Apache+mysql+phpLAMPWindows+IIS+Sqlserver+aspLinux+weblogic/jboss/resin/websphre/tomcat+Oracle+javaphpaspjspapache1)servicehttpdrestart2)vi/etc/httpd/conf/httpd.conf3)Listen80Listen80804))servicehttpdrestartapache/usr/local/apache/bin/apachectlrestart6)index.html/var/)GB2312/etc/httpd/conf/httpd.confAddDefaultCharsetUTF-8AddDefaultCharsetGB23128)httpd.confservicehttpdconfigtesthttpd-t(IP,IP)1)192.168.100.xxxx.alading.com192.168.100.xxyy.alading.com2)/etc/httpd/conf/httpd.conf3)VirtualHost/VirtualHost#VirtualHost,VirtualHost*:[e-mail]/*:[e-mail]/)NameVirtualHost*:80#5)#DocumentRoot/var/)/)servicehttpdrestart8);:NameVirtualHost*:80VirtualHost*:[e-mail]/web1ServerNameweb1.comErrorLoglogs/dummy-host.example.com-error_logCustomLoglogs/dummy-host.example.com-access_logcommon/VirtualHostVirtualHost*:[e-mail]/var/)htpasswd-c/etc/httpd/my123my123-c2)/etc/httpd/conf/httpd.confDirectoryAuthTypeBasicAuthNameAuthUserFile/etc/httpd/my123Requireuser12Linux/Directory3)servicehttpdrestart4)7MySQLMySQL:1)(MyISAM65536T)2)()3);1)information_schema:2)mysql:3)test:servicemysqldrestartmysqlmysql--MySQL1mysql2root3mysqladmin-urootpasswordroot()mysql-uroot-pmysqladmin-uroot-ppassword;mysqladminrootmysql.userpassword3mysql-u-p4mysql-hIP/-u-p5showdatabases;status;;showtablestatuslike''\G;6use;7dropdatabase;8createdatabase;9createtable(12...,primarykey());int,date,char,varchar,double,text;createtablestudent(snovarchar(7)notnull,snamevarchar(20)notnull,primarykey(sno));10droptable11createtable1like22112showtables;Linuxshowcreatetable;13describe;14altertableadd15altertablemodify;altertablechange1212altertablemodifyfirst;;16altertabledrop;17altertable1renameto2;1218xs,saddresssbirthdaysage,int,xsxstable,mysqlaltertablexs-addsaddressvarchar(25),-changesbirthdaysageint(3),-renametoxstable;19insertinto(12...)notnullmysqlinsertintostudent(sno,sname,ssex,sbirthday,sdepa)-values('001','liuhao','M',19870624,'math');select*fromorderbylimit2,3;(2,3);mysqlselect*fromkkk;mysqlselect*fromkkk;+------+------+|name|dept|+------+------+|peng|tec||hao|tec||yp|tec||py|sale||liu|tec||mao|sale|+------+------+mysqlselectdept,count(1)fromkkkgroupbydept;+------+----------+|dept|count(1)|+------+----------+|sale|2|Linux|tec|4|+------+----------+3mysqlselectdept,count(1)fromkkkgroupbydepthavingcount(1)3;+------+----------+|dept|count(1)|+------+----------+|tec|4|+------+----------+mysqlselect*fromkkk;+------+------+------+|name|dept|sal|+------+---