mysql/DBI install

• Complete mysql documentation at mysql.com
• Mysql tuturial at mysql.com
• Joel's SQL examples page

 perl -MCPAN -e "shell"

 sudo /usr/local/mysql/bin/mysqld_safe &

• To start the mysql interactive shell, type "mysql" from a command-line prompt. You might have to give the full path to the executable (for example "c:/mysql/bin/mysql") or change directory into that directory before running the command. Note you will need to also pass a username and password, if you've already password-protected your database. That command looks something like this:
  

   mysql -uUSERNAME -pPASSWORD
  

  
  Then you can run raw SQL statements against your databases.


• Follow the instructions on this page to remove the anonymous accounts and change the root passwords. Follow the directions in the sections marked "Anonymous Account Removal" and "root Account Password Assignment".


• Follow the instructions on this page to create a readonly and a read/write user for your database. It will look something like this (with your passwords where it says PASSWORD):
  

  mysql> grant select, insert, update, delete, create, drop on *.* to 'joelg_w'@'localhost' identified by 'PASSWORD'; 
  mysql> grant select, insert, update, delete, create, drop on *.* to 'joelg_w'@'%' identified by 'PASSWORD'; 
  mysql> grant select on *.* to 'joelg_r'@'localhost' identified by 'PASSWORD'; 
  mysql> grant select on *.* to 'joelg_r'@'%' identified by 'PASSWORD'; 
  

  
  Now you have a readonly and a read/write user. You should use these when connecting to your database from perl scripts.