Re: Change password the new hash

[Matthias Fechner]

Hi Jon,

not really, I get:
7121 - IWs 0:00.00 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/hostname.pid
7217 - I 13:29.39 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --log-error=/var/db/mysql/hostname.err --pid-file=/var/db/mysql/hostname.pid

I replaced the real hostname here with hostname.
I see that there is an option that points to my.cnf. This file is not existing.

All other files are looking fine.
The lib folder does contain only new files:
2 drwxr-xr-x 3 root wheel 11 Feb 8 14:55 .
39 drwxr-xr-x 51 root wheel 1302 Feb 9 19:25 ..
5126 -rw-r--r-- 1 root wheel 5167996 Feb 8 14:40 libmysqlclient.a
1 lrwxr-xr-x 1 root wheel 20 Feb 8 14:41 libmysqlclient.so -> libmysqlclient.so.18
3973 -rwxr-xr-x 1 root wheel 4013792 Feb 8 14:41 libmysqlclient.so.18
1 lrwxr-xr-x 1 root wheel 16 Feb 8 14:41 libmysqlclient_r.a -> libmysqlclient.a
1 lrwxr-xr-x 1 root wheel 17 Feb 8 14:41 libmysqlclient_r.so -> libmysqlclient.so
1 lrwxr-xr-x 1 root wheel 20 Feb 8 14:41 libmysqlclient_r.so.18 -> libmysqlclient.so.18
27031 -rw-r--r-- 1 root wheel 27594832 Feb 8 14:54 libmysqld.a
7 -rw-r--r-- 1 root wheel 6366 Feb 8 14:40 libmysqlservices.a
2 drwxr-xr-x 2 root wheel 14 Feb 8 14:55 plugin

The date of the files are matching my upgrade date.

I solved the problem now (that is why I think it is a bug).
I executed:
show grants for 'test'@'localhost';
To get the permission for the user.
drop user 'test'@'localhost';
To drop the user.
grant select,execute on test.* to 'test'@'localhost' identified by 'test';
To create the user.

Now everything is working fine.
I also tried to set a new password with:
set password for 'test'@'localhost' = password('cheese');
It worked fine.

So in this case the only solution is to drop the account and create it again.

Thanks for help.

I think to reproduce this error, do a update command on the password field of an old hashed password and set there a new password string. After this execute:
flush privileges
That is if I remeber correctly the procedure I did (before I learned that there is a command set password).

Thanks
Matthias