On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote
On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo <[EMAIL PROTECTED]> 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 '[EMAIL PROTECTED]';
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 '[EMAIL PROTECTED]' (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 [EMAIL PROTECTED] IDENTIFIED BY 'password'; mysql>\u mtdb mysql>GRANT ALL on mtdb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
Peter.
--
the circle squared
network systems and software
http://www.circlesquared.com _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
