Help : How To Connect To Genome-Mysql.Cse.Ucsc.Edu.

I have a simple question for mysql. I am not sure where I should paste the command below.

UCSC suggest to connect to the MySQL server using the command:

mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A

My results:

mysql>mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual.....

How to connect to genome-mysql.cse.ucsc.edu. by mysql workbench correctly? Thanks

mysql ucsc encode

• 6,218 views • link

updated 3.8 years ago by Ram

• written 12.7 years ago by zhaolin20042008 •

Hi all,

I tried the following command:

$ mysql --user=genome --host=genome-mysql.cse.ucsc.edu

What I got was this:

ERROR 2003 (HY000): Can't connect to MySQL server on 'genome-mysql.cse.ucsc.edu' (110)

Any idea what is wrong here?

Thanks in advance.

• 0 views • link

updated 3.8 years ago by Ram

• written 11.0 years ago by wanziyi89 •

1 answer

mysql>mysql --

shows that you are trying to run the mysql client program inside another mysql client program! Just exit mysql and from the SHELL (sh, bash,...) re-type your command:

$ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A

• 568 views • link

updated 3.8 years ago by Ram

• written 12.7 years ago by Pierre Lindenbaum

I tried it in cmd (windows) under mysql bin directory, it works. Thank you.

• 0 views • link

written 12.7 years ago by zhaolin20042008 •

More posts like this

UCSC MySQL access
written 5.6 years ago by noodle

Anyone know if the public can still access UCSC db remotely? Can't seem to get access :/ https://genome.ucsc.edu/goldenPath/help/mysql.html XXX@XXX-MacBook-Pro:~$ mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A -P 3306 …
Query a public sql server from within python
written 6.0 years ago by Eliran Turgeman •

I'm trying to query a public sql server from within a python script. The equivalent terminal command is : mysql --user=genome -N --host=genome-mysql.cse.ucsc.edu -A -D …
How do I get ensembl genome sizes with mysql?
written 7.4 years ago by endrebak

To get genome sizes from UCSC I just use the following code: import MySQLdb def ucsc(genome, query): host = "genome-mysql.cse.ucsc.edu" user = "genome" db = …
Problem for adding foreign key
written 8.7 years ago by sharmatina189059 •

Deal all Can anyone tell me the problem with this command. mysql> ALTER TABLE Biocyc_2 ADD CONSTRAINT fk_col FOREIGN KEY (User_ids) REFERENCES Unique_reaction (User_ids) on …
Using Terminal to Connect to Ensembl public MySQL Servers
written 8.9 years ago by oars

For starters, I have mySQL downloaded. I'm trying to drop into an interactive mysql session by typing in the following: $ mysql --user=anonymous --host=ensembldb.ensembl.org I've …
Extracting Bidirectional promoters from UCSC mysql server gives error....
written 9.3 years ago by AA Kamran •

I tried to extract the bidirectional promoters using the syntax below- $ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -D hg19 mysql> select K1.chrom,K1.name,K2.name,K1.strand,K2.strand, LEAST(K1.txStart,K1.txEnd,K2.txStart,K2.txEnd) as L, GREATEST(K1.txStart,K1.txEnd,K2.txStart,K2.txEnd) …
mysql through proxy
written 10.5 years ago by julien.fouret.fr •

Hi Does anyone know how to use mysql through a proxy to contact ucsc db : jfouret@illumina-03:~$ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A ERROR 2003 (HY000): Can't …
query using mysql on ucsc table browser
written 10.6 years ago by bioguy24

I have a folder of 57 text files each with 1000 locations in them. I was going to use the mySQL browser at mysql --user=genome …
Accessing UCSC mysql DB: ERROR 1045 (28000): Access denied for user 'genome'
written 10.7 years ago by kynnjo •

This is a follow-up to an earlier question of mine. I tried the following command (copied verbatim from [UCSC's mysql access docs][1]): mysql --user=genome --host=genome-mysql.cse.ucsc.edu …
get biotype for refseq NM transcripts
written 11.1 years ago by Pablo Marin-Garcia

I would like to have the biotypes (like in ensembl transcripts) but for the NCBI refSeq downloaded from UCSC mysql. Which table should I join …