RE: I cannot find the MySQL Plugin
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 Sent: Sunday, April 19, 2020 8:44 AM To: fran...@choughs.org Cc: users 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 mailto:fran...@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
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 j...@jql.co.uk On Sun, 19 Apr 2020 at 14:45, Richard Grin 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=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
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=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
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=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
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 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 > > >
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