, 2005 3:52 PM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Try something like this:
use DBI;
my $driver = mysql;
my $server = myhost;
my $database = mydb;
my $url = DBI:$driver:$database:$server;
my $user = username;
my $pass = password;
my
, and
you should be ready to go.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Gerald Preston
Sent: Thursday, January 06, 2005 5:25 AM
To: 'Tom Crimmins'
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Tom,
I tried the following
: first time accessing
[snip]
DBI connect'test:GJWPP88','Jerry' failed: Access denied for user
'Jerry'@'gjwpp88' using password: yes at line 17
[/snip]
I would try your connection from a command line ie. 'mysql -u Jerry -h
GJWPP88 -p'.
The problem is now not with your perl, it is your mysql
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 3:08 PM
To: 'Tom Crimmins'
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Tom,
I still get access denied. I just reinstall the latest version yesterday.
What are my options now
Tom,
I am still getting access denied when I try ',mysql -u root'.
Jerry
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:24 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
If you are using a fresh
Tom,
I am running 'WinMySQLadmin 4.1. Can I use this tool to change anything?
Jerry
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:24 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
If you
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DBI-connect( 'dbi:MySQL, 'user', 'pass' ) or die Cannot connect
- !br$DBI::errstr;
and I get the following error:
Can't connect to data source dbi:MySQL, no data driver
: . DBI-errstr;
Obviously you don't have to make everything a variable, this is just one
possibility.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Gerald Preston
Sent: Monday, January 03, 2005 7:40 PM
To: mysql users
Subject: first time
: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 4 January 2005 12:10 PM
To: mysql users
Subject: first time accessing
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DBI-connect( 'dbi:MySQL, 'user', 'pass' ) or die Cannot