Bug#848616: #848616: mysql_install_db creates unusable root user

2016-12-21 Thread Christian Hofstaedtler
* Otto Kekäläinen [161221 23:11]: > To be able to access your test database anyway, use > --skip-grant-tables to circumvent authentication (which is not needed > on a test database, right?). Test suites also test authentication failure, and GRANT statements. None of these work with --skip-grant-t

Bug#848616: #848616: mysql_install_db creates unusable root user

2016-12-20 Thread Otto Kekäläinen
I've tested this a bit. The reason why you cannot access as root the default database is that in Debian we now how unix socket authentication enabled by default, and the default account allows 'root' to access mysqld via socket. So running your mysqladmin as sudo works, but that of course defeats t

Bug#848616: #848616: mysql_install_db creates unusable root user

2016-12-18 Thread Christian Hofstaedtler
Here's a silly workaround I've added to ruby-mysql2, but this really can't be the solution: https://anonscm.debian.org/cgit/pkg-ruby-extras/ruby-mysql2.git/commit/?id=38e0a5633506fd115853aa0b16b91a7441069db5 -- christian hofstaedtler