Date: Wed, 30 May 2001 01:17:25 -0400 From: "Ryan Masse" <mail@max-info.net> To: "Gerard Samuel" <trini0@optonline.net> Cc: "FreeBSD-Questions" <freebsd-questions@freebsd.org> Subject: Re: mysql tcp connection Message-ID: <00a901c0e8c7$d05a7920$fd00a8c0@Home> References: <3B144374.996414E9@optonline.net> <3B144ED5.F86EE61B@iowna.com> <3B148021.60CB7680@optonline.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?00a901c0e8c7$d05a7920$fd00a8c0>