I had cleared down the user table, and had the correct entries, BUT I had not cleared down the DB tables, as I thought grant would do this.
after clearing down the db table and then granting the privileges it worked. Sorry for the mistake on my part all but I have a better understanding of whats going on. I thank everyone for their time on this problem. one thing though, I am surprised that grant did not alter the db table ? does this surprise anyone else. Thanks, Matt. -----Original Message----- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 14:00 To: '[EMAIL PROTECTED]'; Carl Troein; [EMAIL PROTECTED] Subject: RE: command mysql -u $user without typing it ???? Matt: Can you check and see if you have more than 1 entry for user in your user table? I wonder if there were more than 1 entry in the user table for user, MySQL might pick the first one which do not allow you to connect using user user. Kam -----Original Message----- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 7:31 AM To: Carl Troein; [EMAIL PROTECTED] Subject: RE: command mysql -u $user without typing it ???? Carl, great attempt, but that would be far to easy, I have removed the localhost entry and the jordan.no-dns.co.uk entry, the only place this remains is for root. dba and matt only have 1 entry, which is % so keep I am still in the dark -----Original Message----- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 07:37 To: [EMAIL PROTECTED] Subject: Re: command mysql -u $user without typing it ???? Matthew Darcy writes: > I was aware of the user table as a standard table. > > I did a select on it and it all looked fine. Loads of Y's and % for host > Yet this user still cannot connect. The only explaination is corruption. It sounds to me like you haven't removed the @localhost entry, but you want user@% to be matched when you connect from localhost. Could that be it? If so, section 4.2.8 is your (rather dull) friend. //C -- Carl Troein - Crdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
