• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Question How to configure phpMyAdmin config.inc.php properly to connect to other DB servers in Docker container

milanbx

New Pleskian
Server operating system version
Debian 12.11
Plesk version and microupdate number
Plesk Obsidian v18.0.69_build1800250502.08
Hi, I am running Plesk Obsidian v18.0.69_build1800250502.08 on Debian 12.11 with Docker extension. And I would like to use Plesk phpMyAdmin to connect to DB servers in my Docker containers. I have found in docs, where to find phpMyAdmin installation i Plesk (`/usr/local/psa/phpMyAdmin/`) and that I have to create the `config.inc.php` file. I have don so and its content is as following:
```php
<?php
/**
* Servers configuration
* $cfg['Servers'][1] is configured by Plesk. Do not use $cfg['Servers'][0].
*/
$i = 2;
/* Authentication type */
// $cfg['Servers'][$i]['auth_type'] = 'cookie'; // cookie is default => commented out
/* Server parameters */
// $cfg['Servers'][$i]['host'] = 'localhost'; // localhost is default => commented out

$cfg['Servers'][$i]['port'] = '5002';

// $cfg['Servers'][$i]['AllowNoPassword'] = false; // false is default => commented out
```
If I use `mysql -P 5002 -u root -p`, I can connect to the database properly.
But if I try the sam from phpMyAdmin, I get followign error: mysqli::real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Any ideas, what to add to the configuration?
Thanks.
 
Back
Top