At 19:05 -0500 1/19/03, Mark Riehl wrote:
All - Using MySQL under Linux. I'd like to create a new database using the
DBI.
I thought I could connect to the test database, create the new database,
assign
grants, then reconnect to the new database.
I'm trying to connect to the test database without a username or password
and I'm
getting an error: Access denied for user user@hostname. I'm trying to use
the
following connect call:
$database = "test";
$databaseString = "DBI:mysql:$database:$ip:$port";
$dbh = DBI->connect($databaseString, "", "");
or die "...";
Any suggestions?
Seems pretty clear. Your server (sensibly) doesn't allow anonymous
connections.
Use an explicit username and password.
Thanks,
Mark