I will go right to the problem.
I have a localhost (XAMPP) installed on my computer (Mac). With this installation follows a MySQL server, and I would like to connect to it. But here is what happens:
Needs["DatabaseLink`"]
conn1 = OpenSQLConnection[JDBC["MySQL(Connector/J)", "127.0.0.1"], "Username" -> "root", "Password" -> ""]
The result is get is:
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. >>
$Failed
I have checked the following:
I am running out of ideas on what to do. This problem has always existed and I have never been able to solve it.
I would be really greatful if someone miraculously know tips and tricks to get it up and running.