I would like to have 2 db (Dev & Prod). CarsDevDB & CarsDB. I have 2 users, CarsDevUser (Allow Remote Access, Port 5000) and CarsAdmin (only allow local connection).
I would like to connect to CarsDevDB with the user CarsDevUser from anywhere REMOTELY using (IP):5000.
However, I would like to connect to CarsDB using ONLY LOCAL connection. 127.0.0.1. CarsDB/CarsAdmin should NOT have any remote connection whatsoever.
CarsDevUser will not access to any other database.
How can I proceed with this? I've enabled Remote connection and got it to work, I can't limit it to one database yet though.