I am unable to connect to my local mysql server using Mathematica.
OpenSQLConnection[JDBC["MySQL(Connector/J)", "jdbc:mysql://localhost/MedusaTrials"], "Username"->"root"]
JDBC::error: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. >>
I have had success with remote mysql databases but no success with my local server. In Python SQLAlchemy my database is accessed successfully using
I have not been able to translate this access method into the equivalent for Mathematica. I have tried on a number of occasions without success. I have tried to use the wizard
Also without success.
Using Sequel Pro my local data is accessed using the Socket method.
I have researched many questions here but the answer to my problem has eluded me.
Any help will be most appreciated.