Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #569

Re: MySQL user management vs PostgreSQL

Followups directed to: comp.databases.mysql

Show all headers | View raw

Jerry Stuckle wrote:

Hi Jerry,

> 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.

Right - so I was right in thinking that was how it was behaving...
 
> MySQL is not PostGres and it's authentication works differently.  And
> DB2, Oracle and SQL Server each work differently, also.

Yep.

> 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.
> 

I think I will have to do that - as a sysadmin, I don't want to be calling 
the user for their password everytime this happens (often). Sounds like a 
handy stored procedure could be written to do this - I'll look into that.

Longer term, I'll probably rationalise the whole thing so accounts have 
access from entire sub-networks instead of host by host.

Pity they didn't have a nice option for "dup the password" on grant :(

Thanks for your help.

Cheers,

Tim

-- 
Tim Watts

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