UCSC MySQL access
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
• 2,025 views
•
link
updated
by
Luis Nassar
•
written
by
noodle
•
written
by
noodle
1 answer
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:
- 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)
- 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 genome@soe.ucsc.edu. You may also send questions to genome-www@soe.ucsc.edu 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.
• 0 views
•
link
written
by
Luis Nassar
Log in to answer this question.
Works for me via
conda/mysql.Turns out my network updated some security stuff which blocked access, so the problem was identified!!!