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:

c:
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


Subject
Views
Written By
Posted
1045 Access denied ODBC@localhost using Windows Task Scheduler
114
May 24, 2017 01:29PM


Sorry, only registered users may post in this forum.

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.