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!
Subscribe to:
Post Comments (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...
No comments:
Post a Comment