mysql connection problems

**otterlake** · 03-16-2011, 02:02 AM

#!/usr/bin/perl
#
#
use lib "/home/otterlak/public_html/cgi-bin/olscmod";

use olsc;
use DBI;
use DBD::mysql;

my $platform = "mysql";
my $database = "";
my $host = "otterlakesc.org";
my $port = "3306";
my $user = "";
my $pw = "";

#DATA SOURCE NAME
my $dsn = "dbi:mysql:$database:$host:$port";

print "content-type:text/html\n\n";
print "<html>\n";
print "<head>\n";
print "<title>Hello World</title>\n";
print "</head>\n";
print "<body>\n";
print "<b>Hello World!</b><br>\n";

my $dbh = DBI->connect($dsn, $user, $pw) or print "Unable to connect: $DBI::errstr\n";

# the line above produces the following error message
# Unable to connect: Access denied for user blah blah blah
# I am positve that my user name, password, and database name are correct!

print "</body>\n";
print "</html>\n";

Any ideas?

**otterlake** · 03-16-2011, 08:42 AM

Finally got it .... the host was supposed to be localhost not otterlakesc.org.

**sonia2012** · 03-18-2011, 01:01 AM

host should be localhost.
fill in the database from your databaseName.

Thread: mysql connection problems

Thread Tools

Display

mysql connection problems

Similar Threads

Help with remote connection to MySQL

Website connection Problems

php mysql connection from different sites(hosts)

MySQL connection information

Posting Permissions