[debian-mysql] Bug#797210: Bug#797210: mariadb-10.0: mariadb-server does not ship a debconf set for creating a adminitrative user (like mysql-server do)

[Carsten Schoenert]

Hello,

On Fri, Aug 28, 2015 at 08:58:46PM +0300, Otto Kekäläinen wrote:
> MariaDB uses socket authentication in Debian unstable. That is an
> important feature that increases security and makes administration
> easier. In the majority of cases you don't need or want to make a root
> user, only user accounts that have limited and intended access to the
> database.
> 
> I don't know what README.Debian you refer to. The mariadb-10.0 does
> not have any such file.

I think it has.
http://anonscm.debian.org/cgit/pkg-mysql/mariadb-10.0.git/tree/debian/mariadb-server-10.0.README.Debian

That's there I have found the needed information how to set up a user so
dbconfig-common can setup a database. And the information there is
contrary to your words above!

snip --->

  * WHAT TO DO AFTER INSTALLATION:
  ================================
  The MySQL manual describes certain steps to do at this stage in a separate
  chapter.  They are not necessary as the Debian packages does them 
  automatically.

  The only thing that is left over for the admin is
   - setting the passwords
   - creating new users and databases
   - read the rest of this text

  ...

  * PASSWORDS:
  ============
  It is strongly recommended you create an admin users for your database
  adminstration needs.

<--- snip

> I will close this bug report as invalid, because what you report about
> is not a bug, maybe just a misunderstanding.

Maybe it is a misunderstanding, but the wiki page is currently quite
useless for users. As I haven't found further information or a hint
where to find so I opened up this report.

> Please feel free to contribute with documentation, there could maybe
> be a README.Debian file in the package that explains something about
> how authentication works.

I don't have deeper knowledge how mariadb is in detail working better or
different from mysql, if so I'd be happy to contribute.

So if you can provide useful information how interact to a
mariadb-server via dbconfig-common I'd be happy. I asked the maintainer
of dbconfig-common and he can't do much here. He is interested in
improving situations.

Regards
Carsten