phpMyAdmin设置问题

我正在尝试按照这里的教程设置用户并通过。 它在那里说“这个部分只适用于你的MySQL服务器运行在–skip-show-database”的情况。 第一个问题是,如何检查MySQl服务器是否正在运行–skip-show-database?

有没有办法可以访问phpMyAdmin的SQL查询窗口没有login? 否则,我不得不从命令行执行这个SQL。

我也得到这个:

无法加载mcrypt扩展名。 请检查您的PHPconfiguration。

我已经将mcrypt.so添加到php.ini中,并执行以下命令certificate我拥有它。

[root@DT html]# rpm -qa | grep mcrypt mcrypt-2.6.8-1.el5 php-mcrypt-5.3.5-1.1.w5 libmcrypt-2.5.8-4.el5.centos [root@DT html]# php -v PHP 5.3.5 (cli) (built: Feb 19 2011 13:10:09) Copyright (c) 1997-2010 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies 

现在当我去phpinfo()并searchmcrypt时,它可以在configuration命令行('–with-mcrypt = shared,/ usr')中find它。 那么,接下来要做什么?

更新:我没有把extension=mcrypt.so在php.ini,因为它会抱怨以下几点:

 PHP Warning: Module 'mcrypt' already loaded in Unknown on line 0 

这是我的nginx.conf:

 #user nobody; worker_processes 2; #error_log logs/error.log; #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid; events { worker_connections 1024; } http { include mime.types; default_type application/octet-stream; #log_format main '$remote_addr - $remote_user [$time_local] "$request" ' # '$status $body_bytes_sent "$http_referer" ' # '"$http_user_agent" "$http_x_forwarded_for"'; #access_log logs/access.log main; sendfile on; #tcp_nopush on; #keepalive_timeout 0; keepalive_timeout 65; gzip on; server { listen 80; root /usr/share/nginx/html; server_name localhost; #charset koi8-r; #access_log logs/host.access.log main; location / { #root html; index index.html index.htm; } #error_page 404 /404.html; # redirect server error pages to the static page /50x.html # error_page 500 502 503 504 /50x.html; location = /50x.html { #root html; } # proxy the PHP scripts to Apache listening on 127.0.0.1:80 # #location ~ \.php$ { # proxy_pass http://127.0.0.1; #} # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000 # location ~ \.php$ { #root /usr/local/nginx/html; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script _name; include fastcgi_params; } # deny access to .htaccess files, if Apache's document root # concurs with nginx's one location ~ /\.ht { deny all; } } # another virtual host using mix of IP-, name-, and port-based configuration # #server { # listen 8000; # listen somename:8080; # server_name somename alias another.alias; # location / { # root html; # index index.html index.htm; # } #} # HTTPS server # #server { # listen 443; # server_name localhost; # ssl on; # ssl_certificate cert.pem; # ssl_certificate_key cert.key; # ssl_session_timeout 5m; # ssl_protocols SSLv2 SSLv3 TLSv1; # ssl_ciphers ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP; # ssl_prefer_server_ciphers on; # location / { # root html; # index index.html index.htm; # } #} } 

创build脚本/usr/local/nginx/html/test_mcrypt.php:

 <?php var_dump(function_exists('mcrypt_encrypt')); ?> 

然后打开http://servername/test_mcrypt.php 。 如果你看到bool(true),那么在web浏览器caching中有问题。

然后编辑/usr/local/nginx/html/test_mcrypt.php:

 <?php phpinfo(); ?> 

并findmcrupt部分

我注意到这个post的用户遇到了类似的问题。 你有没有重新启动Apache,并尝试清除浏览器的caching?