List:General Discussion« Previous MessageNext Message »
From:Alex Vorobiev Date:July 23 1999 8:10pm
Subject:Re: reload blanks out root passw after grant ??
View as plain text  
just upgraded
same goes for Mysql 3.22.25

> 
> Alex Vorobiev writes:
>  > 
>  > 	thanks for your input.  i am sorry if i haven't  been very clear.
>  > 	let's take a look at a couple of mysql sessions (see my comments
>  > 	in caps):
>  > 
>  > 
>  > mysql> select user,password from user where user='root' and
> host='localhost';
>  > +------+----------+
>  > | user | password |
>  > +------+----------+
>  > | root |          |
>  > +------+----------+
>  > 
>  > mysql> grant all on *.* to root@localhost identified by 'test';
>  > Query OK, 0 rows affected (0.00 sec)     
>  > 
>  > mysql> select user,password from user where user='root' and
> host='localhost';
>  > +------+----------+
>  > | user | password |
>  > +------+----------+
>  > | root |          |
>  > +------+----------+             
>  > 
>  > (PLEASE NOTE THAT THE PASS FIELD IS BLANK, EVEN THOUGH THE PASSW SEEMS TO
>  > HAVE BEEN SET)
>  > 
>  > mysql> select length(password) from user where user='root' and
>  > host='localhost';
>  > +------------------+
>  > | length(password) |
>  > +------------------+
>  > |                0 |
>  > +------------------+    
>  > mysql> exit
>  > Bye 
>  > 
>  > # mysql
>  > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) 
>  > 
>  > # mysql -ptest
>  > Welcome to the MySQL monitor.  Commands end with ; or \g.
>  > Your MySQL connection id is 39 to server version: 3.22.24-log
>  > 
>  > Type 'help' for help.
>  > 
>  > mysql> 
>  > 
>  > mysql> select user,password from user where user='root' and
> host='localhost';
>  > +------+----------+
>  > | user | password |
>  > +------+----------+
>  > | root |          |
>  > +------+----------+        
>  > 
>  > mysql> exit
>  > Bye 
>  > 
>  > # mysqladmin reload -ptest
>  > 
>  > (PLEASE NOTE THAT ONCE I RUN RELOAD, THE PREVIOUSLY SET ROOT PASSWORD IS 
>  > NOW BLANKED OUT)
>  > 
>  > # mysql
>  > Welcome to the MySQL monitor.  Commands end with ; or \g.
>  > Your MySQL connection id is 41 to server version: 3.22.24-log
>  > 
>  > Type 'help' for help.
>  > 
>  > mysql> 
>  > 
>  > 
>  > 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
>  > 
> 
> 
> Hi!
> 
> That is odd.
> 
> It might be some bug in 3.22.24.
> 
> 
> Pleae try 3.22.25 if see if it is pertaining.
> 
> 
> 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