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).

____________________ '---''(_/--' `-'\_) ___________________________