Access multiple databases through PhpMyadmin-优快云博客

本文链接：https://blog.youkuaiyun.com/a_flying_bird/article/details/51603284

本文介绍如何通过配置PhpMyAdmin来管理本地或远程的MySQL或MariaDB数据库。默认情况下，PhpMyAdmin只配置了一个数据库连接。文章详细说明了如何在config.inc.php文件中增加额外的数据库服务器配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Overview

PhpMyadmin has the ability to access multiple MySQL or MariaDB, includes local or remote machines.

In this article, we describe it in briefly.

Reference

https://wadsashika.wordpress.com/2015/01/06/manage-remote-mysql-database-locally-using-phpmyadmin/#more-57

The default case

After installation, phpmyadmin has only one database configuration, see phpmyadmin/config.inc.php.

In this case, the UI is as below:

UI with only one db

Add another db server

Reference

see: phpMyAdmin/doc/html/config.html#server-connection-settings or Server Connection Settings.

Example

In the end of config.inc.php, add the configuration: – The user, password, port, host, ect, should be changed according your requirement or environment.

/*
 * Another DB server
 */
$i++;
$cfg['Servers'][$i]['user'] = 'admin';
$cfg['Servers'][$i]['password'] = 'admin';
$cfg['Servers'][$i]['port'] = 3306;
$cfg['Lang'] = '';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/*
 * End of servers configuration
 */

?>

UI

After changing, save the config.inc.php. Then refresh (F5) the phpmyadmin page in the browser. Then there will show a list with which to choose you instrested server. – If the configuration is error, phpmyadmin will occur some error.

UI with two servers