Good point! I forgot to add db in my example too.
-Galt
On Fri, 28 Aug 2009, Michael Pheasant wrote:
Try specifying the database you want for example:
mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A hg18
Dont know what database you want though; hg19, mm9, etc
M
On Fri, Aug 28, 2009 at 7:19 AM, GEORGE LOCKE<[email protected]> wrote:
Hi,
I'm a grad student at Rutgers trying to get access to data from the genome
browser mysql database. I'm doing research in nucleosome positioning with
Prof. Alex Morozov.
i logged on as suggested, mysql --user=genome
--host=genome-mysql.cse.ucsc.edu -A
this is the query I wish to execute:
select chrom, chromStart, chromEnd, score, strand from
nucleosomeFragmentsSense into outfile "dump.txt";
(using database ce4)
this is the error i get: ERROR 1045 (28000): Access denied for user
'genome'@'%' (using password: NO)
what can I do? I can't find this information in text format anywhere and
hoped I could just get it direct from the database but have been rebuffed.
Regards,
George
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
--
Michael Pheasant
Associate Project Scientist
UCSC Genome Browser
Email: [email protected]
Skype: mpheasant
Phone: +1-831-459-1424
Location: Engineering2 Room 515
Post: CBSE, UC Santa Cruz, MS:CBSE/ITI
1156 High Street
Santa Cruz, CA 95064, USA
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
