Select Code to Download

/Users/7stud/.cpan$ sudo chown -R 7stud .

$ otool -D `mdfind libmysqlclient.18.dylib`

$ sudo install_name_tool -id /usr/local/mysql-5.5.28-osx10.6-x86_64/li
+b/libmysqlclient.18.dylib
/usr/local/mysql-5.5.28-osx10.6-x86_64/lib/libmysqlclient.18.dylib

mysql> grant all privileges on test.* to '7stud'@'localhost' identifie
+d by 's3kr1t';

mysql> grant all privileges on test.* to 'root'@'localhost' identified
+ by 's3kr1t';

     $ cd /usr/local/mysql
     $ sudo ./bin/mysqld_safe
...
     $ cd /usr/local/mysql
     $ sudo mysqladmin shutdown

$ mysql -uroot -p
password: <just hit return>
...
..
...
mysql>

mysql> grant all privileges on test.* to '7stud'@'localhost' identifie
+d by 's3kr1t';

$ cpan DBD::mysql

$ perlbrew use perl-5.16.0

$ cpan -f -i DBD::mysql

$ perl -MCPAN -e shell
cpan> fforce install DBD::mysql

use strict; 
use warnings; 
...
while($query_handle->fetch()) {
   say "$id, $name, $info";
}

mysql> CREATE DATABASE my_db CHARACTER SET utf8
mysql> show databases;
...
#Only use the following if you want to delete data:
mysql> drop table people;
mysql> drop database my_db;