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
