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 |
+----------------------------------------------------------------------+