Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #567

MySQL user management vs PostgreSQL

Followups directed to: comp.databases.mysql

Show all headers | 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