Re: Unable to connect to the MySql Server

2019-07-27 Thread Laszlo Kishalmi

You might use:

libmariadb-java

On 7/26/19 10:01 PM, Darin Miller wrote:
As shown here: 
https://packages.ubuntu.com/search?keywords=libmysql-java&searchon=names&suite=all§ion=all, libmysql-java 
is no longer available in 19.04.  I asked in ubuntu-devel IRC asking 
if omission was intentional but given that its Friday night, I am not 
expecting a quick response.


 o__
__>/ __
(__)\(__) Darin | 208-991-4421


On Fri, Jul 26, 2019 at 10:42 PM Laszlo Kishalmi 
mailto:laszlo.kisha...@gmail.com>> wrote:


The following two JIRA issues answer everything:

https://issues.apache.org/jira/browse/NETBEANS-70

https://issues.apache.org/jira/browse/NETBEANS-2640


On 7/26/19 3:56 PM, rick pizzi wrote:


Running Ubuntu 18.04  with OpenJDK Runtime Environment (build
11.0.3+7-Ubuntu-1ubuntu218.04.1)

I have installed NetBeans 11.1.  I know nothing about Netbeans so
am trying to learn from book 'August 2015 Mastering Netbeans' .

The book says "*/Netbeans provides native built-in support for
MySql. No additional drivers need to be downloaded to connect to
MySql databases; everything is provided as standard with
Netbeans/*".


Per instructions I right-clicked *Register MySql Server* thus
opening *MySql Server Properties* and filled out properties.

I now get under *Services => Databases => MySql Server at
localhost:3306[rick] (disconnected)**.
*

(I didn't use root as rick has all privaleges including GRANT).*
*

*
*

Don't know where to go from here!*
*

*
*

Thanks for help,

rick*
*

*
*

*
*








Re: Unable to connect to the MySql Server

2019-07-26 Thread Darin Miller
As shown here:
https://packages.ubuntu.com/search?keywords=libmysql-java&searchon=names&suite=all§ion=all,
libmysql-java
is no longer available in 19.04.  I asked in ubuntu-devel IRC asking if
omission was intentional but given that its Friday night, I am not
expecting a quick response.

 o__
  >/
( )\( ) Darin | 208-991-4421


On Fri, Jul 26, 2019 at 10:42 PM Laszlo Kishalmi 
wrote:

> The following two JIRA issues answer everything:
>
> https://issues.apache.org/jira/browse/NETBEANS-70
>
> https://issues.apache.org/jira/browse/NETBEANS-2640
>
>
> On 7/26/19 3:56 PM, rick pizzi wrote:
>
> Running Ubuntu 18.04  with OpenJDK Runtime Environment (build
> 11.0.3+7-Ubuntu-1ubuntu218.04.1)
>
> I have installed NetBeans 11.1.  I know nothing about Netbeans so am
> trying to learn from book 'August 2015 Mastering Netbeans' .
>
> The book says "*Netbeans provides native built-in support for MySql. No
> additional drivers need to be downloaded to connect to MySql databases;
> everything is provided as standard with Netbeans*".
>
>
> Per instructions I right-clicked *Register MySql Server* thus opening *MySql
> Server Properties* and filled out properties.
>
> I now get under *Services => Databases => MySql Server at
> localhost:3306[rick] (disconnected)*
> *. *
>
> (I didn't use root as rick has all privaleges including GRANT).
>
>
> Don't know where to go from here!
>
>
> Thanks for help,
>
> rick
>
>
>
>
>
>
>
>
>


Re: Unable to connect to the MySql Server

2019-07-26 Thread Laszlo Kishalmi

The following two JIRA issues answer everything:

https://issues.apache.org/jira/browse/NETBEANS-70

https://issues.apache.org/jira/browse/NETBEANS-2640


On 7/26/19 3:56 PM, rick pizzi wrote:


Running Ubuntu 18.04  with OpenJDK Runtime Environment (build 
11.0.3+7-Ubuntu-1ubuntu218.04.1)


I have installed NetBeans 11.1.  I know nothing about Netbeans so am 
trying to learn from book 'August 2015 Mastering Netbeans' .


The book says "*/Netbeans provides native built-in support for MySql. 
No additional drivers need to be downloaded to connect to MySql 
databases; everything is provided as standard with Netbeans/*".



Per instructions I right-clicked *Register MySql Server* thus opening 
*MySql Server Properties* and filled out properties.


I now get under *Services => Databases => MySql Server at 
localhost:3306[rick] (disconnected)**.

*

(I didn't use root as rick has all privaleges including GRANT).*
*

*
*

Don't know where to go from here!*
*

*
*

Thanks for help,

rick*
*

*
*

*
*








Re: Unable to connect to the MySql Server

2019-07-26 Thread Darin Miller
Rick,

Unless someone knows otherwise, I don't think the driver is included.  I
had to download mysql jar file from here:
https://jar-download.com/artifacts/mysql/mysql-connector-java (i.e. current
version is mysql-connector-java-8.0.16.jar)

Under *Services => Databases*  right click on *Drivers* and select the
downloaded jar file.

Also, ensure to set the timezone in mysql, i.e. for MDT use:

SET GLOBAL time_zone = '-6:00';


 o__
  >/
( )\( ) Darin | 208-991-4421


On Fri, Jul 26, 2019 at 4:56 PM rick pizzi  wrote:

> Running Ubuntu 18.04  with OpenJDK Runtime Environment (build
> 11.0.3+7-Ubuntu-1ubuntu218.04.1)
>
> I have installed NetBeans 11.1.  I know nothing about Netbeans so am
> trying to learn from book 'August 2015 Mastering Netbeans' .
>
> The book says "*Netbeans provides native built-in support for MySql. No
> additional drivers need to be downloaded to connect to MySql databases;
> everything is provided as standard with Netbeans*".
>
>
> Per instructions I right-clicked *Register MySql Server* thus opening *MySql
> Server Properties* and filled out properties.
>
> I now get under *Services => Databases => MySql Server at
> localhost:3306[rick] (disconnected)*
> *. *
>
> (I didn't use root as rick has all privaleges including GRANT).
>
>
> Don't know where to go from here!
>
>
> Thanks for help,
>
> rick
>
>
>
>
>
>
>
>
>


Re: Unable to connect to the MySql Server

2019-07-26 Thread Geertjan Wielenga
Is it smart to assume that a book entitled 'August 2015 Mastering Netbeans'
is going to be 100% accurate in August 2019?

There are tutorials here that show how NetBeans and MySQL work together --
and you're needed to review them:

https://netbeans.apache.org/kb/docs/ide/index.html

Please do so and provide feedback, ideally via pull requests on the
documents above.

Thanks,

Gj


On Sat, Jul 27, 2019 at 12:56 AM rick pizzi  wrote:

> Running Ubuntu 18.04  with OpenJDK Runtime Environment (build
> 11.0.3+7-Ubuntu-1ubuntu218.04.1)
>
> I have installed NetBeans 11.1.  I know nothing about Netbeans so am
> trying to learn from book 'August 2015 Mastering Netbeans' .
>
> The book says "*Netbeans provides native built-in support for MySql. No
> additional drivers need to be downloaded to connect to MySql databases;
> everything is provided as standard with Netbeans*".
>
>
> Per instructions I right-clicked *Register MySql Server* thus opening *MySql
> Server Properties* and filled out properties.
>
> I now get under *Services => Databases => MySql Server at
> localhost:3306[rick] (disconnected)*
> *. *
>
> (I didn't use root as rick has all privaleges including GRANT).
>
>
> Don't know where to go from here!
>
>
> Thanks for help,
>
> rick
>
>
>
>
>
>
>
>
>


Unable to connect to the MySql Server

2019-07-26 Thread rick pizzi
Running Ubuntu 18.04  with OpenJDK Runtime Environment (build 
11.0.3+7-Ubuntu-1ubuntu218.04.1)


I have installed NetBeans 11.1.  I know nothing about Netbeans so am 
trying to learn from book 'August 2015 Mastering Netbeans' .


The book says "*/Netbeans provides native built-in support for MySql. No 
additional drivers need to be downloaded to connect to MySql databases; 
everything is provided as standard with Netbeans/*".



Per instructions I right-clicked *Register MySql Server* thus opening 
*MySql Server Properties* and filled out properties.


I now get under *Services => Databases => MySql Server at 
localhost:3306[rick] (disconnected)**.

*

(I didn't use root as rick has all privaleges including GRANT).*
*

*
*

Don't know where to go from here!*
*

*
*

Thanks for help,

rick*
*

*
*

*
*