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? Thanks, Mark