Dan wrote: > right, i've had a look into sql and everything, and kinda got to grasp > with how it works, i've written a trial script to see if it works, but it > keeps spewing an error: > > DBI->connect(mx:localhost:3306) failed: Access denied for user: > 'dan@localhost' (Using password: YES) at db.pl line 10 > Can't connect to the DB: Access denied for user: 'dan@localhost' (Using > password: YES) > > here's the script (real password omitted of course) (the password isn't > 'YES' either) > > __ START __ > #!/usr/bin/perl > > use strict; > use DBI; > > my $dsn = 'dbi:mysql:mx:localhost:3306'; > my $user = 'dan'; > my $pass = 'mypassword'; > > my $dbh = DBI->connect($dsn, $user, $pass) > or die "Can't connect to the DB: $DBI::errstr\n"; > __ END __ > > what's wrong?
i don't think that's really a Perl question. it looks like your mysql is not accepting the user 'dan' with password '<whatever>'. better check with your db admin first to run if the db is actaully up and running. if it's, then manually logon with 'dan' and '<whatever psw>' to see what happen. if everything works fine from your manually logon, try the script above again. david -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
