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