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

SET PASSWORD on added unix_socket auth doesn't set password for mysql_native_password

    XMLWordPrintable

Details

    Description

      $  podman run -e MARIADB_ROOT_PASSWORD=hohum -d mariadb:10.4
       
      $ podman exec -ti clever_antonelli mysql -phohum
       
      MariaDB [(none)]> show create user;
      +---------------------------------------------------------------------------------------------------+
      | CREATE USER for root@localhost                                                                    |
      +---------------------------------------------------------------------------------------------------+
      | CREATE USER `root`@`localhost` IDENTIFIED BY PASSWORD '*B0D72986672390CF3C294D28B2024176FDC0BA94' |
      +---------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> alter user root@localhost identified via unix_socket or mysql_native_password;
      Query OK, 0 rows affected (0.003 sec)
       
      MariaDB [(none)]> show create user;
      +------------------------------------------------------------------------------------+
      | CREATE USER for root@localhost                                                     |
      +------------------------------------------------------------------------------------+
      | CREATE USER `root`@`localhost` IDENTIFIED VIA unix_socket OR mysql_native_password |
      +------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> set password for root@localhost='*B0D72986672390CF3C294D28B2024176FDC0BA94';
      Query OK, 0 rows affected (0.019 sec)
       
      MariaDB [(none)]> show create user root@localhost;
      +--------------------------------------------------------------------------------------------------------------------------------------+
      | CREATE USER for root@localhost                                                                                                       |
      +--------------------------------------------------------------------------------------------------------------------------------------+
      | CREATE USER `root`@`localhost` IDENTIFIED VIA unix_socket USING '*B0D72986672390CF3C294D28B2024176FDC0BA94' OR mysql_native_password |
      +--------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> select version();
      +---------------------------------------+
      | version()                             |
      +---------------------------------------+
      | 10.4.22-MariaDB-1:10.4.22+maria~focal |
      +---------------------------------------+
      1 row in set (0.001 sec)
      

      We end up with a password set on unix_socket, not mysql_native_password.

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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