UCSC MySQL access

Question

[joe]

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
ERROR 2002 (HY000): Can't connect to MySQL server on 'genome-mysql.soe.ucsc.edu' (36)
XXX@XXX-MacBook-Pro:~$ mariadb --version
mariadb  Ver 15.1 Distrib 10.5.8-MariaDB, for osx10.15 (x86_64) using readline 5.1

[GenoMax]

Works for me via conda/mysql.

[joe]

Turns out my network updated some security stuff which blocked access, so the problem was identified!!!

Answer 1

[Luis Nassar]

Hello,

Glad to hear you were able to gain access. Our public MySQL servers are (essentially) always online. I'll take the opportunity for two plugs:

1. We also have a public MySQL server (https://genome.ucsc.edu/goldenPath/help/mysql.html) hosted in Germany which can provide faster access for European and other nearby users (--host=genome-euro-mysql.soe.ucsc.edu)
2. We have our RESTful API (https://genome.ucsc.edu/goldenPath/help/api.html) which has access to all the data available on MySQL, as well as all binary indexed files (so bigBeds, bigWigs, etc.)

If you have any follow up questions, our public help desk can always be reached at [e-mail]. You may also send questions to [e-mail] if they contain sensitive data. For any Genome Browser questions on Biostars, the UCSC tag is the best way to ensure visibility by the team.