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/[EMAIL PROTECTED]
