SOLUTION:
1. Install MySQL database. MySQL community server comes free of cost and is distributed under GNU General Public License.
2. I would instead recommend installing a package called WAMP server which provides MySQL community server, Apache server and PHP. It also provides many effective tools like PHPMyAdmin which can be used for database administration. Also WAMP server comes free of cost and is distributed under GNU General Public License.
3. To check if the MySQL server is running, execute:
telnet
E.G: # telnet 127.0.0.1 3306
4. I would also recommend you to also install SQLYog. It is a very light and effective tool to monitor and manage MySQL database. Again it also comes free of cost and is distributed under GNU General Public License.
5. Create a database in MySQL, a non-root user and give it a password.
6. Install ‘DBI’ perl module through ‘PPM’
7. Install ‘DBD::Mysqlpp” perl module through ‘PPM’
8. You are all set to connect to MySQL database. While connecting make sure that database is already created and you are connecting through a valid user and with correct credentials. To see a sample script execute following on command prompt:
# perldoc DBD::Mysqlpp
REFERENCES:
1. http://dbi.perl.org/
2. # perldoc DBD::Mysqlpp
AUTHOR: Parag Kalra
Email-ID: paragkalra@gmail.com
