That works fine, I can log in as my root user and the perms look fine, I also use phpmyadmin, and looks fine too, can access all my db's that way, just the odbc that seems to be bitchin. It's not a train smash, I exported it to my older rh7.0 server over the net, but I'd still like to know for future what causes this, as I'm to decide soon what to upgrade to, 7.3 or 8.0, at this point, I'm leaning heavily towards 7.3 as my gutt tells me this might be some kind of a bug.
Thanks for the help so far. On Tue, 2002-10-22 at 22:07, walt wrote: > On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote: > > Hi Walt > > Thanks for the quick reply. > > > > Answer to both questions is yes. > > As a matter of interest, > > What I usually do is to create a "myodbc" db with a "myodbc" user and > > password "myodbc" > > I create this db and user with the mysql_setpermission util, and I use > > "%" for the host name. > > YET, when I try to connect from the localhost, it denies permission, > > only accepts connections from remote location ( not ODBC though, I used > > a php script on another host to test connection) > > > > Any ideas? > > > > Thanks > > > > On Tue, 2002-10-22 at 21:37, walt wrote: > > > Petre Agenbag wrote: > > > > query , sql > > > > > > > > Hi > > > > Any known issues with RH8.0 and ODBC? > > > > I keep getting lost connection messages when trying to connect from a > > > > windows box to mysql, it worked 100% on a 7.3RH box. > > > > There is no firewall. > > > > Any workarounds? > > > > > > > > --------------------------------------------------------------------- > > > > 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 > > > > <snip> > > Petre, > I've never used the mysql_setpermission util before so I'm really not sure. > Have you tried logging in on the server using the OS mysql user? > To clarify - > su - mysql > /usr/bin/mysql > > If you can get in that way, you can look at the different user permissions and > possibly see what's wrong > > > -- > Walter Anthony > System Administrator > National Electronic Attachment > Atlanta, Georgia > 1-800-782-5150 ext. 1608 > "If it's not broke....tweak it" --------------------------------------------------------------------- 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
