Wim, see http://dev.mysql.com/doc/refman/5.0/en/grant.html
When granting access to a user, you can do like
GRANT SELECT on db.* to 'user'@'%.domain.com'
which gives 'user' access to select from any table within 'db', provided
they are coming from a host in 'domain.com'. ('%' is a wildcard.)
You can do with IP addresses as well/instead of hostnames
GRANT SELECT on db.* to 'user'@'10.0.0.%'
Note that you'll most likely want to do just one or the other depending
on whether your mysql install is doing hostname lookups.
You can also grant access to 'user' from any remote host with
GRANT SELECT on db.* to 'user'@'%'
but your security requirements may not allow that.
HTH,
Dan
Wim Bakker wrote:
Hello
I would like to grant select access to a certain
mysql database from all computers in my local lan
without having to add every specific computer to the
user database , is this possible and how is this
done?
The purpose is to give all users the possibility to
access the addresslist table in the database for
opening in openoffice.org and select addresses
from it.
I now get access denied errors and the mysql manual
is not very comprehensible on how to grant access
to a database from other computers.
TIA
Wim bakker
--
Dan Buettner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
