MySQL

Create a user and grant permission in mysql

http://www.cyberciti.biz/faq/mysql-user-creation/

mysql -u root -p
CREATE DATABASE demo;
GRANT ALL ON demo.* TO guest@localhost IDENTIFIED BY 'guest123';

Create a database 'demo' and a table 'employee'

http://www.thegeekstuff.com/2011/10/mysql-tutorial-basics/

mysql -u guest -p demo
show databases;
use demo;
show tables;
create table employee .............;
desc employee;
insert into employee .............;
select * from employee;

Access mysql using perl

http://www.cyberciti.biz/faq/how-to-access-mysql-database-using-perl