Sunday, August 16, 2009

phpMyAdmin 使用时 Apache 崩溃问题

最近笔记本的硬盘时常怪响,因此换了一块硬盘以防万一,系统重装了,因此开发环境 PHP + MySQL + Apache 也需要重搭。因为已经做过很多次,做起来轻车熟路,然而装好 phpMyAdmin 以后,在登入界面输入用户名密码点登入,居然弹出一个 Windows 应用程序进程崩溃的 report 对话框:Apache 崩溃了……

重新试了几次,仍然如此,换以前硬盘上的 PHP 目录(保证 PHP 的配置和以前一致),无效;换 Apache 版本,无效;换 phpMyAdmin 较早的可以正常使用的版本,无效;用 MySQL 官方的 GUI 客户端登录,可以读写数据,因此不是 MySQL 的问题,于是我就没辙了……

上 Google,发现很多人都有类似的问题,最早的帖子甚至可以追溯到 2003 年,然而没有看到一个有用的解释或者回答,但终究找到一个网页提到架设 PHP + MySQL + Apache 的时候,要保持 MySQL 的客户端连接库 libmysql.dll 版本一致,最好使用 PHP 自带的 dll。

想到这次设置 PHP 时,没有像以前把所有的 dll 都拷贝到 %windows_root%\system32 下,而只是直接的把 D:\PHP 加入到了 PATH 环境变量中。于是马上照以前的办法,把 PHP 包中的相关 dll 都拷贝到了 system32 下,再启动 Apache,进 phpMyAdmin,问题解决了。

用了一会儿,问题有时候仍然存在,于是又把 %Apache%\bin\libmysql.dll 删除(或改名),则问题解决了。但是在 phpMyAdmin 登入后,首页下方会提示说当前使用的 MySQL 客户端版本和服务器版本不相符,可能导致不可预料的结果。

如果各位对此问题有没有更透彻的解释以及彻底的解决办法,望不吝赐教。

Update 2010-02-10:

这个问题似乎和 MySQL 的版本有关。之前出现此问题的 MySQL 版本是 5.4 beta。最近在新机器上同样的架构和设置,只是 MySQL 版本为 5.1,没有出现该问题。

21 comments:

笨乌不飞 said...

这些东西因为原生都是在 Linux 下的,我觉得最好还是装个 Linux 就什么问题都没有了。

——曾经在 Windows 平台被 Apache 折腾惨了的家伙。

Unknown said...

2015-7-28 xiaozhengm
christian louboutin sale
polo ralph lauren outlet
longchamp outlet
michael kors handbags
coach factory outlet
replica watches cheap
ed hardy
pandora rings
tory burch shoes
ralph lauren outlet
soccer jerseys wholesale
michael kors handbag
prada handbags
cheap ray ban sunglasses
chanel outlet
hollister clothing store
burberry outlet online
tory burch outlet
cheap jerseys
tory burch outlet online
cheap jordans
ray ban outlet
coach outlet online
air max 90
ralph lauren uk
coach outlet
kate spade bags
coach outlet
nike air force
chaussure louboutin
nike air max
tory burch handbags
air max shoes
air jordan
nike blazer
nike blazer low
jordan homme
michael kors
abercrombie
gucci

mmjiaxin said...

ferragamo shoes
michael kors outlet
rolex watches outlet
tory burch outlet online
michael kors handbags
coach outlet store
mac cosmetics
michael kors outlet online
wellensteyn outlet
michael kors outlet
canada goose outelt
air max 2014
ray ban,rayban,occhiali ray ban,ray-ban,ray ban occhiali,ray ban sunglasses
woolrich outlet store
fred perry polo shirts
michael kors outlet
tiffany outlet
canada goose jackets
oakley outlet store
mizuno running shoes
mm1205

chenlili said...

chenlili20160629
michael kors outlet
coach factory outlet
air jordans
oakley outlet
kobe 11
nike running shoes for women
cheap air jordans
michael kors outlet clearance
ralph lauren
gucci outlet
nike air max 90
ralph lauren outlet
air jordans
retro jordans 13
montblanc
vans shoes
jordan retro 11
hollister outlet
toms shoes
ralph lauren
michael kors handbags
true religion sale
ray ban sunglasses
tory burch outlet online
gucci belts
marc jacobs handbags
coach outlet store online
louis vuitton outlet online
timberlands
oakley sunglasses
hollister clothing
kobe shoes
ray bans
ray ban sunglasses
michael kors outlet online
replica rolex watches
true religion outlet

chenlili said...

chenlili20160629
air force 1
louboutin shoes
oakley vault
michael kors handbags
retro 11
ray ban sunglasses outlet
michael kors outlet
polo ralph lauren
coach outlet store online
adidas originals
tory burch handbags
coach outlet
louis vuitton purses
michael kors handbags
ray ban sunglasses outlet
coach outlet store online
rolex watches
designer handbags
louis vuitton bags
nike sb dunks
louis vuitton outlet stores
rolex watches
louis vuitton outlet
giuseppe zanotti outlet
ray ban sunglasses
nike blazers uk
ray ban sunglasses
coach outlet
nike store
ray ban sunglasses outlet
coach outlet
ghd hair straighteners
jordan retro 4
louis vuitton purses
coach outlet store online clearances
asics outlet
polo ralph lauren
nike sb janoski
jordan 3 white cenment

mmjiaxin said...

longchamp handbags
michael jordan shoes
jordan retro
nfl jerseys
nfl jerseys from china
mlb jerseys wholesale
timberland outlet
longchamp bags
kobe shoes
http://www.michaeljordanshoes.us.com
gg

chenmeinv0 said...

cheap nhl jerseys
canada goose sale
coach outlet store online clearances
canada goose jackets
coach factory outlet
abercrombie kids
ugg clearance
polo ralph lauren
canada goose jackets
michael kors outlet online
2016.11.14xukaimin

xumeiqing said...

20161117meiqing
mont blanc pens
pandora jewelry outlet
converse trainers
burberry sale
louis vuitton
nike store
nfl jerseys
the north face outlet
michael kors outlet
puma shoes

Unknown said...

ray bans
burberry outlet store
toms outlet
burberry outlet store
ray ban sunglasses
cartier watches
mlb jerseys
ugg boots
nike roshe run
louis vuitton outlet stores
20170207caihuali

Unknown said...

air max 90
ray-ban sunglasses
rolex watches
oakley sunglasses wholesale
lululemon pants
instyler ionic styler
cartier watches for women
cheap oakley sunglasses
coach factory outlet
oakley sunglasses
20170215lck

Unknown said...

michael kors bags
polo ralph lauren outlet
kate spade uk
michael kors outlet clearance
louis vuitton handbags
fendi bags
fitflops sale
yeezy boost 350
pandora charms
coach outlet online
20170308huazhen

Unknown said...

mulberry handbags
fitflops sale clearance
cheap oakley sunglasses
oakley sunglasses
ralph lauren polo
nike shoes uk
fitflops outlet
pandora charms sale clearance
cartier watches
nike outlet store
chanyuan2017.04.01

xjd7410@gmail.com said...

20170513 junda
yeezy boost
burberry canada
cheap jordan shoes
rolex watches for sale
gucci outlet online
ralph lauren outlet
coach factory outlet
fitflops sale clearance
polo outlet
michael kors handbags outlet

Anonymous said...

coach factory outlet
valentino shoes
pandora charms
air jordan shoes
coach outlet
michael kors outlet
adidas
coach factory outlet
skechers shoes
coach outlet store
mt0312

jjjjjjjjjjjjj said...

air max
nfl jerseys
cheap mlb jerseys
longchamp longchamps
converse outlet store
dior glasses
moncler outlet
cheap jordans
adidas superstar
adidas superstars

jeje said...

jordan 8
fitflops clearance
canada goose jackets
moncler outlet
lacoste polo
kate spade outlet
tory burch outlet
true religion jeans outlet
canada goose outlet
clarks outlet

Unknown said...

www1107

jordans
issey miyake
ugg boots outlet
supreme clothing
asics shoes
pandora jewelry
christian louboutin shoes
canada goose outlet
ugg outlet
nike outlet










dateceth said...

il a dit Bottega Veneta Dolabuy visiter le site Chloe Dolabuy page suivante meilleurs sacs de répliques en ligne

Anonymous said...

Good post
job vacancy

Anonymous said...

Good post
recruitment

gbelegbo said...

Fine post.

How to Start a Salaula Business