Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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

by traincity (Sexton)
on Jan 03, 2021 at 21:39 UTC ( #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!

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.

Re^3: DBI::db error I am confused!
by Bod (Chaplain) 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);
    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.

Re^3: DBI::db error I am confused!
by Bod (Chaplain) 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???

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11126240]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2021-04-21 22:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?