List:General Discussion« Previous MessageNext Message »
From:Alex Vorobiev Date:July 21 1999 9:24pm
Subject:reload blanks out root passw after grant ??
View as plain text  

feature or bug?

the ref. manual mentions 2 ways of setting passwords, one via the grant 
statement, another one via editing the user table.

the following 
	grant all on *.* to root@localhost identified by 'test'

changes root's pass to 'test', leaving, however, the password field in the
user table blank.

if i subsequently issue
	mysqladmin reload -p (having specified the new passw)
as root, the root password will be reset to blank.  i understand that
reload is redundant after grant, but i am trying to understand the logic
of this behavior.



system info:
------------
	mysqladmin version
mysqladmin  Ver 7.11 Distrib 3.22.24, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty

Server version          3.22.24-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 min 18 sec

Threads: 1  Questions: 14  Slow queries: 0  Opens: 10  Flush tables: 1  Open
tables: 6

	manufacturer and model of hardware
Quantex 1401


	uname -a
Linux rpm 2.2.5-22 #1 Wed Jun 2 08:45:51 EDT 1999 i586 unknown


free
	     total       used       free     shared    buffers     cached
	     Mem:         63136      40072      23064      35748       3352
	      26928
	      -/+ buffers/cache:       9792      53344
	      Swap:       136512          0     136512  


distribution 
MySQL-client-3.22.24-1.i386.rpm
MySQL-devel-3.22.24-1
MySQL-3.22.24-1     


Thread
reload blanks out root passw after grant ??Alex Vorobiev22 Jul
  • reload blanks out root passw after grant ??sinisa22 Jul
    • Re: reload blanks out root passw after grant ??Alex Vorobiev22 Jul
      • Re: reload blanks out root passw after grant ??sinisa22 Jul
        • Re: reload blanks out root passw after grant ??Alex Vorobiev24 Jul
  • reload blanks out root passw after grant ??Michael Widenius29 Jul