☰

phpMyAdmin 设置问题

tag-icon • tag-icon ubuntu nginx php
phpMyAdmin 设置问题

我正在尝试按照教程进行操作这里设置用户和密码。那里说“本节仅适用于您的 MySQL 服务器正在使用 --skip-show-database 运行的情况”。第一个问题是，如何检查 MySQl 服务器是否正在使用 --skip-show-database 运行？

有什么方法可以让我无需登录即可访问 phpMyAdmin SQL 查询窗口？否则我必须从命令行执行此 SQL。

我也得到了这个：

无法加载 mcrypt 扩展。请检查您的 PHP 配置。

我已将 mcrypt.so 添加到 php.ini，并执行以下命令证明我拥有它。

[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() 并搜索 mcrypt 时，它可以在配置命令行 ('--with-mcrypt=shared,/usr') 中找到它。那么，下一步该怎么做？

更新：我没有输入extension=mcrypt.sophp.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;
    #    }
    #}

}

答案1

创建脚本/usr/local/nginx/html/test_mcrypt.php：

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

然后打开http://服务器名称/test_mcrypt.php。如果您看到 bool(true)，则 Web 浏览器缓存存在问题。

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

<?php
 phpinfo();
?>

并找到 mcrupt 部分

答案2

我注意到这个帖子遇到了类似的问题；您是否重新启动了 Apache，并尝试清除浏览器的缓存？

相关内容