List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:July 22 1999 1:06pm
Subject:reload blanks out root passw after grant ??
View as plain text  
Alex Vorobiev writes:
 > 
 > 
 > 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     
 > 

Hi!

Do you login as a root with a new password, with no problem.

If yes, than password field is not blank.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
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