Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22418

mysqladmin wrong error with simple_password_check

Details

    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

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          mg MG created issue -
          mg MG made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Minor [ 4 ]
          elenst Elena Stepanova added a comment -

          Thanks for the report. Reproducible as described on all of 10.1-10.5.

          install soname 'simple_password_check';
          		 
           
          		 
          --exec $MYSQLADMIN -uroot password foo
          		 
           
          		 
          --echo # All done

          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';

          elenst Elena Stepanova added a comment - Thanks for the report. Reproducible as described on all of 10.1-10.5. install soname 'simple_password_check' ;   --exec $MYSQLADMIN -uroot password foo   --echo # All done 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';
          elenst Elena Stepanova made changes -
          Fix Version/s 10.1 [ 16100 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Affects Version/s 10.1 [ 16100 ]
          Affects Version/s 10.2 [ 14601 ]
          Affects Version/s 10.3 [ 22126 ]
          Affects Version/s 10.4 [ 22408 ]
          Affects Version/s 10.5 [ 23123 ]
          Assignee Oleksandr Byelkin [ sanja ]
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.1 [ 16100 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 107994 ] MariaDB v4 [ 144248 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.2 [ 14601 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.3 [ 22126 ]
          danblack Daniel Black made changes -
          Assignee Oleksandr Byelkin [ sanja ] Daniel Black [ danblack ]
          danblack Daniel Black made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ] Andrew Hutchings [ JIRAUSER52179 ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          danblack Daniel Black made changes -
          issue.field.resolutiondate 2023-10-06 08:11:06.0 2023-10-06 08:11:05.725
          danblack Daniel Black made changes -
          Fix Version/s 10.4.32 [ 29300 ]
          Fix Version/s 10.5.23 [ 29012 ]
          Fix Version/s 10.6.16 [ 29014 ]
          Fix Version/s 10.10.7 [ 29018 ]
          Fix Version/s 10.11.6 [ 29020 ]
          Fix Version/s 11.0.4 [ 29021 ]
          Fix Version/s 11.1.3 [ 29023 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Assignee Andrew Hutchings [ JIRAUSER52179 ] Daniel Black [ danblack ]
          Resolution Fixed [ 1 ]
          Status In Review [ 10002 ] Closed [ 6 ]

          People

            danblack Daniel Black
            mg MG
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.