make a new mysql database
Posted in MySQL on September 26th, 2010 No Comments »
log onto mysql: $ mysql -u root create the database: mysql> create database foo; grant access privileges: mysql> grant all privileges on foo.* to user@localhost;
Posted in MySQL on September 26th, 2010 No Comments »
log onto mysql: $ mysql -u root create the database: mysql> create database foo; grant access privileges: mysql> grant all privileges on foo.* to user@localhost;
Posted in MySQL on October 1st, 2008 2 Comments »
let’s say your mysql user doesn’t have write access to your machine and using the INTO OUTFILE syntax is throwing errors: ERROR 1045 (28000): Access denied for user you can get around these problems by submitting your mysql query directly from the command line and piping the output to a text file like so: >> […]
Posted in MySQL on October 1st, 2008 No Comments »
to output the rows from two tables, indexed according to a column shared in common by the tables: SELECT table1.col1, table2.col2, FROM table1 LEFT JOIN table2 ON table1.col3 = table2.col3
Posted in MySQL on February 10th, 2006 No Comments »
i noticed that if you run adobe version cue 2, the mysql daemon automatically starts upon boot up of OS X. regardless, i’ve been having trouble starting mysql. i finally got things working by first killing the adobe-initiated mysqld. then, i followed the instructions laid out on marc liyanage’s site: Why do I get the […]
Posted in Matlab, MySQL on February 10th, 2006 20 Comments »
i’ve been working on a gene identification / network modeling experiment for a couple of weeks now. i have tons of processed microarray data that now needs to be examined as well as further annotated by hand. since all the data has already been processed, a spreadsheeting package is unncessary; what i really need is […]