[Solved] Remote access to MariaDB on Lily

[paladino]

Hello!

I made a major database update to my app. I've built the whole database in my local pc and exported in sql, but due to size of it, I cannot update through phpmyadmin. I've tried made in chunks, but it didn't work.

Please, is it possible to allow me connect to my database remotely? I asked fot it a long time ago and now I'm needing it again...

My IP address (dynamic) now is: 187.99.103.197

Thanks!

[KazVee]

Because your MariaDB is on Lily, this is something Wolstech will be able to help you out with. I've escalated this thread for his attention. 🙂

As a note to any other users who may find this post when searching the forum: Users on the Morty, Tommy, and Johnny servers can enable their own remote access to MariaDB / MySQL themselves. Inside Plesk, go to: Databases > click on the database User name > Scroll down to the Access Control section > Choose one of the "Allow remote connections from.." options > Click OK to save.

[wolstech]

Remote access enabled for IP specified.

Host: lily.heliohost.org
Port: 3306
Username: paladin2

 

[paladino]

I could connect now.

Thanks!