[ensembl-dev] Region report tool / Registry - only works for mysql users without password?

Nick Langridge nickl at ebi.ac.uk
Mon Apr 30 16:00:49 BST 2012


I'm trying to use the region report tool but it seems to ignore the 
mysql password that I supply in the options:

perl  region_report.pl --species=Anopheles_gambiae 
--input=/tmp/inputfile --include=gt --report --host=localhost 
--port=3306 --db_version=66 --user=myuser --password=mypass 
--secondaryhost=localhost --secondaryport=3306 --db_version=66 
--secondaryuser=myuser --secondarypassword=mypass --output=/tmp/outputfile

I see error:

connect:   DBI:mysql:host=localhost;port=3306 myuser  at 
line 1566.
DBI connect('host=localhost;port=3306','myuser',...) failed: Access 
denied for user 'myuser'@'localhost' (using password: NO) at 
line 1567

-------------------- EXCEPTION --------------------
MSG: Cannot connect to the Ensembl MySQL server at localhost:3306; check 
your settings & DBI error message: Access denied for user 
'myuser'@'localhost' (using password: NO)
STACK Bio::EnsEMBL::Registry::load_registry_from_db 
STACK Bio::EnsEMBL::Registry::load_registry_from_multiple_dbs 
STACK toplevel 
Ensembl API version = 66

As far as I can see, the region report script calls  
Bio::Ensembl::Registry->load_registry_from_multiple_dbs() with the 
password present, but the registry seems to ignore it.

Is this the expected behaviour?


More information about the Dev mailing list