Re: [webmin-l] Webmin: MySQL does not use debian-sys-maint account?

[Andrey R. <anr...@fr...>]

Greetings, Jamie Cameron!

>> I've stumbled upon an issue in our MySQL server and had to wipe and reinstall
>> the thing completely.
>> 
>> Now, it asks for MySQL root password, which I intentionally set to something I
>> don't know, since there's always a debian-sys-maint account I can use to
>> connect to localhost. (--defaults-extra-file=/etc/mysql/debian.cnf)
>> 
>> Would be nice, if Webmin would stop asking stupid questions and use that file
>> as well.

> Assuming the debian-sys-maint account has all the same permissions as root,
> you can configure Webmin to use it on the Module Config page of the MySQL module.

The point is, the file may change. I.e. when you reinstall the server.
Then Webmin will break again.
And storing sensitive information in multiple places isn't the best idea.

debian-sys-maint is a dedicated user for local server administration and it do
have all the rights necessary for that task.
In fact, I have a set of scripts to automate the diagnostics and they all are
wrappers around

  <mysql command> --defaults-extra-file=/etc/mysql/debian.cnf "$@"

Like
/usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf --batch -e "SHOW PROCESSLIST; SHOW ENGINE INNODB STATUS;" --raw 2> /dev/null


-- 
With best regards,
Andrey Repin
Monday, May 11, 2015 00:03:13

Sorry for my terrible english...