[ensembl-dev] MySQL server error

[Davide Piffer]

Thanks for your reply.
I used the host name but I get an error message.
> sql= src_mysql("population_freqs", host = "mysql-db.1000genomes.org",
user = "anon", port = 4272)
Error in .local(drv, ...) :
  Failed to connect to database: Error: Access denied for user 'anon'@'
net-93-65-134-xxx.cust.vodafonedsl.it' (using password: NO)
> sql= src_mysql("population_freqs", host = "mysql-db.1000genomes.org",
user = "anon", port = 3306)
I changed port number from 4272 to 3306 and get another error:
Error in .local(drv, ...) :
  Failed to connect to database: Error: Can't connect to MySQL server on '
mysql-db.1000genomes.org' (0)


Davide

On 19 Dec 2017 6:57 pm, "Kieron Taylor" <ktaylor at ebi.ac.uk> wrote:

> Hi Davide,
>
> I can access the 1000 genomes public MySQL server at this time via its
> hostname mysql-db.1000genomes.org . The server is up and seems to be
> happy.
>
> It is generally better to use the hostname by default, as the IP address
> may well have changed at some point.
>
>
> Kieron
>
>
> > On 19 Dec 2017, at 17:21, Davide Piffer <pifferdavide at gmail.com> wrote:
> >
> > sql= src_mysql("population_freqs", host = "67.207.92.10", user = "anon",
> port = 3306)
> >
> > I get the following:
> > Error in .local(drv, ...) :
> >   Failed to connect to database: Error: Can't connect to MySQL server on
> '67.207.92.10' (0)
> >
> > I changed the port to 4272 but it is not working either.
> > I know sometimes the IP address changes so I wonder if there is a new
> one.
> >
> > Many thanks in advance!!
> >
> > Davide
> > _______________________________________________
> > Dev mailing list    Dev at ensembl.org
> > Posting guidelines and subscribe/unsubscribe info:
> http://lists.ensembl.org/mailman/listinfo/dev
> > Ensembl Blog: http://www.ensembl.info/
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info:
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20171220/77140cad/attachment.html>