From owner-freebsd-questions Tue May 29 22:19:23 2001 Delivered-To: freebsd-questions@freebsd.org Received: from e450.mnsi.net (e450.mnsi.net [206.48.122.98]) by hub.freebsd.org (Postfix) with ESMTP id 20F0437B422 for ; Tue, 29 May 2001 22:19:19 -0700 (PDT) (envelope-from mail@max-info.net) Received: from lan4 (dyn216-8-131-222.ADSL.mnsi.net [216.8.131.222]) by e450.mnsi.net (8.11.2/8.11.2) with SMTP id f4U5JGk08158; Wed, 30 May 2001 01:19:17 -0400 (EDT) Message-ID: <00a901c0e8c7$d05a7920$fd00a8c0@Home> From: "Ryan Masse" To: "Gerard Samuel" Cc: "FreeBSD-Questions" References: <3B144374.996414E9@optonline.net> <3B144ED5.F86EE61B@iowna.com> <3B148021.60CB7680@optonline.net> Subject: Re: mysql tcp connection Date: Wed, 30 May 2001 01:17:25 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 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 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. > Well I hunted the online doc, and found out how to add a user where they > could > log on from only my domain. It was a piece of cake after that to connect via > > tcp. This whole mysql thing is a lot. I jumped in too fast, need to get > a book or something.... > > > > Bill Moran wrote: > > > Gerard Samuel wrote: > > > > > > Hey all. Im trying to use a GUI frontend on windows to control mysql on > > > a box on > > > my lan. > > > Network tcp wise, everything is good. When I try to connect to the box, > > > it gets denied access. > > > I supplied the correct password, which Ive been using on the console. > > > In /usr/local/bin/safe_mysqld, I have > > > MYSQL_TCP_PORT=${MYSQL_TCP_PORT:-3306}. > > > I tried connecting on that port, but no avail. > > > What else needs to be done?? > > > Thanks > > > > Quintinple check your MySQL rights. It's possible to have a user that > > can access the server from the localhost, but not from any other host > > (the root user is configured this way by default) You can even have > > different passwords for the same user from different machines. > > MySQL has very complex security. This one feature alone is enough to > > confuse anyone. I recommend using a GRANT command to create an entirely > > new user with access from any host, if you can then connect as this > > user, you know it's the MySQL privies that are causing trouble. > > > > -Bill > > > > -- > > 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 > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message