mysql connect problems

[Jorn Argelo]

On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote
> On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo <jorn at wcborstel.nl> wrote:
> > > "select user, password, host from user;" on 'mysql' returned 3 'root'
> > > entries using 2 different passwords (localhost, %, and the actual
> > > host name), 2 anon entries (localhost and host name), 2 'mtuser' entries
> > > (one on localhost w/o pw, one on '%'), and one 'wikiuser' entry
> > > (localhost w/o pw).  I changed the root passwords so they all use the
> > > same one, and changed the 'mtuser' entry that didn't have a password
> > > so its password matches that of the other entry.
> > 
> > Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO
> > 'youruser at localhost';
> 
> Yes: I ran both of these commands as root:
> GRANT ALL ON wikidb.* TO wikiuser;
> GRANT ALL ON mtdb.* TO mtuser;
> FLUSH PRIVILEGES;

AFAIK you must type 'wikiuser at localhost' (including the quotes). If that 
doesn't work, then I don't know it either. Perhaps somebody else on the list 
has an idea?

Jorn.