On Dec 15, 2004, at 2:29 PM, Lola Lee wrote:
Several tests failed because access was denied, for instance:
t/mysql2...........Mysql connect('database=test;host=','',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) at t/mysql2.t line 29
What else should I do to get this to run as should be?
The problem is that the self-tests are run by root, and root normally requires a password to connect to mysql.
You have two options: The simplest is to grant [EMAIL PROTECTED] full access to the "test" database, without requiring a password. In the mysql shell:
mysql> grant all privileges on test.* to '[EMAIL PROTECTED]';
Query OK, 0 rows affected (0.22 sec)The second option is more complicated. You can start the CPAN shell with 'perl -MCPAN -e shell', and use the 'look DBD::mysql' command from there. That will download and unzip the latest module source, and open up a sub-shell in the source directory. From there, you can run 'perl Makefile.PL' using any of the options listed in INSTALL.html.
For example, to specify the database, user name and password to use, you'd run 'Makefile.PL' like this:
perl Makefile.PL --testdb=test --testuser=somebody --testpassword=blah
sherm--
Cocoa programming in Perl: http://camelbones.sourceforge.net Hire me! My resume: http://www.dot-app.org
