Read up on the GRANT command in MySQL. This sets up the security level
for the tables, hosts and even columns. MySQL defaults to only allowing
the localhost to connect ot the database, which is fine if you are
running the webserver and something like PHP on that computer. Once you
separate them, you need to GRANT the other machine access to MySQL.
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: ramindelhi@stripped 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 <mysql-thread130380@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-
> brent=landover.com@stripped>
> 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
