RE: blank user names in user table (SOLVED)

2006-05-05 Thread Duzenbury, Rich
> -Original Message- > From: sheeri kritzer [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 2:37 PM > To: Duzenbury, Rich > Cc: mysql@lists.mysql.com > Subject: Re: blank user names in user table > > Rich, > > anonymous access means that '&#x

Re: blank user names in user table

2006-05-05 Thread sheeri kritzer
Rich, anonymous access means that ''@host has access. That is, "blank" at host, as opposed to [EMAIL PROTECTED] To see if anonymous access is allowed, at the command prompt type: mysql -u asdf if you get a mysql login, you have anonymous access. Otherwise you'll get: ERROR 1045 (28000): Acce

blank user names in user table

2006-05-04 Thread Duzenbury, Rich
Hi all, I've got a database I recently inherited where there are a number of records in the mysql.user table that have no user id. According to the mysql docs, this is supposed to allow guest access, and there is mention of how to turn it off. How does one actually connect in guest mode? My att