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