Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
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?