26 messages in com.mysql.lists.mysqlRE: command mysql -u $user without ty...
FromSent OnAttachments
Matthew Darcy09 Jan 2002 07:23 
Gerald Clark09 Jan 2002 07:55 
Matthew Darcy09 Jan 2002 08:03 
Carl Troein09 Jan 2002 08:03 
Ho, Kam09 Jan 2002 08:09 
Matthew Darcy09 Jan 2002 08:50 
Ho, Kam09 Jan 2002 08:56 
Matthew Darcy09 Jan 2002 11:25 
Ho, Kam09 Jan 2002 11:30 
Quentin Bennett09 Jan 2002 11:39 
James Montebello09 Jan 2002 11:43 
Matthew Darcy09 Jan 2002 12:38 
James Montebello09 Jan 2002 13:32 
Matthew Darcy09 Jan 2002 15:26 
Quentin Bennett09 Jan 2002 15:35 
Doug Thompson09 Jan 2002 20:38 
Carl Troein09 Jan 2002 23:37 
Matthew Darcy10 Jan 2002 01:50 
Matthew Darcy10 Jan 2002 02:10 
Matthew Darcy10 Jan 2002 04:24 
Matthew Darcy10 Jan 2002 04:30 
Ho, Kam10 Jan 2002 06:00 
Gerald Clark10 Jan 2002 07:01 
Matthew Darcy10 Jan 2002 07:09 
Quentin Bennett10 Jan 2002 11:32 
Matthew Darcy10 Jan 2002 12:33 
Subject:RE: command mysql -u $user without typing it SORTED THANKS ALL !!!!
From:Matthew Darcy (matt@darcy.demon.co.uk)
Date:01/10/2002 07:09:02 AM
List:com.mysql.lists.mysql

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:kam@ghrsystems.com] Sent: 10 January 2002 14:00 To: 'matt@darcy.demon.co.uk'; Carl Troein; mys@lists.mysql.com 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:matt@darcy.demon.co.uk] Sent: Thursday, January 10, 2002 7:31 AM To: Carl Troein; mys@lists.mysql.com 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:ca@thep.lu.se] Sent: 10 January 2002 07:37 To: mys@lists.mysql.com 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 ca@thep.lu.se | 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-matthew=darc@lists.mysql.com> 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-kam_ho=ghrs@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php