Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #567

MySQL user management vs PostgreSQL

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> (permalink)
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

Followups directed to: comp.databases.mysql

Show key headers only | View raw

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

Back to comp.databases.mysql | Previous | Next — Next in thread | Find similar

Thread

MySQL user management vs PostgreSQL Tim Watts <tw@dionic.net> - 2011-04-17 20:24 +0100
  Re: MySQL user management vs PostgreSQL Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-17 15:34 -0400
    Re: MySQL user management vs PostgreSQL Tim Watts <tw@dionic.net> - 2011-04-18 07:21 +0100
      Re: MySQL user management vs PostgreSQL Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-18 05:45 -0400
      Re: MySQL user management vs PostgreSQL gordonb.lozmd@burditt.org (Gordon Burditt) - 2011-04-19 04:35 -0500
        Re: MySQL user management vs PostgreSQL Axel Schwenke <axel.schwenke@gmx.de> - 2011-04-19 12:10 +0200
  Re: MySQL user management vs PostgreSQL Axel Schwenke <axel.schwenke@gmx.de> - 2011-04-18 12:27 +0200
    Re: MySQL user management vs PostgreSQL Tim Watts <tw@dionic.net> - 2011-04-18 16:42 +0100

csiph-web