Connect Netbeans to XAMPP-VM mysql

[sotonj]

First of all, I am new in programing, I grateful for your help.

when I try to connect from Netbeans with mysql using XAMPP-VM , the system give me this 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.

This are my lines of code from Netbeans (java) for connection:

try{

Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:8080/bd_ins","root","");

}catch (SQLException e){

System.out.println(e.getMessage());
System.out.println(e.getErrorCode());

}

My operating System is OS X Capitan
In Netbeans I am using this driver: mysql-connector-java-5.1.46.jar

XAMPP-VM is working right because all services are on: Apache, MySql. When I put: http://localhost:8080/phpmyadmin/ in the browser, this works

Thanks for your help, I am stuck since 4 days

[Nobbie]

The Port is wrong in the connection, 8080 is for http and not for Mysql. Apply 3306 instead of 8080.

[sotonj]

Thanks for your answer, I changed the port and changed localhost for my IP and it didn´t work. Then, I searched the file my.cnf and edit the section : [mysqld],

I added this:

skip-grant-tables

and it works

Thank you so much for your help,

[marc.elbet@orange.fr]

I Thanks for the advice.
I tried it but it didn’t work.

The previous “non-vm” XAMPP worked wonders with NetBeans and Chrome (I used it for years) but XAMPP-VM just doesn’t.

When hitting the “RUN” icon I just get the “local host doesn’t allow connection" and the path in the navigation path is wrong:
I get http://localhost/MY_DB/index.php
when it should be:http://localhost:8080/Project1/MY_DB/index.php

What the hell did I do wrong as the project creation was OK.
Any help will be appreciated.
Cheers.

Marc

[Altrea]

The previous “non-vm” XAMPP worked wonders with NetBeans and Chrome (I used it for years) but XAMPP-VM just doesn’t.

So why don't you install the installer version instead?

[marc.elbet@orange.fr]

I did’nt know there was one.
Can you give me more details, eg: where to get it.
I reckon somedoc will be available with the product.
Many thanks
I appreciate your help
Marc

[Altrea]

At the download page: https://www.apachefriends.org/download.html

There are big files (~360Mb). These are the VM versions.
And there are small files (@160Mb). These are the Installer versions.
You can distinguish them by their file name too. The vm versions contain vm in the filename, the installer versions contain installer in their filename.