Bug#800009: [debian-mysql] Bug#800009: Bug#800009: Workaround found

2016-01-01 Thread Otto Kekäläinen
This issue is now fixed in 10.0.23-1 as the passwordless root account authenticated via unix socket is only used on fresh installs. Old installs will continue to use any root password previously set.

Bug#800009: [debian-mysql] Bug#800009: Workaround found

2015-09-25 Thread Otto Kekäläinen
2015-09-25 12:51 GMT+03:00 Matijs van Zuijlen : > 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

Bug#800009: Workaround found

2015-09-25 Thread 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

Bug#800009: Workaround found

2015-09-25 Thread Matijs van Zuijlen
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;