mysql connect problems

[Peter Risdon]

Jorn Argelo wrote:
> 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?

I have found it's best to connect to the database you want to grant the 
privileges on before issuing the GRANT command. This doesn't seem to be 
the way it's documented, but it works for me. You might also consider 
using passwords...

mysql>\u wikidb
mysql>GRANT ALL on wikidb.* to wikiuser at localhost IDENTIFIED BY 'password';
mysql>\u mtdb
mysql>GRANT ALL on mtdb.* to mtuser at localhost IDENTIFIED BY 'password';


Peter.


-- 

the circle squared

network systems and software

http://www.circlesquared.com