The things to check are:
When you try to connect you are using a particular user name. Is that user name defined in
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)
J o h n B o n n e t t
Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
From: Elena Cantoni [mailto:e.cantoni@stripped]
Sent: Friday, 25 October 2013 10:52 PM
Subject: Data management system connection
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
"[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!