Re: problems loading DBD::MySQL

Michael R Boudreau <[email protected]> Wed, 16 Dec 2009 09:03:40 -0600
Newsgroups gmane.comp.db.mysql.perl
Message-ID <C74E52EC.5562%[email protected]>
--_000_C74E52EC5562mboudreauchicagoedu_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Keith,

The "access denied" error message indicates that your script is successfull=
y contacting the MySQL server, but the user 'ODBC' doesn't have permission =
to connect without a password from whatever host your script is running on.


On 12/15/09 4:22 PM, "Keith Thomas" <[email protected]> wrote:

Hi

I keep running into the following error when attempting to load the DBD for
mysql:

C:\PROGRA~1\MySQL\MYSQLS~1.1\bin\MYSQLA~1.EXE: connect to server at
'localhost'
failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'

I originally tried to install through CPAN but kept getting 500 errors when
trying to connect (probably blocked by my company's IT), so I pulled the ta=
r
down and decompressed it to load it manually. I had no troubles getting DBI
to load. I am using MySQl 5.1.41 - the test DB and default accounts all
appear there correctly, and i have went as far as giiving the
ODBC@localhostaccount full permissions to the test DB and still get
the same error. Any
idea what I am missing?

Thanks

Keith Thomas


--
Michael R. Boudreau
Senior Publishing Technology Analyst
The University of Chicago Press
1427 E. 60th Street
Chicago, IL 60637
(773) 753-3298  fax: (773) 753-3383


--_000_C74E52EC5562mboudreauchicagoedu_--