且行且歌

摘要：http://dev.mysql.com/doc/refman/5.1/en/show-columns.htmlThe Key field indicates whether the column is indexed:If Key is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, non-unique index.If Key is PRI, the column is a PRIMARY KEY or is one of the 阅读全文

摘要：mysql> show create table tb_common_member;+------------------+----------------------------------------------------+| Table | Create Table |+------------------+----------------------------------------------------+| tb_common_member | CREATE TABLE `tb_common_member` ( `uid` mediumint(8) unsigned NO 阅读全文

摘要：Some assumptionsThis tutorial assumes that you are running at least PHP 5.3.3 with the Apache web server and MySQL, accessible via the PDO extension. Your Apache installation must have the mod_rewrite extension installed and configured.You must also ensure that Apache is configured to support.htacce 阅读全文

摘要：vsftpd有三种访问方式：匿名用户，本地用户和虚拟用户[root@DBSVR02 ~]# vim /etc/vsftpd/vsftpd.conf[root@DBSVR02 ~]# vim /etc/vsftpd/ftpusers[root@DBSVR02 ~]# vim /etc/vsftpd/user_list======================================C:\Users\Administrator>ftp 168.168.80.9连接到 168.168.80.9。220 (vsFTPd 2.2.2)用户(168.168.80.9:(none)): ro 阅读全文

摘要：--list 后面可以加 服务名称 就只输出此服务的信息例如#chkconfig httpd on就可以把httpd服务 设置为自动启动了再次查看#chkconfig --list httpdhttpd 0:off 1:off 2:on 3:on 4:on 5:on 6:off这个时候2~5都是on，设置成功。相反的#chkconfig httpd off 就是 关闭自动启动最后 还有个 --level 应该是对 0-6 某些 等级进行单独设置#chkconfig --level 35 httpd on 将3和5 设置成on=================================== 阅读全文

摘要：[root@DBSVR02 ~]# whoroot pts/0 2013-05-03 15:07 (dbsvr02)root pts/1 2013-05-03 16:21 (dbsvr02)[root@DBSVR02 ~]# who am iroot pts/1 2013-05-03 16:21 (dbsvr02)[root@DBSVR02 ~]# 阅读全文

摘要：locale:localencode,即本地编码的意思。这个命令不带任何参数就是显示当前系统的字符集编码。也可以设置环境变量但是单引号怎么一直显示乱码，比如Don't就显示Don和乱码。。。这个一直没解决，不知道是什么问题。[root@DBSVR02 ~]# localeLANG=en_US.UTF-8LC_CTYPE="en_US.UTF-8"LC_NUMERIC="en_US.UTF-8"LC_TIME="en_US.UTF-8"LC_COLLATE="en_US.UTF-8"LC_MONETARY=& 阅读全文

摘要：何在Linux环境下添加Oracle用户信息呢？下文对Oracle用户信息的添加方法作了详细的介绍，希望可以让您对Oracle用户信息方面有更深的认识。创建一个用户组oinstall：# groupadd oinstall创建一个用户组dba：# groupadd dba创建一个用户主目录/u01/oracle：# mkdir -p /u01/oracle创建用户oracle 到主组oinstall，副组dba，主目录/u01/oracle：# useradd -g oinstall -G dba -d /u01/oracle oracle如果oracle用户已经存在则：# usermod - 阅读全文

该文被密码保护。

摘要：Q.I would like to only download the packages via yum and not install/update them. How do I download a RPM package using yum command under CentOS Enterprise Linux server 5.x or RHEL 5.x systems?A.You need to install plugin called yum-downloadonly. This plugin adds a --downloadonly flag to yum so that 阅读全文

摘要：netstat命令是一个监控TCP/IP网络的非常有用的工具，它可以显示路由表、实际的网络连接以及每一个网络接口设备的状态信息输出结果可以分为两个部分，一个是Active Internet connections，另一个是Active UNIX domain sockets.[root@DBSVR02 conf]# netstatActive Internet connections (w/o servers)Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 168.168.80.9:ssh 168.168.80.1 阅读全文

摘要：一直想不明白的pts和tty的区别:我先用xShell登录，这个登录就是pts/0， 或者pts/1，或者pts/2。。。。。再直接从服务器端登录，这个登录就是tty1, 就是不知道会不会有tty2，tty3。。。。 阅读全文

摘要：一直想不明白的pts和tty的区别: 阅读全文

摘要：使用单用户模式有一个前提，就是您的系统引导器（grub）能正常工作，否则要进行系统维护就要使用修复模式。特注：进入单用户模式，没有开启网络服务，不支持远程连接CentOS系统中不同的运行级别（Run Level）代表了系统的不同运行状态，例如 Linux 服务器正常运行时处于运行级别3，是能够提供网络服务的多用户模式；而运行级别 1 只允许管理员通过服务器主机的单一控制台进行操作，即“单用户模式”。以CentOS系统为例：CentOS系统进入单用户模式。进入单用户模式的前提是CentOS系统引导器能正常工作。下面以 GRUB 为例说明进入方法。I. 加电，启动到如下界面时，按ESC:II. 进 阅读全文

摘要：[root@DBSVR01 e]# service httpd statushttpd is stopped[root@DBSVR01 e]# apachectl starthttpd: Could not reliably determine the server's fully qualified domain name, using 168.168.80.8 for ServerName[root@DBSVR01 e]# vim /etc/hosts[root@DBSVR01 e]# [root@DBSVR01 e]# apachectl starthttpd: Could no 阅读全文

摘要：[root@DBSVR01 e]# yum install php-xml.i686Loaded plugins: fastestmirror, securityLoading mirror speeds from cached hostfile* base: centos.ustc.edu.cn* extras: centos.ustc.edu.cn* updates: ftp.twaren.netSetting up Install ProcessResolving Dependencies--> Running transaction check---> Package ph 阅读全文

摘要：PDO is an acronym for PHP Data Objects. PDO is a lean, consistent way to access databases. This means developers can write portable code much easier. PDO is not an abstraction layer like PearDB. PDO is a more like a data access layer which uses a unified API (Application Programming Interface).How t 阅读全文

该文被密码保护。

该文被密码保护。

摘要：mysql> create table ss(id int unsigned not null primary key auto_increment, user_name varchar(15) not null);Query OK, 0 rows affected (0.00 sec)mysql> mysql> insert into ss(id,user_name) values(1, 'jojo');Query OK, 1 row affected (0.00 sec)mysql> insert into ss(id,user_name) valu 阅读全文

摘要：[root@DBSVR01 e]# service mysqld statusmysqld is stopped[root@DBSVR01 e]#==================================[root@DBSVR01 e]# service mysqld startInitializing MySQL database: Installing MySQL system tables...OKFilling help tables...OKTo start mysqld at boot time you have to copysupport-files/mysql.se 阅读全文

摘要：[root@DBSVR01 e]# mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@DBSVR01 e]#=======================删除user.user中值为NULL的,或更新NULL为test 1)delete from user where user is NULL 2)update user set user=‘test‘ where user 阅读全文

摘要：[root@DBSVR01 e]# which mysql/usr/bin/mysql[root@DBSVR01 e]# whereis mysqlmysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz[root@DBSVR01 e]# 阅读全文