installing perl on mysql on suse 9.3 - error because root user has password

I have set a password for the mysql root user so when I do this:

shell> perl -MCPAN -e shell
cpan> install DBI
cpan> install DBD::mysql
install DBD::mysql fails Is there a way I can run install DBD::mysql and
supply the password as a parameter - or get it to prompt me for it?
Otherwise anyone know how I can remove the password temporarily for the root
user in mysql?Angus

re: installing perl on mysql on suse 9.3 - error because root user has password

Angus Comber wrote:[color=blue]
> I have set a password for the mysql root user so when I do this:
>
> shell> perl -MCPAN -e shell
> cpan> install DBI
> cpan> install DBD::mysql
> install DBD::mysql fails Is there a way I can run install DBD::mysql and
> supply the password as a parameter - or get it to prompt me for it?[/color]

Yes, Makefile.PL for DBD::mysql has a flag called "--test-pass". Run
perl Makefile.PL --help for more information.

You'll probably not be able to use the automated "install DBD::mysql"
from the cpan shell. Run "look DBD::mysql" from the cpan shell, and
it'll open a shell for you in the local directory in which it tries to
build that module and run tests. Then you can run Makefile.PL yourself
and give it the optional arguments.

Regards,
Bill K.