PDA

View Full Version : MySQL on Portland


Xyzzy
March 31st, 2001, 16:33
I uploaded this Perl script to my cgi-bin at Portland.co.uk:

#!/usr/bin/perl

use DBI;
use CGI qw/:standard/;

print header;
print "<html>Preparing request..";

my $db = DBI->connect('DBI:mysql:nes:localhost', 'username', 'secret');
if (!defined $db)
{
print "<p>Failed: $DBI::errstr\n</p>";
}
print "</html>";

When I run it, I get this output:

Preparing request..

Failed: Access denied for user: 'username@localhost' (Using password: YES)

I used the username and password I signed up with Portland with. Do I have to use a certain hostname? Portland's welcome e-mail didn't mention MySQL at all. Any help greatly appreciated.
Koolguy
March 31st, 2001, 17:51
Are you sure that MySQL was setup for your account correctly.
Xyzzy
March 31st, 2001, 21:12
Originally posted by Koolguy
Are you sure that MySQL was setup for your account correctly.
Nope. Does Portland even offer MySQL for free? Port5.com says "We can also offer: Mysql database space." Anyone know if it's free, or how to get it?
Dipstick
March 31st, 2001, 21:17
send an e-mail requesting it or log in and brows around the member part of their site or just go post this in there forum!!!!!!

[Edited by Dipstick on 03-31-2001 at 10:20 PM]
lucifer
April 1st, 2001, 10:10
MySQL has it's own user/password list this may be different than for the server logon.

make sure you have the correct one and as suggested make sure you have a MySQL account. I doubt they give one to everyone at signup as most people won't go near it