Database credentials issue

We are having an issue with a MYSQL database issue.  We created a front end in MS access that interfaces with a MYSQL data base.  The access tool works on multiple PCs throughout the organization except for a couple. When Installed on specific laptops the database kick back a credentials error that says: "Login Failures for the entered credentials.  (1 of 3 tries)"

We have installed the database on other computers and she can log in with those same credentials that kick back the error on her laptop so we don't beleive there is an issue with end users credentials in MySQL workbench.

"Login Failures for the entered credentials.  (1 of 3 tries)"
Eric JonesIT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Access front end glued on top of MySQL... shudder...

If you're getting login failures on some machines, likely either the user/pass is truly failing...

Or more likely, your GRANT is to specific, so it's covering individual IPs, rather than an IP range.

Check your MySQL GRANTs first. You'll check this via running the mysql command line tool on failing machines.

A simple command like the following will surface GRANT problems...

mysql -h$host -u$user -p$pass -Bse "SHOW TABLES" $dbname

Open in new window

If this works on some hosts + fails on some hosts, then likely your GRANT requires being loosen (from individual IPs to IP ranges).
Dale FyeOwner, Dev-Soln LLCCommented:
I've never used  mySQL, but the first thing I would look at is whether you have the appropriate ODBC driver installed on those computers that do not work. That is generally the reason that connections to the BE do not work when users have a SQL Server backend and have a connection string which refers to a driver which is not installed on the individuals computer.

Eric JonesIT ManagerAuthor Commented:
I double checked all the ODBC settings and drivers and I am still having the same issues.
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also be sure that your Access FE is set as a Trusted Location on the user's machine.
Eric JonesIT ManagerAuthor Commented:
I double checked the trusted location and it did not fix my issue.  I added the desktop as a trusted location and I also tried to move the database into another trusted folder and it did NOT fix my issue
Create a new, empty Access DB.  Try to link the tables.  Does that work?  If it does, you will know that your ODBC driver is correct.

Is there something different about the path to the MySQL database from the machines that don't work vs the ones that do work?

Access front end glued on top of MySQL... shudder...
Access is intended to work as a FE with ANY ODBC compliant RDBMS.  Why do you think there is a problem with using Access for MYSQL?
Gustav BrockCIOCommented:
I recall an old issue related to encryption of the password for old accounts.
The solution was to reset the password to the 4.1 authentication style:

set password for 'oldpassuser'@'localhost' = password( '123' )

Open in new window

Perhaps a shot in the dark, but simple to test.
Eric JonesIT ManagerAuthor Commented:
We figured it out.  It had to do with 32 bit ODBC vs 64 bit ODBC and corresponding to the version of access they had installed

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.