第一次登录的密码在~/.mysql_secret中 ?12345[html] cat .mysql_secret  进入mysql之后需要设置密码,否则不能进行任何操作,如果提示ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords. \  那么也需要重新设置密码 MySQL文档中词条MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS有下面的信息 查找SET PASSWORD 为root用户设置新密码 ?12set password for ‘root’@'localhost’=password(‘newpassword’) 之后可以进行正常的操作

Linux下apach+ssl自动启动的脚本 )配置apache启动时自动提取ssl_mod密码脚本#cd  /usr/local/apache2/conf/extra#cp   httpd-ssl.conf  httpd-ssl.conf.bak   --做个备份#vi /usr/local/apache2/conf/extra/httpd-ssl.conf注释SSLPassPhraseDialog  builtin在后添加SSLPassPhraseDialog  exec:/usr/local/apache2/conf/apache_pass.sh #vi /usr/local/apache2/conf/apache_pass.sh输入：#!/bin/shecho "密码"    ---密码写启动apache时所用的ssl_mod密码（即server.key的内容） #chmod  500  /usr/local/apache2/conf/apache_pass.sh     --使apache_pass.sh文件只有root可见，增加安全性#chmod +x /usr/local/apache2/conf/apache_pass.sh  （或者上句直接改成511，省掉此句）。b)配置apache开机自动启动脚本当手动编译安装apache服务器后一般不会开机自动运行，需要自己添加：# cd /etc/init.d# vi apache2加上以下脚本#!/bin/sh# description: Apache auto start-stop script.# chkconfig: - 85 15APACHE_HOME=/usr/local/apache2AP...

Compiling and Installing This document covers compilation and installation of the Apache HTTP Server on Unix and Unix-like systems only. For compiling and installation on Windows, see Using Apache HTTP Server with Microsoft Windows and Compiling Apache for Microsoft Windows. For other platforms, see the platform documentation. Apache httpd uses libtool and autoconf to create a build environment that looks like many other Open Source projects. If you are upgrading from one minor version to the next (for example, 2.2.50 to 2.2.51), please skip down to the upgrading section. Overview for the impatient Requirements Download Extract Configuring the source tree Build Install Customize Test Upgrading Third-party packagesSee alsoConfigure the source treeStarting Apache httpdStopping and RestartingCommentsOverview for the impatient Download $ lynx http://httpd.apache.org/download.cgi Extract $ gzip -d h...

Redflag Linux SP3安装apache时 apr报错解决 rm: cannot remove `libtoolT': No such file or directory 在configure里面 RM='$RM  -f'   这里的$RM后面一定有一个空格。 如果后面没有空格，直接连接减号，就依然会报错。把RM='$RM'改为RM='$RM  -f'

安装apr报错rm: cannot remove `libtoolT': No such file or directory直接打开/usr/local/src/apr-1.4.6/configure  把 $RM“$cfgfile” 那行删除掉 $RM“$cfgfile” 大约在 42302行然后再重新运行  ./configure  --prefix=/usr/local/apr  就可以了网上说的其他解决办法如下，但我应用都不行：#aclocal# autoconf# automake# libtoolize –force或者：#autoreconf –force –install# libtoolize –automake –force# automake –force –add-missing我是在Asianux Server 4 编译安装的，也可能跟我使用的系统有关

linux下apache2.2性能优化和安装解压缩tar jxvf httpd-2.2.2.tar.bz2cd httpd-2.2.0# vi server/mpm/worker/worker.c找到下面几行，并改成如下的数值，其目的是在源码中修改apache可支持的最大线程数和最大客户端数目。# define DEFAULT_SERVER_LIMIT 256# define MAX_SERVER_LIMIT 40000# define DEFAULT_THREAD_LIMIT 256# define MAX_THREAD_LIMIT 40000# 编译和安装 apr 1.2cd srclib/apr./configure --prefix=/home/liuchao/local/aprmakemake install# 编译和安装 apr-util 1.2cd ../apr-util./configure --prefix=/home/local/apr-util --with-apr=/home/local/aprmakemake install优化编译选项及配置apache可加载的模块patch -p1 < ../mod_limitipconn-0.22/apachesrc.diff/usr/local/apache2.2.3/bin/apxs -c -i -a mod_limitipconn.c/usr/local/apache2.2/bin/apxs -c -i -a mod_evasive20.c更改2Glogsexport CFLAGS="-O2 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE"然后编译cronolog即可CHOST="i686-pc-linux-gnu"CFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer"CXXFLAGS="-march=penti...

centos下首次编译安装php5.5整合apache1.下载php源码 http://www.php.net/get/php-5.5.0.tar.gz/from/tw2.php.net/mirror2.下载freetype 源码包 http://sourceforge.net/projects/freetype/files/freetype2/2.5.0/freetype-2.5.0.tar...1.下载php源码 http://www.php.net/get/php-5.5.0.tar.gz/from/tw2.php.net/mirror2.下载freetype 源码包 http://sourceforge.net/projects/freetype/files/freetype2/2.5.0/freetype-2.5.0.tar.gz3.下载zlib源码包  http://sourceforge.net/projects/libpng/files/zlib/1.2.7/zlib-1.2.7.tar.bz24.下载gd2源码包  https://bitbucket.org/libgd/gd-libgd/downloads/libgd-2.1.0.tar.gz5.下载libpng源码包http://download.sourceforge.net/libpng/libpng-1.6.2.tar.gz6.下载libjpeg源码包http://www.ijg.org/files/jpegsrc.v9.tar.gz7.解压并编译安装zlib ./configure --prefix=/usr/local/libpngmake&make install8.解压并编译安装freetype./configure --prefix=/usr/local/freetype9.解压并编译安装libpng./configure --prefix=/usr/local/libpng10.连接头文件ln –s /usr/local/libpng/incl...

Oracle 11g 转换内部编码 装Oracle 11g的时候选了gbk编码,后来想改成utf-8. 打开SQL Plus,登录,逐行输入下面的命令: --查看Oracle数据库当前的字符集:select userenv('language') from dual; --修改Oracle数据库字符集为utf-8:conn / as sysdba;shutdown immediate;startup mount;alter system enable restricted session;alter system set job_queue_processes=0;alter system set aq_tm_processes=0;alter database open;alter database character set internal_use utf8; --zhs16gbk shutdown immediate;startup;

Oracle 11g 转换内部编码 装Oracle 11g的时候选了gbk编码,后来想改成utf-8. 打开SQL Plus,登录,逐行输入下面的命令: --查看Oracle数据库当前的字符集:select userenv('language') from dual; --修改Oracle数据库字符集为utf-8:conn / as sysdba;shutdown immediate;startup mount;alter system enable restricted session;alter system set job_queue_processes=0;alter system set aq_tm_processes=0;alter database open;alter database character set internal_use utf8; --zhs16gbk shutdown immediate;startup;

关于oracle中的rownum陷阱 最近在做关于某一oracle 的sql优化：涉及到关于分页的一些内容。例如查询top 5 的数据  我们需要写：  www.2cto.com  select * from (select * from customer order by custcredit)where rownum < = 5  而不是写:select * from customer order by custcredit where rownum <=5经测试，前一种写法是对的。而后一种则是随机选出5天，再对其进行排序，可见rownum处理先于order by Ps:如果我们要找数据库插入第二个之后的数据，直接用select * from customer where rownum>2 是查不出记录的，原因是由于rownum是一个总是从1开始的伪列，Oracle 认为rownum> n(n>1的自然数)这种条件依旧不成立，所以查不到记录.那如何才能找到第二行以后的记录呀。可以使用以下的子查询方法来解决。注意子查询中的rownum必须要有别名，否则还是不会查出记录来，这是因为rownum不是某个表的列，如果不起别名的话，无法知道rownum是子查询的列还是主查询的列。 SQL>select * from(select rownum no ,*  from customer )t where no>2;