MySQL Forums
Forum List  »  Connector/ODBC

Re: Access loses its connection/authentication to the MySQL database (randomly requests username password)
Posted by: Bogdan Degtyariov
Date: April 23, 2018 04:24AM

Hi Tom,

The password prompt usually pops up when the client is unable to authenticate with the current combination of user/host/password.
You can also check in the ODBC Administrator if the DSN is valid and the "test" button gives success from the first attempt. Note that the password has to be filled-in already. If the password is empty in the input it means that most likely you will be prompted for it next time.

If the connection is made using the connection string instead of a pre-defined DSN check that the password option is set as "PWD=<password>" or "PASSWORD=<password>"

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.