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

Root password lost on restart; can't log in afterward.

    XMLWordPrintable

Details

    Description

      This is reproducible on AltLinux and Ubuntu 16.04.

      MariaDB version:
      mysqld Ver 10.1.27-MariaDB-alt1.M80P.1 for Linux on x86_64 ((ALT))

      Steps:

      1) Install MariaDB as normal (apt-get install mariadb, or use aptitude)
      2) Set root password with /bin/mysqld_secure_installation, including a flush privileges
      3) Modify /etc/my.cnf.d/server.conf with the following:

      • disable skip-networking
      • enable bind-address=0.0.0.0
      • change server-id
        4) Validate root user can log in (mysql -u root -p), success
        5) Restart mysqld using systemctl restart mysqld
        6) Try to log in as root user (mysql -u root -p), authentication failure, both with and without passwords.
        7) Running with --no-grant-tables yields the following output (attempting to set the password to qwerty)

        [root@hostname]# mysqld_safe --skip-grant-tables &
        [1] 39760
        [root@hostname]# [1]+  Done                    mysqld_safe --skip-grant-tables
         
        [root@hostname]# ps auxwwww | grep mysqld
        root     39786  0.0  0.0   8604  2628 pts/1    S    21:40   0:00 /bin/sh /usr/sbin/mysqld_wrapper --skip-grant-tables
        mysql    39791  7.2  1.7 719176 139904 pts/1   SNl  21:40   0:00 /usr/sbin/mysqld --skip-grant-tables
        root     39819  0.0  0.0   8256   860 pts/1    S+   21:40   0:00 grep mysqld
        [root@hostname]# mysqladmin -u root password qwerty
        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
        [root@hostname]# mysqladmin flush-privileges password 'qwerty'
        mysqladmin: unable to change password; error: 'You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings'
        [root@hostname]#
        

      So far as I can tell, this version of MariaDB literally will lose the root password in a way that requires reinstallation. Unless there's something obvious here that I'm missing?

      Attachments

        Activity

          People

            Unassigned Unassigned
            get.marcus.h Marcus Hoffman
            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.