[Solved] Please enable Remote MySQL access for my account (lostandfound, Johnny server).

[lostandfound]

Hello,
Please enable Remote MySQL access for my hosting account.

Details:

• Username: lostandfound

• Domain: lostandfound.heliohost.us

• Server: Johnny

• Database: lostandfound_db

• Database User: lostandfound_user

I need remote access so my backend (hosted on Railway) can connect to the MySQL database.

Thank you!

[MoneyBroz]

You can do this yourself, refer to this wiki article for details:

https://wiki.helionet.org/MariaDB#User_Section

[lostandfound]

Hello,

Thank you for the reply.
I already tried enabling remote access in Plesk, but the issue is:

The “Allow remote connections from” setting does NOT save.
Whenever I enter % and click Save, it automatically resets back to
“Allow remote connections from any host.”

Because of this bug, remote MySQL access is not actually enabled, and my backend on Railway still receives connection errors.

Could you please manually whitelist % for my database user?

Database: lostandfound_db
User: lostandfound_user
Server: Johnny
Host to allow: % (all hosts)

Thank you

[wolstech]

I ran into that behavior on my Tommy account last week too. The remote settings don't work. The UI defaults to 'any host' even when it is actually off, and changing it does nothing (it doesn't update, and is back to 'any host' after you save and the page refreshes)...I thought it was my (ancient) account, but your account is brand new and on another server. Maybe a Plesk bug?

Escalating to Krydos...

[Krydos]

11 hours ago, lostandfound said:

Because of this bug, remote MySQL access is not actually enabled, and my backend on Railway still receives connection errors.

Could you please manually whitelist % for my database user?

It looks like remote MariaDB is already enabled.

MariaDB [(none)]> select user, host from mysql.user where user like 'lostandfound_%';
+-------------------+------+
| User              | Host |
+-------------------+------+
| lostandfound_user | %    |
+-------------------+------+
1 row in set (0.048 sec)

22 minutes ago, wolstech said:

Maybe a Plesk bug?

I can try updating Plesk. I believe we're an update or two behind.