ROGER! Thanks a lot. After updating with that GRANT I am now looking at the main DB in EpiInfo 2000 via ODBC (EpiInfo....stats and graphics on the cheap courtesy of CDC if anybody cares)
Anyhow, it seems I was being too specific in my user name in the ODBC config (jim@somehost instead of jim) given that I had turned resolution off in my.cnf. Or so it seems.... Anyhow, I am good to go now. Many thanks for saving me another 2-4 hours of head banging! Jim On Tue, 22 Oct 2002, Roger Davis wrote: > Sounds like all is set up properly, but, have you give your mysql USERS > permissions to connect from from the 192.168.1 network? > > The Really Insecure way of doing this is... > > GRANT ALL PRIVILEGES ON *.* TO mysqlusernamehere@"%" IDENTIFIED BY > 'mypasswordhere'; > > FLUSH PRIVILEGES; > > Hope this helps > > Roger > > SQL, MySQL > > > -----Original Message----- > From: Jim Hogan [mailto:jimhogan@;drizzle.com] > Sent: Tuesday, October 22, 2002 11:32 PM > To: [EMAIL PROTECTED] > Subject: Making MySQL insecure on purpose... > > > I have set up MySQl before and have done it "the right way" (I think!) > > My situation today? I am setting up MySQL on a Linux machine with a 1394- > attached 80GB drive for a 3-week project after which my setup will be > thrown away. Due to some software dependencies, this DB will need to be > accessed by a Win2K box running MyODBC. An isolated, 2-node network. > > Well, I am 90 percent of the way there, DB us running and accessible on > localhost with phpMyAdmin, but (after 2-3 hours of wresting) MyODBC client > still returns 1130 errors..."Unable to connect from host 192.168.1.100". > > Yes, I have looked through the docs and have made all changes to > mysql:host/user that I could think of, have added "skip-name-resolve" to > my.cnf options. > > Time is of the essence. To short-circuit this particular problem and > perhaps get on with my real work, I ask: > > Is there a set of CNF and mysql DB entries that I could implement that > would assure that I have the *least* secure MySQL config possible?!?!? > > *Then* if I'm still getting 1130s and such, well, I'll just have to > troubleshoot some more!! > > Thanks, > > Jim > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- -*- Jim Hogan [EMAIL PROTECTED] Seattle, WA www.drizzle.com/~jimhogan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
