problems loading DBD::MySQL

--0016e68fd02ca76b4d047acbd4e8
Content-Type: text/plain; charset=ISO-8859-1

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 tar
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

--0016e68fd02ca76b4d047acbd4e8--

Re: problems loading DBD::MySQL

--_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" 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_--

Re: problems loading DBD::MySQL

--0016e6d27c7ff60d70047ade9c4d
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Ok so I "think" I have it loaded...
Here is what I did:
-unloaded mySQl 5.1.41 and loaded 5.0.88 (I read an article last night
saying that there might be a version issue...)
-created a user 'ODBC'@'localhost' in the test DB and gave it all privilege=
s
-pulled the DBD-mysql-4.013 package local (we have a fun firewall that wont
let me out using ppm)
-ran the makefile.pl as local admin
-tried to run nmake then had to go back and edit the makefile and swap lib=
s
- libmysql.lib for mysqlclient.lib
-nmake then ran successfully
-nmake test passed (barely) with it skipping 35 of 36 tests (I also dropped
my.ini in the win root - didn't make a diference on the test)
-ran nmake install which ran succesffully

my only question now is that when I go to the ppm repository and look, it
does not list DBD::mysql, but if I go to
the \Perl\site\lib\DBD\mysql I find a pod and pm file. Am I ok then?

Thanks

Keith
On Wed, Dec 16, 2009 at 7:03 AM, Michael R Boudreau <
mboudreau@press.uchicago.edu> wrote:

> Keith,
>
> The =93access denied=94 error message indicates that your script is
> successfully contacting the MySQL server, but the user =91ODBC=92 doesn=
=92t have
> permission to connect without a password from whatever host your script i=
s
> running on.
>
>
>
> On 12/15/09 4:22 PM, "Keith Thomas" wrote:
>
> Hi
>
> I keep running into the following error when attempting to load the DBD f=
or
> 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 wh=
en
> trying to connect (probably blocked by my company's IT), so I pulled the
> tar
> down and decompressed it to load it manually. I had no troubles getting D=
BI
> 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
>
>

--0016e6d27c7ff60d70047ade9c4d--