For example:
GRANT ALL ON db_name.* TO ""@192.168.1.%
Will grant all privileges on database db_name to every user on the 192.168.1 network. You wouldn't want to actually grant that much access (i.e. dropping tables) to all users, but it's an example.
This is a very important part of MySQL database security that you should become familiar with. This has nothing to do with what platform you are running MySQL on (I'm on a Mac too). There are a number of good books that cover this well. I use MySQL by Paul DuBois (who you see on this list occasionally).
On Monday, January 20, 2003, at 02:26 AM, Ram Kumar wrote:
greetings nug
how can we access mySQL installation (from entropy.ch, Marc Liyanage)
through TCP/IP on a network
we are able to access mySQL on localhost, but tcp fails
regards, ram
--
+----------------------------------------------------------------------+
Mac Solutions
http://www.macsolutionsindia.com +91 98102 70848
ram @ macsolutionsindia.com
MSN: [EMAIL PROTECTED] support @ macsolutionsindia.com
+----------------------------------------------------------------------+
Simplifying solutions for you... Macintosh, Windows, Client/Server, Web
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-
[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
