[ensembl-dev] MySQL server error

Mahmut Uludag mahmut.uludag at kaust.edu.sa
Wed Dec 20 08:18:40 GMT 2017

Following page on IGSR website suggests the user name should be 'anonymous' rather than 'anon'


However, I was not able to see a database named as "population_freqs" on the server, when I connected with SQuirrel SQL Client or with MySQL command line ('show databases').

Is it possible that the tables you are looking for are on "homo_sapiens_variation_73_37" database?

When I executed the following statement on my machine, it did not return any error

sql= src_mysql("homo_sapiens_variation_73_37", host = "mysql-db.1000genomes.org", user = "anonymous", port = 4272)


> sql= src_mysql("population_freqs", host = "mysql-db.1000genomes.org<http://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<http://net-93-65-134-xxx.cust.vodafonedsl.it/>' (using password: NO)

This message and its contents including attachments are intended solely for the original recipient. If you are not the intended recipient or have received this message in error, please notify me immediately and delete this message from your computer system. Any unauthorized use or distribution is prohibited. Please consider the environment before printing this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20171220/0cd99d32/attachment.html>

More information about the Dev mailing list