Network access or remote access is handled by the OS such as Linux.
All you need to do is make sure you have a user setup that is allowed to
access the database from those locations. Example:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
With this example you just created a super users that can access mysql from
the server where it resides or from anywhere else. Unless you want this try
to be more specific with super users access points like maybe you just want
it for the internal network like this: [EMAIL PROTECTED]%
For more information on this look at adding new users under the
documentations section.
Once you have this setup then you can access the database using the mysql
client tool or ODBC or any other types of connections that have been
developed for mysql (See download section for developed connection drivers).
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-----Original Message-----
From: Steve Dickey [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 21, 2002 8:40 PM
To: [EMAIL PROTECTED]
Subject: Network access?
I am a MySQL newbie and can not seem to find the documentation that
explains how to allow network or remote access to a running MySQL
server. It does not seem to be in the my.cnf file or in the manual???
I am sure this is a simple thing but it is really holding me up right
now. Thanks for any help.
scd
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
