除了$ cfg ['Servers'] [$ i] ['ssl'] = TRUE外，我还需要什么 [英] what else do I need besides $cfg['Servers'][$i]['ssl']=TRUE

问题描述

当我添加到我的配置中时 $ cfg ['Servers'] [$ i] ['ssl'] = TRUE; 试图连接给 phpMyAdmin-错误#2002-
-服务器没有响应(或本地服务器的套接字配置不正确)

When I add to my config $cfg['Servers'][$i]['ssl'] = TRUE; trying to connect gives phpMyAdmin - Error #2002 -
-- The server is not responding (or the local server's socket is not correctly configured)

我怀疑这是因为mysql服务器需要 --ssl-ca = ... --ssl-cert = ... --ssl-key = ... 如何将它们放入phpMyAdmin配置中

I suspect this is because the mysql server requires --ssl-ca=... --ssl-cert=... --ssl-key=... How do I put those into the phpMyAdmin configuration

还是我还缺少其他一些问题?

Or is there some other problem that I'm missing?

推荐答案

在手册中所有这些都作了很好的解释.这些选项是通过config.inc.php中的其他指令配置的.

It's all explained reasonably well in the manual; those options are configured through additional directives in config.inc.php.

例如，参见 http://docs.phpmyadmin.net/en/latest /config.html#cfg_Servers_ssl 及其后面的几段. (或者，更具体地说，请参见

See for instance http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl and the few paragraphs there that follow. (Or, to be more specific, see

• http://docs.phpmyadmin.net/en/latest/config. html#cfg_Servers_ssl_key ，
• http://docs.phpmyadmin.net/en/latest/config. html#cfg_Servers_ssl_cert ，
• http://docs.phpmyadmin.net/en/latest/config. html#cfg_Servers_ssl_ca ，
• http://docs.phpmyadmin.net/en/latest/config. html#cfg_Servers_ssl_ca_path 和
• http://docs.phpmyadmin.net/en/latest/config. html#cfg_Servers_ssl_ciphers ).

• http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl_key,
• http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl_cert,
• http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl_ca,
• http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl_ca_path, and
• http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_ssl_ciphers).

就我而言，我可以通过添加以下指令来实现这一目标:

In my case, I was able to achieve this through adding these directives:

$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['ssl_cert'] = '/etc/mysql/client-cert.pem';
$cfg['Servers'][$i]['ssl_ca'] = '/etc/mysql/ca-cert.pem';
$cfg['Servers'][$i]['ssl_key'] = '/etc/mysql/client-key.pem';

根据本地系统上的正确路径进行调整.祝你好运！

Adjusting of course for the correct paths on your local system. Good luck!

这篇关于除了$ cfg ['Servers'] [$ i] ['ssl'] = TRUE外，我还需要什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！