How is MySQL hosting different from regular hosting? Or is it the same thing?

Question

MySQL

I came across a project that needs remote access to the database using PDO .
When I started uploading to the hosting, I realized that I could not establish a connection, despite the fact that everything worked on the local. I checked with the technical support of the hosting, and, as it turned out, it does not support u.d. to the database ( like most other hosting ). The only option is VPS.
I started surfing other solutions to the problem, and came across such a thing as MySQL hosting .

So the question is: is it possible to use php, js, css on such a hosting, or is it only for the database?
Ps Can anyone come across such a problem: is vps the only option?

Answer 1

On a regular shared hosting, the database never looks "out", it only listens to connections in the loopback. Just for the sake of sound logic, because on such hostings they keep all kinds of Joomla with WordPress, for the operation of which access to the database from outside is not needed and even dangerous.
On VPS / VDS, you are free to configure anything and however you like.
MySQL hosting - where did you find this?

Answer 2

There is no point in this, since the overhead on the Connect and ping will be so large that the performance of the muscle will be very sad