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

Question

[zhaolin20042008]

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

[wanziyi89]

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.

Answer 1

[Pierre Lindenbaum]

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

[zhaolin20042008]

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