Category: "mySQL"

mySQL User Permissions

May 28th, 2008
Give the user some rights to mySQL database tables Syntax: mysql> GRANT select,insert,update,delete on firstdb.* to 'firstuser'@'%' identified by 'passwd'; Important Privileges: ALTER Modify tables with ALTER TABLE CREATE Make new database, table, or… more »

R programming (intro level)

March 27th, 2008
Some notes on basic programming using the statistical language/environment R Getting data from a mySQL database library(RMySQL) mycon <- dbConnect(MySQL(), user='cws', dbname="cws", host="pi", password='delores') rs <- dbSendQuery(mycon, "SE… more »

EnsEMBL db Installation

January 14th, 2008
A few notes about setting up a local EnsEMBL system (database and API) more »