Resolved Accept remote MariaDB / MySQL Connections is enabled in GUI but in the config file hosting binding for daemon is only on 127.0.0.1 / localhost

[jmar83]

Username:

TITLE

Accept remote MariaDB / MySQL Connections is enabled in GUI but in the config file hosting binding for daemon is only on 127.0.0.1 / localhost

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk Obsidian 18.0.65 on Debian 10.13 x64 (most current version on 2024-10-24)

PROBLEM DESCRIPTION

Because i don't like to repeat me here a link, it's all described well there so i think:
Issue - Can't open MariaDB remote connection anymore - Error 10060

STEPS TO REPRODUCE

HeidiSQL db frontend does not work anymore

command "telnet MY_IP 3306" does not work anymore


1.)

2.)

3.)

ACTUAL RESULT

does not work ;-)

EXPECTED RESULT

shoud woke (as a few weeks ago)

ANY ADDITIONAL INFORMATION

Please:

- Help me to cleanup my plesk (its NOT because of me, i NEVER done some things in console on admin mode, besides from a reboot with "init 6")

- I think weed need to search that bug and there is also a fix necessary in the next version

- Confirm bug

If there are any questions, so please don't hesitate to ask me. Thanks in advance!

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Sebahat.hadzhi]

Hello, @jmar83. We attempted the reproduce the reported issue, however, the bind-address value is changed accordingly in /etc/mysql/my.cnf and remote access is established without an issue. With that said, the issue you are experiencing is not due to a Plesk bug.

I would suggest opening a ticket with Plesk support for an investigation of the issue on your server. To sign-in to support and open a ticket go to: https://support.plesk.com
If you got your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative to get support directly from Plesk:

https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

 

[jmar83]

oh so i was wrong bit /etc/mysql/my.cnf is the right file?

there i also see: 'bind-address = ::' (which should mean public address / bind to every IP address not just localhost/127.0.0.1)

Will try to look closer at this issue - thank you very much

 

[jmar83]

Can't find what the problem is... and also strange imo that nobody from the plesk stuff is interested regading that issue!!

 

[jmar83]

oh now i saw it... isp has changed its ip ranges which caused problem with firewall rule