Ah, but then access with a password is no longer possible. Given that mariadb ships with a tool that sets a password on the root user, this situation is suboptimal.
The MariaDB startup scripts should allow root to be identified either way, and allow the system administrator to specify the password in /etc/mysql/debian.cnf. On 25/09/15 11:41, Matijs van Zuijlen wrote: > After some more digging, I realized it is not required for root to have no > password; it just needs to *also* have privileges granted when identified via > unix socket. I executed the following as the root user: > > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED VIA > unix_socket; > > Startup and automatic upgrade proceeded normally after that. > > I still believe the MariaDB installation should check and correct this. > > Regards, > Regards, -- Matijs
signature.asc
Description: OpenPGP digital signature
