Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #568

Re: MySQL user management vs PostgreSQL

Show all headers | View raw

On 4/17/2011 3:24 PM, Tim Watts wrote:
> 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

You don't.  If you want them to have to use a password, you need to 
specify the password in the grant for that host.

MySQL is not PostGres and it's authentication works differently.  And 
DB2, Oracle and SQL Server each work differently, also.

Now, with that said, you *could* just insert the row into the 
mysql.users table, taking the password from an existing row for that 
user.  But you have to be very careful and know what you're doing when 
dealing with the mysql.xxx tables - you can easily leave yourself with 
an non-working system.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.databases.mysql | Previous | Next — Previous in thread | 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