[Cod-bugs] cannot connect through mysql

[Andrius Merkys]

Hi Dean,

On 2022-04-13 12:33, Keeble, Dean (DLSLtd,RAL,LSCI) wrote:
> $ mysql -u cod_reader -h sql.crystallography.net -e 'select count(*)
> from data where flags like "%has Fobs%"' cod | cat
> ERROR 2003 (HY000): Can't connect to MySQL server on
> 'sql.crystallography.net' (110)
> 
> $ mysql --version
> mysql  Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using
> readline 5.1

Your command worked fine for me on both the following set ups:

$ mysql --version
mysql  Ver 14.14 Distrib 5.7.37, for Linux (x86_64) using  EditLine wrapper

$ mysql --version
mysql  Ver 15.1 Distrib 10.6.7-MariaDB, for debian-linux-gnu (x86_64)
using  EditLine wrapper

Could it be that your firewall settings block mysql connections (port
3306)? Are you able to connect to any other remote MySQL server?

Hope this helps,
Andrius

-- 
Andrius Merkys
Vilnius University Institute of Biotechnology, Saulėtekio al. 7
LT-10257 Vilnius, Lithuania

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.