Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
If you try too simple a password with mysqladmin, you get the wrong error message:
[root@mg-m103 ~]# mysqladmin password -p
Enter password:
New password:
Confirm new password:
[root@mg-m103 ~]#
[root@mg-m103 ~]# mysql -Ap <<< "INSTALL SONAME 'simple_password_check'"
Enter password:
[root@mg-m103 ~]# mysqladmin password -p
Enter password:
New password:
Confirm new password:
mysqladmin:
You cannot use 'password' command as mysqld runs
with grant tables disabled (was started with --skip-grant-tables).
Use: "mysqladmin flush-privileges password '*'" instead
The server sends the correct message:
recvfrom(3, "w\0\0\1\377\n\5#HY000The MariaDB server is running with the --strict-password-validation option so it cannot execute this statement", 16384, MSG_DONTWAIT, NULL, NULL) = 123
Thanks for the report. Reproducible as described on all of 10.1-10.5.
--exec $MYSQLADMIN -uroot password foo
10.5 f544a712
install soname 'simple_password_check';
bug.t [ fail ]
Test ended at 2020-05-05 02:32:26
CURRENT_TEST: bug.t
/data/bld/10.5-debug/bin/mysqladmin:
You cannot use 'password' command as mysqld runs
with grant tables disabled (was started with --skip-grant-tables).
Use: "mysqladmin flush-privileges password '*'" instead
mysqltest: At line 3: exec of '/data/bld/10.5-debug/bin/mysqladmin --defaults-file=/data/bld/10.5-debug/mysql-test/var/my.cnf -uroot password foo' failed, error: 65280, status: 255, errno: 11
Output from before failure:
install soname 'simple_password_check';