Hi,
I'm trying to switch from sqlite to mySQL and need a little assistance with what goes in the database connection field in universe_wsgi.ini.
For instance, if I set up the following mySQL database: database = galaxy_test user = galaxy password = password
what would I use to connect to this. I have tried using
mysql:///galaxy_test?unix_socket=/var/run/mysqld/mysqld.sock but I cannot connect as it looks like a username and password are expected.
Thanks for any help Shaun Webb
SHAUN WEBB wrote:
I'm trying to switch from sqlite to mySQL and need a little assistance with what goes in the database connection field in universe_wsgi.ini.
For instance, if I set up the following mySQL database: database = galaxy_test user = galaxy password = password
what would I use to connect to this. I have tried using
mysql:///galaxy_test?unix_socket=/var/run/mysqld/mysqld.sock but I cannot connect as it looks like a username and password are expected.
Hi Shaun,
Try the following:
mysql://galaxy:password@/galaxy_test?unix_socket=/var/run/mysqld/mysqld.sock
--nate
Great, thanks!
Shaun
Quoting Nate Coraor nate@bx.psu.edu:
SHAUN WEBB wrote:
I'm trying to switch from sqlite to mySQL and need a little assistance with what goes in the database connection field in universe_wsgi.ini.
For instance, if I set up the following mySQL database: database = galaxy_test user = galaxy password = password
what would I use to connect to this. I have tried using
mysql:///galaxy_test?unix_socket=/var/run/mysqld/mysqld.sock but I cannot connect as it looks like a username and password are expected.
Hi Shaun,
Try the following:
mysql://galaxy:password@/galaxy_test?unix_socket=/var/run/mysqld/mysqld.sock
--nate
galaxy-dev@lists.galaxyproject.org