[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: GRANT can't grant with a password?
From:       "Joshua J. Kugler" <jkugler () bigfoot ! com>
Date:       2005-01-12 0:30:32
Message-ID: 200501111530.33343.jkugler () bigfoot ! com
[Download RAW message or body]

Yes, I hadn't thought of that.  But at the same time, the way it's presently 
set up, you *can,* and must, create a user with no password.  That doesn't 
seem very safe either.

j----- k-----

On Tuesday 11 January 2005 05:17, Tom Crimmins said something like:
> [snip]
> It seems that the GRANT syntax should allow the setting of a password upon
> account creation without requiring access to the mysql db.
> [/snip]
>
> Example:
>
> GRANT SELECT ON dbihavegrantprivon.* TO 'root'@'localhost' IDENTIFIED BY
> 'newpassword';
>
> If you don't have privs to the mysql.user table you definitely should not
> be able to do that.

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]