Click to See Complete Forum and Search --> : limiting the use of mysql to a set of computers


cs3mw
11-05-2009, 06:13 AM
Hi I am trying to limit the use of a mysql to a particular set of computers i.e. in a school. Unfortunately at this stage the school are unable to purchase a commercial licence to host on their server and I was wondering if anyone out there knew an article which I could talke a look at on how to limit the use of a database to a set of computers or any or any other methods.

Thanks in adavnce

ssystems
11-06-2009, 12:54 PM
Look at the link below
Grant (http://dev.mysql.com/doc/refman/5.1/en/grant.html)
Limit the host to the IP

criterion9
11-06-2009, 12:56 PM
Unfortunately at this stage the school are unable to purchase a commercial licence to host on their server

MySQL has free licenses so I'm not sure why the lack of a commercial license would be an issue.