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
