I cannot start MySQL db

[pagano monello]

Hi,
I start by saying that I've already posted this same message to netbeans.org forum. It's not my intenition to make cross posting, but I actually have a remarkable problem, and I need to work it out, because of my job. Since I had not reply from the other forum, I afford to post it here. I'm sorry for this anyway.

I can't connect to MySQL by using Netbeans, i've spent the whole day trying to do it, but I couldn't.

The environment I am using is this:
- mac os
- XAMPP
- Netbeans 8.0.2

I just want to start MySQL server from Netbeans, and I try to do it by adding the following driver:

mysql-connector-java-5.1.35-bin.jar

but it doesn't work. When I test the connection I get the following message:

Cannot establish a connection to jdbc:mysql://localhost:3306/BookSellerDB?zeroDateTimeBehavior=convertToNull...

I added the jar on my application library (the same connector version that I added while trying to establish the connection.). I also added the same file in the application folder (Window --> files...).

I really am in troubles.

Can anyone give me any suggestion? I'm getting crazy.

Thank you in advance

ps.: I add that I don't see anymore the symbol of the connection (I send an image of this icon) after adding a new driver, I see gears only.
This is strange and let me think that I made a mess.

ps2.: I add another clue to describe the issue: if I try to register MySQL server (Services --> Databases --> Register MySQL Server) I cannot, the function seems to be disabled.

[Paul Clapham]

Have you started the MySQL server on your computer? And is it running at port 3306 (the default for MySQL)? It appears that your code is trying to connect to the server at that port and can't find it. All those other error messages you describe have the same reason, too.

You probably won't get a response on the NetBeans forum because it isn't the job of NetBeans to start the server. So just start the MySQL server running and things should start working properly.

[pagano monello]

Thank you for your reply Paul Clapham. If I have understood it correctly, I can say that I have started my server from XAMPP administration tool, and it's correctly working, so that I can access my db. The correct title of my topic may be: "I cannot connect to MySQL db from Netbeans" then.

I do not know what to think.

[Paul Clapham]

pagano monello wrote:I can say that I have started my server from XAMPP administration tool, and it's correctly working, so that I can access my db.

This seems unlikely, since in fact you can not access your database.

However I looked up XAMPP on the web (since I don't know anything about it) and I didn't see anything about it being a tool for managing MySQL. It looked like a web server to me, but as I said I don't know anything about it. Could you tell us exactly what you did with XAMPP to cause the MySQL server to start?

[pagano monello]

I try to explain, with my poor technical knowledge, what XAMPP is. Actually it is a web server on which it's possible to run MySQL db, if you install XAMMP and go to PHPMyAdmin localhost you can create MySQL DBs. I do hope I have been clear enough (I am not so experienced).

Today I have tried to 'start' MSQL from Netbeans on another pc (Services --> Databases -->MySQL localhost -- > right click: start) and everything works perfectly. So I guess I have touched something in Netbeans settings (on the other pc); then now I do would like to uninstall Netbeans completely and reinstall it again. I already tried to do it on my Mac OSX, but it is not so simple: actually it's not enough to put Netbeans folder in the trash, however I do not have found any good tutorial online or guide which explains how to proceed to properly uninstall Netbeans on a Mac OS.

If anyone knew how to do or knew where to find a good guide, I would be grateful if he would suggest me it.

[Paul Clapham]

pagano monello wrote:I already tried to do it on my Mac OSX, but it is not so simple: actually it's not enough to put Netbeans folder in the trash, however I do not have found any good tutorial online or guide which explains how to proceed to properly uninstall Netbeans on a Mac OS.

If anyone knew how to do or knew where to find a good guide, I would be grateful if he would suggest me it.

My web search keywords which I chose for this weremac uninstall netbeans. The first link returned to me was a page from the NetBeans wiki entitled "How Do I Uninstall NetBeans in Mac OS X?" I'm very surprised that you didn't come across that page in your search.

[pagano monello]

In fact I came across and already tried to use the guides you mention, but no one worked, which could be due to three reasons at least:
- I made a mistake (it's not the first time and it won't be the last one. Amen)
- the Netbeans version I am trying to uninstall is 8.0.2, not 7.2; things may have changed in the meantime
- I guess that it's not enough to delete Netbeans folder
etc...

[Clem Harvey]

From 10.11 onwards, macOS protects certain folders by using SIP (System Integrity Protection). You may not be able to 'rm' the kext from terminal.  So if you cannot start MySQL db, try uninstalling MySQL it to keep your dev platform up to date. You may find some helpful tips in this guide .