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 specify the passwor

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 passwor

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; Start