Stein, Olaf wrote:
Hi all,
Very new to galaxy and trying to setup an instance here with mysql as the backend database.
I added this line: mysql:///galaxy?unix_socket=/var/run/mysqld/mysqld.sock
To the universe_wsgi.ini file Where do I define the dbuser, password and database that I want to use? And what else do I need to do, for instance create the schema, etc?
Hi Olaf,
Galaxy will automatically create the tables/etc. upon startup. To set the user, password, and database, use a URL like this:
mysql://user@pass:/dbname?unix_socket=/var/run/mysqld/mysqld.sock
--nate
Thanks Olaf
Olaf Stein DBA Battelle Center for Mathematical Medicine Nationwide Children's Hospital, The Research Institute 700 Children's Drive 43205 Columbus, OH phone: 1-614-355-5685 cell: 1-614-843-0432 email: olaf.stein@nationwidechildrens.org
“I consider that the golden rule requires that if I like a program I must share it with other people who like it.” Richard M. Stallman
galaxy-user mailing list galaxy-user@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-user