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.
-
Question Say that I have LINQ query such as: var authors = from x in authorsList where x.firstname == "Bob" ...
-
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... -
You can use the generic_ stubs from notepad++ source, but you may prefer the "fully portable" _TCHAR macros. These macros are all ...
No comments:
Post a Comment