MySQL Forums
Forum List  »  MySQL Workbench

Re: 1045 Access denied ODBC@localhost using Windows Task Scheduler
Posted by: Dick Vandenberg
Date: June 15, 2017 01:11PM

Yes, it is now working.

On the Windows scheduled task, I set the userid to domain user with a non-expiring password. On the MySQL command I used a --login-path with a user that is only localhost and has select, update, delete, and insert.

using secpol.msc as described here (https://www.smartftp.com/en-us/support/kb/2691), I added the domain user to the list with 'Log on as batch job' rights.

That's it. Of course, the domain user needed to be added to the network share on the server where the incoming data is and needed full rights to that directory as well, so it can rename, copy, and delete files as needed.

Good luck.

Options: ReplyQuote




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.