MySQL

1. Create a user and grant permission in mysql
2. 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';

1. create a database 'demo' and a table 'employee'
2. 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;

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