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