Your message dated Sat, 11 Mar 2017 21:09:48 -0700
with message-id <[email protected]>
and subject line Re: Bug#855098: mariadb-server: Passwordless root access does
not work on new installation
has caused the Debian Bug report #855098,
regarding mariadb-server: Passwordless root access does not work on new
installation
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
855098: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=855098
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server
Version: 10.1.21-5
Severity: important
Newly installed mariadb-server. How the hell is this passwordless root thing
supposed to work?
user@myhost-->sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO)
root@myhost# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO)
I was surprised when the installer didn't prompt me to create a root password.
Grepping through the /usr/share/doc/mariadb* files led to me to
mariadb-server-10.1/README.Debian.gz, which indicates that I should be able to
use sudo to get root access.
This behavior change is substantial enough that you may want to consider
actively notifying the user during installation. Even a "Please read the README
file at bla-bla-bla" would be fine since I don't really want to have to guess
which of the SEVEN /usr/share/doc/mariadb* directories has the README file I
want (BONUS FUN: THREE different mariadb-server* directories).
-- System Information:
Debian Release: 9.0
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.9.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages mariadb-server depends on:
ii mariadb-server-10.1 10.1.21-5
mariadb-server recommends no packages.
mariadb-server suggests no packages.
-- debconf-show failed
--- End Message ---
--- Begin Message ---
close 855098
stop
You were right. It turns out there was indeed some stay leftover DB
files on this system. I was using a cloned VM image from a master we use
for new systems and someone had improperly installed this package onto
the master image in the past and then failed to fully clean up after
removing the package.
Thanks!
On 2/13/2017 9:57 PM, Otto Kekäläinen wrote:
Hello!
There is a Debian.README, you did find it and you are using the
correct commands. It just does not work. You don't seem to have a
fresh install, but you have upgraded from something special or you
have a customized mysql.user table.
--- End Message ---
