01-17-2006
Connecting MySql throug Perl Script ?
Dear Friends,
I am tryin to connect to the myql through perl scrip. I have already installed mysql and DBI modules to my Perl.
There versions are as follows,
DBD-mysql [2.1026] MySQL driver for the Perl5 Database
DBI [1.34] Database independent interface for
It gives erroe when I tried to connected to the sql. The error as follows,
Mysql connect('database=pps_cdr;host=localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at db_test.pl line 7
My perl script as follows,
use Mysql;
my $DBHOST = "localhost";
my $DBNAME = "pps_cdr";
my $DBUSER = "root";
my $DBPASS = "mahesh";
$DB = Mysql->connect($DBHOST, $DBNAME, $DBUSER, $DBPASS);
Can somebody tell me how can I avoid this error.
Thanks,
Mahesh Fernando
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :
Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies
2. Shell Programming and Scripting
Hi,
I am doing a migration of Oracle database to SQLSERVER 2005.Mostly my application code is perl scripts and i want to modify the scripts so as to connect to SQLSERVER.
What all would be the changes i have to make for just establishing a connection from Perl script to SQLSERVER... (3 Replies)
Discussion started by: DILEEP410
3 Replies
3. Shell Programming and Scripting
hi expert,
I am totally new to perl CGI coding. And stop by below issue:
1> i have a script names conn.pl, which can connect to mysql and get the information of table user(id,name)
2> i copied above code into one CGI web page named user.cgi
3> when i view user.cgi in web browser, it toldme... (3 Replies)
Discussion started by: summer_cherry
3 Replies
4. Shell Programming and Scripting
Hi.
I was testing some staff and wrote simple script, which only writes date to log every 15 seconds.
Like that
#1.sh
while true;do
echo `date` >> 1.log
sleep 15
done
And than i ran this process with `at -s -f 1.sh now`. And now it is running and i don't know how to catch it.
I tryed... (1 Reply)
Discussion started by: kukuruku
1 Replies
5. UNIX and Linux Applications
Hi,
I have MySQL 5.1.34 installed on Solaris and Linux machine.
MySQl installed Solaris Machine - A.A.A.A
Remote Machine - B.B.B.B
I have user in mysql.user as below:
| user | password | host |... (2 Replies)
Discussion started by: amit_27
2 Replies
6. Shell Programming and Scripting
I'm having trouble with this code.
if i do
.\read.pl -u user
it prints out
2010-12-20 12:00:00 host1 <cmd>a
2010-12-20 12:00:01 host1 <cmd> <execute>
2010-12-20 12:00:02 host1 <cmd>b
2010-12-20 12:00:03 host1 <cmd>c
however, if i enter
.\read.pl -h host1
it should... (3 Replies)
Discussion started by: kpddong
3 Replies
7. Shell Programming and Scripting
Hi, im trying to make a script that backups mysql databases but apparently I am having trouble with the variables, or simply something I am missing.
Would appreciate any help, here is the script
#!/usr/bin/perl -w
use strict;
require File::Spec;
#VARIABLES
my $databasename =... (4 Replies)
Discussion started by: Fireline
4 Replies
8. Programming
Hello;
I was trying to set up a mysql database using following script, but never went through. The code seems fine without any syntax error as I tested it:
perl -c Brapa0101-db.pl
Brapa0101-db.pl syntax OKHowever, whenever I run it, an error message was tossed out:
DBD::mysql::st execute... (7 Replies)
Discussion started by: yifangt
7 Replies
9. UNIX and Linux Applications
Hello,
Met a problem when I tried to insert rows to MySQL database from an old book that fits my learning level (MySQL and Perl for the Web, by Paul DuBois, 2001). First, under mysql console I created a database: webdb and the table: todo. Then I draft the perl-cgi script to have online page.... (0 Replies)
Discussion started by: yifangt
0 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::mysql
DBIx::Class::Storage::DBI::mysql(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::mysql(3)
NAME
DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics
SYNOPSIS
Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class.
my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );
DESCRIPTION
This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments
the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the
relationship attributes
It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far
as the SQL standard is concerned.
STORAGE OPTIONS
set_strict_mode
Enables session-wide strict options upon connecting. Equivalent to:
->connect ( ... , {
on_connect_do => [
q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
q|SET SQL_AUTO_IS_NULL = 0|,
]
});
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2014-01-22 DBIx::Class::Storage::DBI::mysql(3)