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!
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!
Subscribe to:
Posts (Atom)
HOWTO: Repair Logitech M325 Mouse
FixIt says that you will find single screw under CE label. It isn't always true.
-
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 passwo...
-
If your worry about data left on dedicated/hosted root server and want to remove secure all files and bits, you can clean complete disk sli... -
OUT - OF - DATE Obsolete. Please check new post ! If you have issue with Function List plugin for Notepad++ 5.1 or later, please ch...