Re^2: DBI::db error I am confused!


We don't bite newbies here... much
	PerlMonks

Re^2: DBI::db error I am confused!

by traincity (Sexton)

on Jan 03, 2021 at 21:39 UTC ( [id://11126240]=note: print w/replies, xml )

Need Help??

in reply to Re: DBI::db error I am confused!
in thread DBI::db error I am confused!

Thank you... That is very helpful about the wrong db driver. The on-line running script is using mysql mariadb. I am using mysql workbench on the localhost. I doubt very much that it has anything to do with script or the data. Can anyone give me a hint how to change the driver? I have no idea. Thanks again!

Comment on Re^2: DBI::db error I am confused!

Replies are listed 'Best First'.
Re^3: DBI::db error I am confused! by stevieb (Canon) on Jan 03, 2021 at 21:49 UTC
You're just guessing. Show us the code as 1nickt suggested.	[reply]
Re^3: DBI::db error I am confused! by Bod (Parson) on Jan 03, 2021 at 21:50 UTC
Can anyone give me a hint how to change the driver? The driver is passed to `DBI` as the first part of the first parameter of the `connect` method: `use DBI; use DBD::mysql; my $dbh=DBI->connect("dbi:mysql:$database_schema:localhost:3306",$user +,$pass);` [download] This is connecting to MySQL which also works for MariaDB. Although there is a DBD::MariaDB but I haven't switched to using it yet.	[reply] [d/l] [select]
Re^3: DBI::db error I am confused! by Bod (Parson) on Jan 03, 2021 at 21:53 UTC
I am using mysql workbench on the localhost erm...you do know that MySQL Workbench isn't a database don't you???	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://11126240]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others browsing the Monastery: (3)

As of 2024-04-26 06:46 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found