MySQL Forums
Forum List  »  MySQL Workbench

1045 Access denied ODBC@localhost using Windows Task Scheduler
Posted by: Dick Vandenberg
Date: May 24, 2017 01:29PM

I created a batch file:

cd '\export data'

set cmd="C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql"

%cmd% --login-path=import dbexport -v -v <importalltables.sql >import_results.log 2>import_err.log
The login-path is set up correctly. This batch file works when I am logged into the server. When I schedule a Windows task to execute it and give it my userid and password in the task, it issues the error message 'ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)' and dies.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.