Accessing MySQL Server through phpmyadmin

[Sef]

$cfg['Servers'][$i]['host'] = 'db-name-db-manager.d.aivencloud.com:25573';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'avnadmin';
$cfg['Servers'][$i]['ssl_ca'] = 'M:/xampp/phpMyAdmin/ca.pem';
$cfg['Servers'][$i]['password'] = 'changed-pass-obviously';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

I don’t get what I’m supposed to do.
It shows up in phpmyAdmin but it gives me an error saying it failed to connect.
If it’s an IP filter issue is there a way I can get rid of IP filters?

[alex]

Hey,

Could you share a specific error you get while trying to connect?
Are you sure there is no other setting which overrides your settings elsewhere?
Could you also try adding ssl= true and ssl_verify = false?

Best,
Alex

[Danishhafeez]

@Sef

$cfg['Servers'][$i]['host'] = 'db-name-db-manager.d.aivencloud.com:25573';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'avnadmin';
$cfg['Servers'][$i]['ssl_ca'] = 'M:/xampp/phpMyAdmin/ca.pem';
$cfg['Servers'][$i]['password'] = 'changed-pass-obviously';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

I don’t get what I’m supposed to do.
It shows up in phpmyAdmin but it gives me an error saying it failed to connect.
If it’s an IP filter issue is there a way I can get rid of IP filters?

Ensure the hostname, port, username, and password are correct in your phpMyAdmin configuration. Check if the SSL CA certificate path is accurate. Review firewall and IP filtering settings to ensure they allow connections. Test the connection using a database client tool to isolate the issue.

Best regard
Danish hafeez | QA Assistant
ICTInnovations