Public bug reported: adminuser@fortuna:~$ lsb_release -rd Description: Ubuntu 16.04 LTS Release: 16.04
adminuser@fortuna:~$ apt-cache policy mariadb-server mariadb-server: Installiert: 10.0.24-7 Installationskandidat: 10.0.24-7 Versionstabelle: *** 10.0.24-7 500 500 http://de.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages 500 http://de.archive.ubuntu.com/ubuntu xenial/universe i386 Packages 100 /var/lib/dpkg/status I've found the following failure in my syslog after installing Ubuntu 16.04 and MariaDB from the Scratch using this really awesome tutorial https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql- on-ubuntu-16-04-lamp/ May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Looking for 'mysql' as: /usr/bin/mysql May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Version check failed. Got the following error when calling the 'mysql' command line client May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: FATAL ERROR: Upgrade failed May 14 12:00:13 fortuna /etc/mysql/debian-start[1487]: Checking for insecure root accounts. May 14 12:00:13 fortuna mysql[1020]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I've already created a .my.cnf in the /root directory. If i run "mysql" as root i can login without a password. (See below) root@fortuna:~# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7071 Server version: 10.0.24-MariaDB-7 Ubuntu 16.04 Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> But if i try to use mysqlcheck check i get an error like this: root@fortuna:~# /usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf --all-databases --fast --silent /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect If i took a closer look then i found out that there is a file /etc/mysql/debian.cnf which should contain the passwords. But there is no password listed in there. On the other hand i should not type it in here because it say's DO NOT TOUCH! What shall I do? # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = root password = socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = root password = socket = /var/run/mysqld/mysqld.sock basedir = /usr What you expected to happen: The password should be also entered in the /etc/mysql/debian.cnf file What happened instead: See above, there is an error while the startup process and the file does not contain the updated password. ** Affects: mariadb-10.0 (Ubuntu) Importance: Undecided Status: New ** Tags: 16.04 mariadb mariadb-server -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1582209 Title: mysql_secure_installation does not update /etc/mysql/debian.cnf To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1582209/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs