make test errors for cpan install DBD::mysql

We managed to truly FUBAR our Perl installation a couple of weekends ago.
(don't ask).
I got it back (and upgraded to 5.8.5) but lost the MySQL access (probably
among other things).

So, I reinstalled DBD::mysql from CPAN. The build had no problems but I'm a
cautious sort and I like to run "make test". Tis did not go well:

Running make test
PERL_DL_NONLAZY=1 /ad4/ENV/freebsd-ELF/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok                                                       
t/10dsnlist........DBI connect('test','',...) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
        Either your server is not up and running or you have no
        permissions for acessing the DSN DBI:mysql:test.
        This test requires a running server and write permissions.
        Please make sure your server is running and you have
        permissions, then retry.
t/10dsnlist........dubious                                                  
        Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-9
        Failed 9/9 tests, 0.00% okay
[...more of the same till I kill it ...]

This confuses me greatly because I _do_ have MySQL installed and running and
my notes from when I installed it don't say anything about root@localhost.

I've got MySQL 3.23.55 running under FreeBSD 4.7. A friend suggested I just
make force install and move on so I did and things appear to work (although
not running the tests makes me a bit nervous).

ps aux | grep mysql
mysql    289  0.0  0.4 27484 4152 con- S    Tue07PM   0:12.97
/usr/local/libexe
vlb@cfcl [~] 147: mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show DATABASES
    -> ;
+---------------+
| Database      |
+---------------+
| genomatik     |
| mambo_cfcl    |
| midgard       |
| mt_heatercats |
| mysql         |
| tasks         |
| test          |
+---------------+
7 rows in set (0.10 sec)



Now I am planning to upgrade MySQL to 4.1.7 and the upgrade notes advise me to 
	Ensure that I don't have any MySQL clients that use shared libraries
	 (like the Perl DBD::mysql module).
Well, I do...
	If you do, you should recompile them,...
Ok. But then I will likely run into the test confusion again.

What magic incantations should I run through MySQL to get access for user:
'root@localhost' (Using password: NO). Or whatever it is I need to do. Burn
incense. Pour a little wine on the ground... my gods don't require nasty
things done to small furry mammals...


(If you can help I'd dearly appreciate a cc: as I get the digest form of this
list).
-- 
Vicki Brown     ZZZ                Journeyman Sourceror:
SF Bay Area, CA    zz  |\     _,,,---,,_      Scripts & Philtres
http://www.cfcl.com zz /,`.-'`'    -.  ;-;;,_Code, Doc, Process, QA
http://cfcl.com/vlb   |,4-  ) )-,_. ,\ ( `'-'Perl, Unix, Mac OS X, WWW
____________________ '---''(_/--'  `-'\_)  ___________________________

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]