nathan wainwright wrote:
> Does anyone have a clue what it needs to actually install DBD::Mysql
> through perl -MCPAN -e shell.
>
> t/10dsnlist.........DBI connect('test','',...) failed: Access denied for
> user: '
> [EMAIL PROTECTED]' (Using password: NO) at t/10dsnlist.t line 45
> Cannot connect: Access denied for user: '[EMAIL PROTECTED]' (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.
note: all references to the root user refer to the mysql root user, not
the OS root user.
you need to configure mysql to accept [EMAIL PROTECTED] w/o requiring a
password. to do this, temporarily remove root's password.
mysqladmin -u root -p password ''
this will prompt you for root's current password. now when the dbd::mysql
tests run, they should be able to log in as root w/o a password. when
you're done, reset the password back by running:
mysqladmin -u root password 'my.original.pass'
this time you shouldn't need to enter a password because you disabled it
with the first command.
Dave