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

[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-tables.

-- 
christian hofstaedtler 

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

[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 the purpose of your test deamon run
with only normal user priviledges. See
https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/

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?).

/usr/sbin/mysqld --no-defaults --socket=/tmp/tmp.WiS7YFCukw/mysql.sock
--datadir=/tmp/tmp.WiS7YFCukw --skip-networking --skip-grant-tables


This is not a bug in packaging, but instead of marking this invalid,
I'll leave the issue open for the sake of documentation.

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

[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