Open the port in the firewall ... GRANT SELECT ON database_name.table_name TO user_name@'%' IDENTIFIED BY 'some_password'; ... If you are going to do this, may I suggest starting MySQL with a non standard port number?
-----Original Message----- From: shaun thornburgh To: [EMAIL PROTECTED] Sent: 4/28/04 10:12 AM Subject: MySQL on Win2k Server open to connections from all IPs Hi, I have installed mysql 3.23 on our Windows 2000 Server machine. How can I configure the database such that anyone on the internet can connect to this database? I know this sounds dangerous but once this has been configured we will install VPNs on this machine and any machine that we permit to connect to it. I did consider adding individual IP addresses but some people are allocated new IP addresses everytime they connect to the internet - i.e. dial up accounts... Thanks for your help _________________________________________________________________ Sign-up for a FREE BT Broadband connection today! http://www.msn.co.uk/specials/btbroadband -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
