RE: Data management system connection

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 sp=
ecifies what hosts you can connect from, maybe a specific one, maybe some w=
ildcard 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 thi=
s 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=A0=A0 B o n n e t t

Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
Email: [email protected]
Web: www.vision.zeiss.com

-----Original Message-----
From: Elena Cantoni [mailto:[email protected]]=20
Sent: Friday, 25 October 2013 10:52 PM
To: [email protected]
Subject: Data management system connection

Good morning,=20

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:=20

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

What am I missing?=20

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

Could it be a problem at a "system level", about how this connection is att=
empted?=20

Thanks in advance!=20

Elena


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc