MySQL Forums
Forum List  »  MySQL Workbench

Re: Where is the connection option for Windows Authentication
Posted by: Mike Lischke
Date: March 21, 2017 02:01AM

Edward, my understanding of this feature is that you have to provide a user name in any case. Maybe I'm misinterpreting the documentation for Windows Authentication. It only mentiones Active Directory as part of specifying a domain name with the user name:


Windows authentication always works for connections from the same computer on which the server is running. For cross-computer connections, both computers must be registered with Windows Active Directory. If they are in the same Windows domain, it is unnecessary to specify a domain name. It is also possible to permit connections from a different domain, as in this example:

CREATE USER sql_accounting
IDENTIFIED WITH authentication_windows
AS 'SomeDomain\\Accounting';

If you believe this is not the complete truth then create a bug report in our bug system, so that we can investigate what is missing.

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github:
On Twitter:
On Slack: (#workbench)
Report bugs to
MySQL documentation can be found here:

Options: ReplyQuote

Written By
Re: Where is the connection option for Windows Authentication
March 21, 2017 02:01AM

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.