more MySQL issues

On Fri, 2003-02-07 at 12:31, mazdaracer wrote:
> There's all of it. The gist is that only 2 users are listed.
>
That's what i was afraid of. Add instead a default user with NO
privlages

INSERT INTO user (Host, User, Password) VALUES("", "Nobody", "");
INSERT INTO user (Host, User, Password) VALUES("localhost", "%", "");

Then you can add more users with various access privs from different
hosts, and access to specific DBs

Definitely go rent/read the Mysql and Msql book from Oreilly.
They have a chapter that talks about how MySQL queries the mysql db when
determing log-ins.