You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@netbeans.apache.org by Dr Francis Greaves <fr...@choughs.org> on 2020/04/19 12:20:08 UTC
I cannot find the MySQL Plugin
Dear All
I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3 version of Netbeans, only to come unstuck at the absence of a MySQL Plugin. I know there is a Database connection in the Services, but I cannot get that to connect.
Is there an alternative?
Looks Like I will stick with the 8.2 Netbeans for now.
Regards
Francis
Re: I cannot find the MySQL Plugin
Posted by John Lavelle <jo...@jql.co.uk>.
Have a look at this video about fixing NetBeans MySQL connection Errors:
https://youtu.be/qD2PwMokQiE
Also this video for Time Zone connection problems:
https://youtu.be/yUEA0kQfoEo
Best regards,
John
john@jql.co.uk
On Sun, 19 Apr 2020 at 14:45, Richard Grin <Ri...@univ-cotedazur.fr>
wrote:
> Hi Francis,
>
> It's easy to use MySQL 8.0.19 with NetBeans.
>
> 1. In the tab Services, open the entry Databases > Drivers. If you don't
> already have an entry for MySQL, create a new one.
>
> If you create a new one, a new window is opened. Add the path to the jar
> for the MySQL driver (path to mysql-connector-java-8.0.19.jar). For the
> driver class, enter com.mysql.cj.jdbc.Driver. Give any name for the Name.
>
> If you already have an entry for MySQL, clic on Customize to check the
> information.
>
> 2. Right click on the driver and choose "Connect Using...". A "New
> Connection Wizard" window is displayed. In the Database field, enter
> jdbc:mysql://localhost:3306/customer?useTimezone=true&serverTimezone=UTC
> (change the serverTimeZone if you want).
>
> Enter the password and Test Connection.
>
> Click Finish.
>
>
> Perhaps there is another way to use MySQL into NetBeans, but the way I
> just described above worked for me.
>
> Regards,
>
> Richard
>
>
> Le 19/04/2020 à 14:20, Dr Francis Greaves a écrit :
>
> Dear All
> I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3 version
> of Netbeans, only to come unstuck at the absence of a MySQL Plugin. I know
> there is a Database connection in the Services, but I cannot get that to
> connect.
> Is there an alternative?
> Looks Like I will stick with the 8.2 Netbeans for now.
> Regards
> Francis
>
>
>
Re: I cannot find the MySQL Plugin
Posted by Richard Grin <Ri...@univ-cotedazur.fr>.
Obviously, you must change "customer" in the step 2 to the name of your
database...
Le 19/04/2020 à 14:45, Richard Grin a écrit :
>
> Hi Francis,
>
> It's easy to use MySQL 8.0.19 with NetBeans.
>
> 1. In the tab Services, open the entry Databases > Drivers. If you
> don't already have an entry for MySQL, create a new one.
>
> If you create a new one, a new window is opened. Add the path to the
> jar for the MySQL driver (path to mysql-connector-java-8.0.19.jar).
> For the driver class, enter com.mysql.cj.jdbc.Driver. Give any name
> for the Name.
>
> If you already have an entry for MySQL, clic on Customize to check the
> information.
>
> 2. Right click on the driver and choose "Connect Using...". A "New
> Connection Wizard" window is displayed. In the Database field, enter
> jdbc:mysql://localhost:3306/customer?useTimezone=true&serverTimezone=UTC
> (change the serverTimeZone if you want).
>
> Enter the password and Test Connection.
>
> Click Finish.
>
>
> Perhaps there is another way to use MySQL into NetBeans, but the way I
> just described above worked for me.
>
> Regards,
>
> Richard
>
>
> Le 19/04/2020 à 14:20, Dr Francis Greaves a écrit :
>> Dear All
>> I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3
>> version of Netbeans, only to come unstuck at the absence of a MySQL
>> Plugin. I know there is a Database connection in the Services, but I
>> cannot get that to connect.
>> Is there an alternative?
>> Looks Like I will stick with the 8.2 Netbeans for now.
>> Regards
>> Francis
>>
>>
Re: I cannot find the MySQL Plugin
Posted by Richard Grin <Ri...@univ-cotedazur.fr>.
Hi Francis,
It's easy to use MySQL 8.0.19 with NetBeans.
1. In the tab Services, open the entry Databases > Drivers. If you don't
already have an entry for MySQL, create a new one.
If you create a new one, a new window is opened. Add the path to the jar
for the MySQL driver (path to mysql-connector-java-8.0.19.jar). For the
driver class, enter com.mysql.cj.jdbc.Driver. Give any name for the Name.
If you already have an entry for MySQL, clic on Customize to check the
information.
2. Right click on the driver and choose "Connect Using...". A "New
Connection Wizard" window is displayed. In the Database field, enter
jdbc:mysql://localhost:3306/customer?useTimezone=true&serverTimezone=UTC
(change the serverTimeZone if you want).
Enter the password and Test Connection.
Click Finish.
Perhaps there is another way to use MySQL into NetBeans, but the way I
just described above worked for me.
Regards,
Richard
Le 19/04/2020 à 14:20, Dr Francis Greaves a écrit :
> Dear All
> I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3
> version of Netbeans, only to come unstuck at the absence of a MySQL
> Plugin. I know there is a Database connection in the Services, but I
> cannot get that to connect.
> Is there an alternative?
> Looks Like I will stick with the 8.2 Netbeans for now.
> Regards
> Francis
>
>
RE: I cannot find the MySQL Plugin
Posted by Eirik Bakke <eb...@ultorg.com>.
The MariaDB driver, which is bundled with NetBeans, should be fully compatible/equivalent to the MySQL driver. It's a fork of the same code, just under a different name and license.
(I'm not 100% sure whether the MySQL server management actions recognize this, though.)
-- Eirik
From: Emilian Bold <em...@gmail.com>
Sent: Sunday, April 19, 2020 8:44 AM
To: francis@choughs.org
Cc: users <us...@netbeans.apache.org>
Subject: Re: I cannot find the MySQL Plugin
If you rightclick Databases in the Services window you have a 'Register MySQL server' action. If you right click and do 'New Connection' you have a wizard mentioning how the MySQL driver can be installed.
Due to licensing issues Apache can't include out of the box the MySQL driver...
--emi
On Sun, Apr 19, 2020 at 3:20 PM Dr Francis Greaves <fr...@choughs.org>> wrote:
Dear All
I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3 version of Netbeans, only to come unstuck at the absence of a MySQL Plugin. I know there is a Database connection in the Services, but I cannot get that to connect.
Is there an alternative?
Looks Like I will stick with the 8.2 Netbeans for now.
Regards
Francis
Re: I cannot find the MySQL Plugin
Posted by Emilian Bold <em...@gmail.com>.
If you rightclick Databases in the Services window you have a 'Register
MySQL server' action. If you right click and do 'New Connection' you have a
wizard mentioning how the MySQL driver can be installed.
Due to licensing issues Apache can't include out of the box the MySQL
driver...
--emi
On Sun, Apr 19, 2020 at 3:20 PM Dr Francis Greaves <fr...@choughs.org>
wrote:
> Dear All
> I thought I would move from Oracle Netbeans 8.2 to the Apache 11.3 version
> of Netbeans, only to come unstuck at the absence of a MySQL Plugin. I know
> there is a Database connection in the Services, but I cannot get that to
> connect.
> Is there an alternative?
> Looks Like I will stick with the 8.2 Netbeans for now.
> Regards
> Francis
>
>
>