[debian-mysql] Bug#800009: Workaround found

[Matijs van Zuijlen]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20150925/84bf50c0/attachment.sig>