[Bug 1597863] Re: MariaDB install never asks for default root password

[David Favor]

This behavior breaks automated tools where --defaults-
file=/etc/mysql/debian.cnf should provide valid credentials.

Easy way to restore /etc/mysql/debian.cnf to be functional again...

Instructions relate to Yakkety/MariaDB + likely work with Xenial + MySQL
too.

1) First verify root can actually do anything from root, as sometimes
this is broken.

lxd: yakkety # mysql -uroot -p' ' -e 'SHOW DATABASES'
++
| Database   |
++
| information_schema |
| mysql  |
| performance_schema |

2) Change root password to known value

   lxd: yakkety # mysql -uroot -p' '
   use mysql;
   update user set password=PASSWORD("NEWPASSWORD") where User='root';
   update user set plugin="mysql_native_password";

3) Change password entries in /etc/mysql/debian.cnf from empty to
NEWPASSWORD + all should be well.

4) Test...

lxd: yakkety # mysql --defaults-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES'
++
| Database   |
++
| information_schema |
| mysql  |
| performance_schema |
++

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1597863

Title:
  MariaDB install never asks for default root password

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1597863/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1597863] Re: MariaDB install never asks for default root password

[ruleant]

As mentioned in the README (https://anonscm.debian.org/cgit/pkg-
mysql/mariadb-10.0.git/tree/debian/mariadb-server-10.0.README.Debian) :

'On new installs no root password is set and no debian-sys-maint user is
created anymore. Instead the MariaDB root account is set to be authenticated
using the unix socket, e.g. any mysqld invocation by root or via sudo will
let the user see the mysqld prompt.'


** Changed in: mariadb-10.0 (Ubuntu)
   Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1597863

Title:
  MariaDB install never asks for default root password

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1597863/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs