{"id":2489,"date":"2017-12-08T11:37:20","date_gmt":"2017-12-08T11:37:20","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/?p=2489"},"modified":"2025-02-01T23:08:03","modified_gmt":"2025-02-01T23:08:03","slug":"connect-to-my-mysql-database-using-perl","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/connect-to-my-mysql-database-using-perl\/","title":{"rendered":"Connect to my MySQL database using Perl?"},"content":{"rendered":"

rajeshkumar created the topic: connect to my MySQL database using Perl?<\/strong><\/p>\n

#!\/usr\/bin\/perl
\nuse DBI;<\/p>\n

$database = “DBNAME”;
\n$hostname = “DBSERVER”;
\n$port = “3306”;
\n$username = “DBUSERNAME”;
\n$password = ‘DBPASSWORD’;<\/p>\n

$dsn = “DBI:mysql:database=$database;host=$hostname;port=$port”;<\/p>\n

$dbh = DBI->connect($dsn, $username, $password) or die(“Could not connect!”);<\/p>\n

$sql = “SELECT * FROM mytable”;<\/p>\n

$sth = $dbh->prepare($sql);
\n$sth->execute;<\/p>\n

while(($column1, $column2) = $sth->fetchrow_array)
\n{
\nprint “C1 = $column1, C2 = $column2n”;
\n}<\/p>\n

$dbh->disconnect;<\/p>\n

where DBNAME, DBUSERNAME, and DBPASSWORD are your database name, database username and database password, and where DBSERVER is your database server.<\/p>\n

Regards,
\nRajesh Kumar
\nTwitt me @ twitter.com\/RajeshKumarIn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

rajeshkumar created the topic: connect to my MySQL database using Perl? #!\/usr\/bin\/perl use DBI; $database = “DBNAME”; $hostname = “DBSERVER”; $port = “3306”; $username = “DBUSERNAME”; $password = ‘DBPASSWORD’; $dsn = “DBI:mysql:database=$database;host=$hostname;port=$port”; $dbh = DBI->connect($dsn, $username, $password) or die(“Could not connect!”); $sql = “SELECT * FROM mytable”; $sth = $dbh->prepare($sql); $sth->execute; while(($column1, $column2) = $sth->fetchrow_array)…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[14],"tags":[175],"class_list":["post-2489","post","type-post","status-publish","format-standard","hentry","category-perl","tag-perl"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=2489"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2489\/revisions"}],"predecessor-version":[{"id":2490,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2489\/revisions\/2490"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=2489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=2489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=2489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}