To test mysql remote server access using perl

rajeshkumar created the topic: Useful info on Perl defined Function Very good url for the following topis… How to use Perl defined function with scalars How to use Perl defined function with an array How to use Perl defined function with a hash How to use Perl defined function with www.misc-perl-info.com/perl-defined.html Regards, Rajesh Kumar Twitt…

scmuser created the topic: Why do you program in Perl? Why do you program in Perl? What are the advantages of Perl ovber python and other languages? Rajesh KumarI’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark,…

scmuser created the topic: Why we use ‘use strict’ in perl Hi, Why you should ‘use strict’? what is the significant of “strict” in out module? rajeshkumar replied the topic: Re: Why we use ‘use strict’ in perl Whenever your program gets over a few lines long, definitely when you can’t view the whole program…

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)…