I'm new to both of the above programs, which run on Mac OSX Mavericks. The MySQL database is running under Sequel Pro.
I need to get the database I have in MySQL into Mathematica and run statistics on the data. Mathematica seems to have a wonderful data source/connection wizard to facilitate connecting to JDBC databases.
The problem is that it asks for the following information:
Hostname, Port (already filled in for me), Database, Attributes, Username, Password.
I have no idea where to find the hostname, what I should use as the database name (the title seems to be mysql), or how I can list all of the attributes.
I have a username and password provided by either MySQL or Sequel Pro. A confounding problem is that I cannot find the actual MySQL database except thru Sequel Pro. MySQL starts with my computer and appears to be living in a private /var/ file. Any suggestions on how I can make this work without complex command line instructions (that's why I'm using the wizard) or scripts? Many thanks for reading!