List:MySQL ODBC« Previous MessageNext Message »
From:John Bonnett Date:October 28 2013 11:25am
Subject:RE: Data management system connection
View as plain text  
The things to check are:

When you try to connect you are using a particular user name. Is that user name defined in
the database?
The user has a password. Are you giving the correct password?
In the GRANT statement that gives the user permission to connect it also specifies what
hosts you can connect from, maybe a specific one, maybe some wildcard expression for the
host name/IP or perhaps a wildcard of '%' which allows any host. Is the host you are
trying to connect from allowed for this user?

I think that is all.

I am not sure if spaces in the user name are a good idea either.

This is covered in the manual.


Carl Zeiss Vision Australia (Asia Pacific)
Calculation Services
Software Engineer

J o h n   B o n n e t t

Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
Email: john.bonnett@stripped

-----Original Message-----
From: Elena Cantoni [mailto:e.cantoni@stripped] 
Sent: Friday, 25 October 2013 10:52 PM
To: myodbc@stripped
Subject: Data management system connection

Good morning, 

I am trying to connect a Data Management System application of our creation to a certain
data archive via MySQL ODBC Connector and, when launching the application, I get the
following error: 

"[MySQL][ODBC 5.1 Driver]Access denied for user 'DMS User'@'localhost'
(using password: YES)". 

What am I missing? 

The installation of MySQL apparently gave no problems, and this situation occurs just on
some machines (typically those with a 64bit OS). 

Could it be a problem at a "system level", about how this connection is attempted? 

Thanks in advance! 


Data management system connectionElena Cantoni28 Oct
  • RE: Data management system connectionJohn Bonnett28 Oct