[SOLVED]: mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost'

I would like to execute mysqldump using .mylogin.cnf file and --login-path option to make it more secure as it can be with plain text password. It appears the error
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) when trying connect.
It was really strange because I have never created any ODBC user.


The solution: you have to export MYSQL_TEST_LOGIN_FILE variable and point to correct CNF file, e.g.
SET MYSQL_TEST_LOGIN_FILE=C:\secret\.mylogin.cnf
 - or -
export MYSQL_TEST_LOGIN_FILE=/var/mysql/.mylogin.cnf

Don't forget to restrict access permission to the file!

Enjoy!

OTRS: add new statistics takes too long

Does it take an enternity to create new statistics in OTRS?
Check an option CustomerIDAsMultiSelect in SysConfig and set it to No,
You can't select mutiple customers anymore, try to revert the option back and edit existing report.

Enjoy!

HOWTO: Repair Logitech M325 Mouse

FixIt says that you will find single screw under CE label. It isn't always true.