current version of transcript using mysql

Question

[bioguy24]

I am trying to get the current version of a transcript using the below:

mysql hg19 -NBe 'select CONCAT(refseq, ".", version), kgId from kgXref, gbCdnaInfo where gbCdnaInfo.acc=kgXref.refseq' > refseqToUcscId
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

What am I doing wrong or is this the best way? Thank you :).

[GenoMax]

See if anything here helps: http://dba.stackexchange.com/questions/98467/how-to-solve-cant-connect-to-local-mysql-server-through-socket-error

[Pierre Lindenbaum]

are you trying to reach the UCSC mysql server ? you must add host/user/etc...

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