Access Hosts Mysql Management

mmgenius

Verified User
Joined
Jan 20, 2004
Messages
164
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?
 
Im sure its in database management in the users control panel.
 
Yes, the first thing I told is in de controlpanel under MySQL management (add hosts to databases). But you can not specify for which user it is.
 
Does nobody has a solution?
The only way I know now is login with da_admin in phpmyadmin and change the mysql-user table. But I hope you can do it easier then this?
 
Last edited:
Back
Top