[难]奇怪的mysql安装管理问题

eggnog

问题描述:
系统:RH9,Apache 2.4.20,PHP 4.2.2
#mysql -V
mysql  Ver 14.12 Distrib 5.0.40, for pc-linux-gnu (i686) using  EditLine wrapper

RH9本来带Mysql 3.2.X,我在安装时没有选中,从网上下载最新的:5.0.40 tar
安装完全成功,也能随系统启动.

我下载了Webadmin 1.38和 PhpMyAdmin 2.11.2,分别安装在 /var/www/html/下

问题：一）我用IE连接PhpMyAdmin是，提示：

phpMyAdmin - 错误无法载入 mysql 扩展，
请检查 PHP 配置 - 文档


然后检查文档：

1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration".To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.


Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.




问题二：我在Webmin中设置Mysql连接部分，出错提示：

DBI connect failed : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
配置部分如下：






系统其它配置如下：1）/etc/my.cnf  [部分]


[client]
#password       = your_password
port            = 3306
socket          = /usr/local/var/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port            = 3306
socket          = /usr/local/var/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M




2）/ect/php.ini [部分]
;extension=php_fdf.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll


3)  /etc/httpd/conf/httpd.conf  [部分]

LoadModule access_module modules/mod_access.so
LoadModule auth_module modules/mod_auth.so
LoadModule auth_anon_module modules/mod_auth_anon.so
LoadModule auth_dbm_module modules/mod_auth_dbm.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule unique_id_module modules/mod_unique_id.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule asis_module modules/mod_asis.so
LoadModule info_module modules/mod_info.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imap_module modules/mod_imap.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so





另外我安装了DBI-1.601,安装测试完全成功，









实在想不出问题出在什么地方！！！


谢谢。

[ 本帖最后由 eggnog 于 2007-11-17 04:16 编辑 ]

eggnog

试了很多方式还是解决不了.请高手出招啊...