设置phpmyadmin只连接到远程服务器

我一直坚持这一点,希望你能提供一些洞察我做错了什么。

我有一个新鲜的亚马逊EC2(Ubuntu 16.04)实例连接到RDS(MySQL)数据库,并试图安装phpMyAdmin在亚马逊EC2实例,以pipe理RDS数据库。

我遇到的麻烦是如何configurationphpmyadmin,以便它不会安装本地数据库,而只是连接到RDS实例。 (当问我是否想让phpmyadmin为我设置一个数据库的时候,我select了否。)

第一次尝试:

我已经尝试将以下内容添加到我的/etc/phpmyadmin/config.header.inc.php中:

$i++; $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = '*************'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysql if your server does not have mysqli */ $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = false; 

*************是我的RDS实例的作者端点。

但是,这样做只会产生以下不可用的login页面: Borkedlogin页面

第二次尝试:

我还尝试将/etc/phpmyadmin/config-db.php中的$dbserver更改为我的RDS实例的写入程序端点,这会在login页面上产生以下警告:

警告1:

 Notice in ./index.php#603 Use of undefined constant PMA_DRIZZLE - assumed 'PMA_DRIZZLE' Backtrace 

警告2:

 Notice in ./libraries/DatabaseInterface.class.php#2665 Use of undefined constant PMA_DRIZZLE - assumed 'PMA_DRIZZLE' Backtrace ./libraries/db_common.inc.php#24: PMA_DatabaseInterface->isSystemSchema(string '') ./db_structure.php#14: require_once(./libraries/db_common.inc.php) 

警告3:

 Notice in ./libraries/DatabaseInterface.class.php#2666 Use of undefined constant PMA_DRIZZLE - assumed 'PMA_DRIZZLE' Backtrace ./libraries/db_common.inc.php#24: PMA_DatabaseInterface->isSystemSchema(string '') ./db_structure.php#14: require_once(./libraries/db_common.inc.php) 

警告4:

 Notice in ./libraries/DatabaseInterface.class.php#2667 Use of undefined constant PMA_DRIZZLE - assumed 'PMA_DRIZZLE' Backtrace ./libraries/db_common.inc.php#24: PMA_DatabaseInterface->isSystemSchema(string '') ./db_structure.php#14: require_once(./libraries/db_common.inc.php) 

警告5:

 Notice in ./libraries/DatabaseInterface.class.php#2668 Use of undefined constant PMA_DRIZZLE - assumed 'PMA_DRIZZLE' Backtrace ./libraries/db_common.inc.php#24: PMA_DatabaseInterface->isSystemSchema(string '') ./db_structure.php#14: require_once(./libraries/db_common.inc.php) 

无视这些并尝试login,我得到以下内容:

login尝试错误:

 #2002 - No such file or directory<br />The server is not responding (or the local server's socket is not correctly configured). 

即使我想要访问的数据库在远程计算机上,我甚至试图做甚么,还是绝对要求phpmyadmin具有本地数据库才能正常工作?

确保在远程主机上运行phpmyadmin数据库SQL文件:

 -- -------------------------------------------------------- -- SQL Commands to set up the pmadb as described in the documentation. -- -- This file is meant for use with MySQL 5 and above! -- -- This script expects the user pma to already be existing. If we would put a -- line here to create him too many users might just use this script and end -- up with having the same password for the controluser. -- -- This user "pma" must be defined in config.inc.php (controluser/controlpass) -- -- Please don't forget to set up the tablenames in config.inc.php -- -- -------------------------------------------------------- [...] 

看到整个文件: https : //github.com/phpmyadmin/phpmyadmin/blob/master/sql/create_tables.sql