I am trying to connect through JDBC a DB.mwb under mysql (MAMP).
I am a mac user (newbie indeed..) I downloaded MAMP and started the local mysql.
The server properly run under /127.0.0.1:8889 (checked) and the local folder is /MAMP/htdocs/
With Sequel Pro I created a standard TCP/IP connection named connectionDB and it seems properly running on 127.0.01:8889 (root as username and password).
Now, with both server and connection running, I entered the string jdbc:mysql://127.0.0.1:8889/connectionDB but it doestn't connect on refresh (only using jdbc:mysql://127.0.0.1:8889/ works).
some questions to understand the logic of a connection:
where the phisical database DB.mwb should be stored? under /htdocs/? or under the WebRatio folder and I should specify the path in the connection somewhere? or else the connectionDB creates it automatically somewhere?
i entered also various combination of string jdbc:mysql://127.0.0.1:8889/ or jdbc:mysql://localhost:8889/ or jdbc:mysql://127.0.0.1:8889/DB.mwd, nothing seems working
my first time with local server db connection and first time on mac..
thanks in advance