Is it possible to connect an database user to a remote IP.
Now you can add a host to a database but then I assume it is for all the users who can connect to the database.
But the thing I like to do is (for example) making 2 users, with different privileges, and user1 can only login from localhost and user2 can only login from the remote IP.
Is this possible, if yes, how can I do this?
Now you can add a host to a database but then I assume it is for all the users who can connect to the database.
But the thing I like to do is (for example) making 2 users, with different privileges, and user1 can only login from localhost and user2 can only login from the remote IP.
Is this possible, if yes, how can I do this?