2010年2月4日 星期四

phpinfo

PHP Version 5.1.6

System Linux localhost.localdomain 2.6.18-8.el5xen #1 SMP Fri Jan 26 14:42:21 EST 2007 i686
Build Date Feb 4 2010 10:53:01
Configure Command './configure' '--with-apxs2=/usr/local/apache/bin/apxs' '--disable-debug' '--enable-ftp' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-mbstring' '--enable-mm=shared' '--enable-safe-mode' '--enable-track-vars' '--enable-trans-sid' '--enable-wddx=shared' '--enable-xml' '--with-dom' '--with-gd' '--with-gettext' '--with-mysql=/usr/local/share/mysql' '--with-regex=system' '--with-xml' '--with-zlib-dir=/usr/lib' '--enable-gd-native-ttf' '--with-png' '--with-ttf' '--with-jpeg-dir=/usr/local/lib/jpeg-6b/' '--with-freetype-dir=/usr/local/lib/freetype-2.1.9/' '--with-xpm-dir=/usr/X11R6/'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/lib
PHP API 20041225
PHP Extension 20050922
Zend Extension 220051025
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp, unix, udg
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting no value no value
expose_php On On
extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20050922 /usr/local/lib/php/extensions/no-debug-non-zts-20050922
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/local/lib/php .:/usr/local/lib/php
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode On On
safe_mode_exec_dir /usr/local/php/bin /usr/local/php/bin
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache2handler
Apache Version Apache/2.2.14 (Unix) PHP/5.1.6
Apache API Version 20051115
Server Administrator you@example.com
Hostname:Port localhost.localdomain:0
User/Group daemon(2)/2
Max Requests Per Child: 10000 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server No
Server Root /usr/local/apache
Loaded Modules core mod_authn_file mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_default mod_auth_basic mod_include mod_filter mod_log_config mod_env mod_setenvif mod_version prefork http_core mod_mime mod_status mod_autoindex mod_asis mod_cgi mod_negotiation mod_dir mod_actions mod_userdir mod_alias mod_so mod_php5

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0


Apache Environment
Variable Value
HTTP_ACCEPT image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/x-shockwave-flash, application/msword, application/vnd.ms-powerpoint, application/vnd.ms-excel, */*
HTTP_ACCEPT_LANGUAGE zh-TW
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_HOST 10.0.0.20
HTTP_CONNECTION Keep-Alive
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/etc/rc.d/init.d:/usr/share/mysql:/root/bin:/usr/share/mysql:/usr/local/apache/bin
SERVER_SIGNATURE no value
SERVER_SOFTWARE Apache/2.2.14 (Unix) PHP/5.1.6
SERVER_NAME 10.0.0.20
SERVER_ADDR 10.0.0.20
SERVER_PORT 80
REMOTE_ADDR 10.0.20.167
DOCUMENT_ROOT /usr/local/apache/htdocs
SERVER_ADMIN you@example.com
SCRIPT_FILENAME /usr/local/apache/htdocs/intranet/phpinfo.php
REMOTE_PORT 55357
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /intranet/phpinfo.php
SCRIPT_NAME /intranet/phpinfo.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /intranet/phpinfo.php HTTP/1.1
Accept image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/x-shockwave-flash, application/msword, application/vnd.ms-powerpoint, application/vnd.ms-excel, */*
Accept-Language zh-TW
User-Agent Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
Accept-Encoding gzip, deflate
Host 10.0.0.20
Connection Keep-Alive
HTTP Response Headers
X-Powered-By PHP/5.1.6
Keep-Alive timeout=5, max=99
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html


ctype
ctype functions enabled


date
date/time support enabled
Timezone Database Version 2006.1
Timezone Database internal
Default timezone Asia/Chongqing

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value


dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.26
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled


ftp
FTP support enabled


gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.2.1
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XPM Support enabled
XBM Support enabled


gettext
GetText Support enabled


hash
hash support enabled
Hashing Engines md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5


iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.5

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


libxml
libXML support active
libXML Version 2.6.26
libXML streams enabled


mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 3.7.1

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value


mysql
MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 5.1.42
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.6 06-Feb-2006


PDO
PDO support enabled
PDO drivers sqlite2


posix
Revision $Revision: 1.70.2.3 $


Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33 2006/03/29 14:28:42 tony2001 Exp $


session
Session Support enabled
Registered save handlers files user sqlite
Registered serializer handlers php php_binary

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path no value no value
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
Simplexml support enabled
Revision $Revision: 1.151.2.22 $
Schema support enabled


SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException


SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13 2006/04/18 14:30:15 iliaa Exp $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0


standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value


tokenizer
Tokenizer Support enabled


xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.26


xmlreader
XMLReader enabled


xmlwriter
XMLWriter enabled


zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name


Environment
Variable Value
HOSTNAME localhost.localdomain
SHELL /bin/bash
TERM xterm
HISTSIZE 1000
SSH_CLIENT 10.0.20.167 50740 22
SSH_TTY /dev/pts/4
USER root
LD_LIBRARY_PATH /usr/local/apache/lib:
LS_COLORS no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/etc/rc.d/init.d:/usr/share/mysql:/root/bin:/usr/share/mysql:/usr/local/apache/bin
MAIL /var/spool/mail/root
PWD /usr/local/apache/bin
INPUTRC /etc/inputrc
LANG zh_TW.UTF-8
SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass
HOME /root
SHLVL 2
OWL /usr/local/apache/htdocs/intranet
LOGNAME root
CVS_RSH ssh
SSH_CONNECTION 10.0.20.167 50740 10.0.0.20 22
LESSOPEN |/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES 1
APACHE /etc/rc.d/init.d
_ /usr/local/apache/bin/httpd


PHP Variables
Variable Value
_SERVER["HTTP_ACCEPT"] image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/x-shockwave-flash, application/msword, application/vnd.ms-powerpoint, application/vnd.ms-excel, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] zh-TW
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_HOST"] 10.0.0.20
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/etc/rc.d/init.d:/usr/share/mysql:/root/bin:/usr/share/mysql:/usr/local/apache/bin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache/2.2.14 (Unix) PHP/5.1.6
_SERVER["SERVER_NAME"] 10.0.0.20
_SERVER["SERVER_ADDR"] 10.0.0.20
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 10.0.20.167
_SERVER["DOCUMENT_ROOT"] /usr/local/apache/htdocs
_SERVER["SERVER_ADMIN"] you@example.com
_SERVER["SCRIPT_FILENAME"] /usr/local/apache/htdocs/intranet/phpinfo.php
_SERVER["REMOTE_PORT"] 55357
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /intranet/phpinfo.php
_SERVER["SCRIPT_NAME"] /intranet/phpinfo.php
_SERVER["PHP_SELF"] /intranet/phpinfo.php
_SERVER["REQUEST_TIME"] 1265291248
_SERVER["argv"] Array
_SERVER["argc"] 0
_ENV["HOSTNAME"] localhost.localdomain
_ENV["SHELL"] /bin/bash
_ENV["TERM"] xterm
_ENV["HISTSIZE"] 1000
_ENV["SSH_CLIENT"] 10.0.20.167 50740 22
_ENV["SSH_TTY"] /dev/pts/4
_ENV["USER"] root
_ENV["LD_LIBRARY_PATH"] /usr/local/apache/lib:
_ENV["LS_COLORS"] no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
_ENV["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/etc/rc.d/init.d:/usr/share/mysql:/root/bin:/usr/share/mysql:/usr/local/apache/bin
_ENV["MAIL"] /var/spool/mail/root
_ENV["PWD"] /usr/local/apache/bin
_ENV["INPUTRC"] /etc/inputrc
_ENV["LANG"] zh_TW.UTF-8
_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass
_ENV["HOME"] /root
_ENV["SHLVL"] 2
_ENV["OWL"] /usr/local/apache/htdocs/intranet
_ENV["LOGNAME"] root
_ENV["CVS_RSH"] ssh
_ENV["SSH_CONNECTION"] 10.0.20.167 50740 10.0.0.20 22
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["APACHE"] /etc/rc.d/init.d
_ENV["_"] /usr/local/apache/bin/httpd


PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

2010年2月3日 星期三

http://localhost/intranet failed with mysql.sock

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

連不上mysql數據庫為什麼?

搞定了,呵呵

還不是用戶名的問題,是mysql.sock的問題

參考以下資料,馬上解決,轉載一下.

http://www.21php.com/tutorial/tutorial.php?tid=41
PHP不能通過sock連接MySQL的解決辦法
加入日期:2003年10月30日 15:14:18 PM 作者:Djzhi 中文PHP論壇

這個問題主要提示是,不能通過'/tmp/mysql.sock'連到服務器,而php標準配置正是用過'/tmp/mysql.sock',但是一些mysql安裝方法將mysql.sock放在/var/lib/mysql.sock或者其他的什麼地方,你可以通過修改/etc/my.conf文件來修正它,打開文件,可以看到如下的東東: [mysqld]
socket=/var/lib/mysql.sock 改一下就好了,但也會引起其他的問題,如mysql程序連不上了,再加一點:
[mysql]
socket=/tmp/mysql.sock

或者還可以通過修改php.ini中的配置來使php用其他的mysql.sock來連,這個大家自己去找找 或者用這樣的方法:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

http://localhost/intranet failed with mysql.sock

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

連不上mysql數據庫為什麼?

搞定了,呵呵

還不是用戶名的問題,是mysql.sock的問題

參考以下資料,馬上解決,轉載一下.

http://www.21php.com/tutorial/tutorial.php?tid=41
PHP不能通過sock連接MySQL的解決辦法
加入日期:2003年10月30日 15:14:18 PM 作者:Djzhi 中文PHP論壇

這個問題主要提示是,不能通過'/tmp/mysql.sock'連到服務器,而php標準配置正是用過'/tmp/mysql.sock',但是一些mysql安裝方法將mysql.sock放在/var/lib/mysql.sock或者其他的什麼地方,你可以通過修改/etc/my.conf文件來修正它,打開文件,可以看到如下的東東: [mysqld]
socket=/var/lib/mysql.sock 改一下就好了,但也會引起其他的問題,如mysql程序連不上了,再加一點:
[mysql]
socket=/tmp/mysql.sock

或者還可以通過修改php.ini中的配置來使php用其他的mysql.sock來連,這個大家自己去找找 或者用這樣的方法:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

can't execute index.php

11.Add these directives are in /usr/local/apache/conf/httpd.conf (if already there, verify they are correct):
# Make sure there's only **1** line for each of these 2 directives:
# Use for PHP 4.x:
#LoadModule php4_module modules/libphp4.so
#AddHandler php-script php

# Use for PHP 5.x:
LoadModule php5_module modules/libphp5.so
AddHandler php5-script php

# Add index.php to your DirectoryIndex line:
DirectoryIndex index.html index.php

AddType text/html php

# PHP Syntax Coloring
# (optional but useful for reading PHP source for debugging):
AddType application/x-httpd-php-source phps

mysql -u root -p error

> ERROR 2002 (HY000): Can't connect to local MySQL
> server through socket '/tmp/mysql.sock' (111)

Does this socket file exist? It may be located in /var/lib/mysql instead. Either set the MYSQL_UNIX_PORT environment variable to point to the location of the socket file or add the following to the [client] section of /etc/my.cnf:

socket=/path/to/your/mysql.sock

See http://dev.mysql.com/doc/refman/4.1/en/problems-with-mysql-sock.html for more details.

mysql.server start failed: Starting MySQLCouldn’t find MySQL manager (/var/lib/bin/mysql) or server (/var/lib/bin/mysqld_safe)

While doing a mysql start you sometimes get the following error.

bash# service mysql start

Starting MySQLCouldn’t find MySQL manager (/var/lib/bin/mysql) or server (/var/lib/bin/mysqld_safe)


make sure that you comment out or remove the basedir directive from /etc/my.cnf file

[mysql.server ]
server=mysql
#basedir=/var/lib

Then restart mysql

mysql.server start error

Starting MySQL..... ERROR! Manager of pid-file quit without updating file
打开/etc/selinux/config,把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器试试

God damn mysql

2010年2月2日 星期二

Before creating a utf8 database on mysql

/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set=utf8
collation_server=utf8_unicode_ci
character_set_server=utf8

[client]
default-character-set=utf8

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
~