• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

I cannot start MySQL db  RSS feed

 
Ranch Hand
Posts: 40
1
Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
screen_shot_2015_04_19_at_005202_102.png
[Thumbnail for screen_shot_2015_04_19_at_005202_102.png]
 
Marshal
Posts: 24467
55
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 40
1
Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Posts: 24467
55
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 40
1
Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Posts: 24467
55
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 40
1
Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 .
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!