From owner-freebsd-questions Tue May 29 22:31:32 2001 Delivered-To: freebsd-questions@freebsd.org Received: from clmboh1-smtp3.columbus.rr.com (clmboh1-smtp3.columbus.rr.com [65.24.0.112]) by hub.freebsd.org (Postfix) with ESMTP id CA0D337B422 for ; Tue, 29 May 2001 22:31:28 -0700 (PDT) (envelope-from wmoran@iowna.com) Received: from iowna.com (dhcp065-024-023-038.columbus.rr.com [65.24.23.38]) by clmboh1-smtp3.columbus.rr.com (8.11.2/8.11.2) with ESMTP id f4U5SGk04859; Wed, 30 May 2001 01:28:16 -0400 (EDT) Message-ID: <3B14855C.E998927E@iowna.com> Date: Wed, 30 May 2001 01:30:04 -0400 From: Bill Moran X-Mailer: Mozilla 4.76 [en] (X11; U; FreeBSD 4.3-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: Ryan Masse Cc: Gerard Samuel , FreeBSD-Questions Subject: Re: mysql tcp connection References: <3B144374.996414E9@optonline.net> <3B144ED5.F86EE61B@iowna.com> <3B148021.60CB7680@optonline.net> <00a901c0e8c7$d05a7920$fd00a8c0@Home> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG That's a rather knock-down, drag-out approach to security. You basically removed all restrictions on what host a user can connect from. You may have also remove all access restrictions altogether. Have you attempted remote login without any username or password to make sure it will deny you? While this may have been what you intended for youself. I don't personally recommend that everyone use that approach. Take the time to understand the MySQL security model before you put the box into production. There are some excellent tutorials on the MySQL web site. I also heavily recommend setting up a test box and playing with the permissions for a while until you know what you're doing through experience. Remember, you too can be a statistic. Ryan Masse wrote: > > I have just went through this a few hours ago linking the remote mysql db > from within access 2000. > > First you need to download the odbc driver for mysql: > http://www.mysql.com/downloads/api-myodbc.html > > I encountered a problem on the unix box where it would give me an access > denied. I had to add the user as th following; > > grant all privileges on database.* to user@"%" identified by 'somepasse'; > > then i had to remove all anonymous users from the mysql.user db; > > delete from mysql.user where User=' '; flush privileges; > > once i did that i could connect via that user locally on the unix box and > after entering the DSN on the MS box i could connect and read all the > records. > > If you need a more complete description email me. -- If a bird in the hand is worth two in the bush, then what can I get for two hands in the bush? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message