You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@netbeans.apache.org by rick pizzi <pi...@yandex.com> on 2019/07/26 22:56:07 UTC
Unable to connect to the MySql Server
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
Posted by Geertjan Wielenga <ge...@apache.org>.
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 <pi...@yandex.com> 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
Posted by Darin Miller <da...@gmail.com>.
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 <pi...@yandex.com> 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
Posted by Laszlo Kishalmi <la...@gmail.com>.
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
> <laszlo.kishalmi@gmail.com <ma...@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
Posted by Darin Miller <da...@gmail.com>.
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 <la...@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
Posted by Laszlo Kishalmi <la...@gmail.com>.
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*
> *
>
> *
> *
>
> *
> *
>
>
>
>
>
>