I'm sure this is a MySQL problem, but I'm trying to use the DBI module to access a MySQL DB. The only other time I've done this is on a web DB provided by my provider. Anyways, I'm getting the following when trying to access it.
connect('database=router:host=localhost','root',...) failed: Access de
+nied for user: 'root@localhost' (Using password: YES)
And yeah -- the password is set right. What am I missing?
This is how I'm connecting
my $dbh = DBI->connect("DBI:mysql:database=dbname:host=localhost","roo
+t","password", {'RaiseError' => 1 });