How to configure the user and password for MySQL

[Roberto]

Hi

I have an Access FrontEnd with linked tables conected to a MySQL BackEnd
with ODBC. Everything works ok, however the user must enter a username and
password every time she/he open to the FrontEnd, typing the user and password
for the MYSQL DataBase.

How do i can to especify the user and password to avoid that?

 

[Larry Linson]

Hi

I have an Access FrontEnd with linked tables conected to a MySQL BackEnd
with ODBC. Everything works ok, however the user must enter a username and
password every time she/he open to the FrontEnd, typing the user and
password
for the MYSQL DataBase.

How do i can to especify the user and password to avoid that?

The MySQL documentation ought to specify how to programattically provide a
userid and password, or you might get an answer in a newsgroup or forum that
supports MySQL. If you are lucky, someone here will have the experience to
answer you, but would just be a matter of luck. When I have worked on Access
clients to server databases, it was usual that the clients _wanted_ people,
as a security measure, to sign in because they thought the server security
was a good safeguard.

I remember developing an Access client for the Informix DBA at one customer
shop to automate his maintenance of userid and password information. He
thought Informix had good security but a klunky adminstrative interface (at
that time...ten or more years ago).

Larry Linson
Microsoft Office Access

 

[David W. Fenton]

The MySQL documentation ought to specify how to programattically
provide a userid and password, or you might get an answer in a
newsgroup or forum that supports MySQL.

My guess is that you'd have to recreate the table links at runtime,
i.e., prompt the user for username and password, and then create the
links with the responses embedded within them, and delete them when
the app closes.

But I'm only guessing.