From: John Bonnett
Date: October 28 2013 11:25am
Subject: RE: Data management system connection
List-Archive: http://lists.mysql.com/myodbc/11781
Message-Id: <0F231A06CA35674FAB1E114AEE8D5E647C4791B8C0@sgsi6sexh01>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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: john.bonnett@stripped
Web: www.vision.zeiss.com
-----Original Message-----
From: Elena Cantoni [mailto:e.cantoni@stripped]=20
Sent: Friday, 25 October 2013 10:52 PM
To: myodbc@stripped
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