Petre Agenbag wrote: > 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
IMHO stick with 7.3 Both use 2.4.18-x kernels so you're really not getting anything out of 8.0 but gcc3 and some lost functionality from kde. Be careful upgrading glib packages on 7.3 as there some issues with client breakage due to one of the updates (check the mysql archives). We're using 2.4.18-SGI_XFS_1.1enterprise from SGI and have been thrilled with it. The journaling is a must since we have 300+ GB of data on the server which takes about an hour to fsck. We've been running SGI kernels for several years without any problems (knock on wook!). http://oss.sgi.com/projects/xfs/ walt --------------------------------------------------------------------- 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
