Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!weretis.net!feeder4.news.weretis.net!news.mixmin.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: Tim Watts <tw@dionic.net>
Newsgroups: comp.databases.mysql
Subject: MySQL user management vs PostgreSQL
Followup-To: comp.databases.mysql
Date: Sun, 17 Apr 2011 20:24:52 +0100
Organization: A noiseless patient Spider
Lines: 29
Message-ID: <5drr78-heq.ln1@squidward.dionic.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
Injection-Info: mx03.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="26875"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX198Q7Pqvwvue2FjHl1nQMiVV6sVDeF+iXk="
User-Agent: KNode/4.4.6
Cancel-Lock: sha1:ZII3qvxBtWLaRCb1fM21iM+y0xI=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:567

Hi,

I come from the Postgres world where one user has one password[1] and 
pg_hba.conf decides which hosts that user may connect from.

[1] OK, it can get funky - but for the sake of argument, let's assume so...

I'm not a MySQL buff but I have inherited a few:

*Seems* to be the case that a password belongs to the pattern 
"user@somewhere" rather than just "user".

Correct me if I'm wrong - but when I did some extra grants to allo a user to 
connect from some extra client hosts, the new user was passwordless(!) (the 
original user@somblah did require a password.

If I've got the right end of the stick, how do I grant access to a user to a 
database (and tables etc etc) without having to specify a password - ie to 
have the system use only one password?

I did RTFM but as I haven't found a tome "MySQL for PostgreSQL admins" I 
haven't seen a really clear explanation of how MySQL authentication works.

Any comments received with thanks!

Cheers

Tim
-- 
Tim Watts