netbeans-netcat mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin O'Shea <martin_os...@outlook.com>
Subject RE: Unable to start MySQL in NetBeans
Date Thu, 26 Apr 2018 12:35:28 GMT
For all of the connections I have, there does not seems to be any issue now connecting to MySQL
8.0.11 in NetBeans 8.2.

But, I still cannot connect via the Start or Connect options on the context menu shown below:

[cid:image007.png@01D3DD63.57310ED0]

The messages I get are those described below in an earlier post. Prior to this new version
of MySQL, the MySQL Server icon above in NetBeans would always be connected by default. This
is what I am trying to resolve now.

From: Efrem Mc <efremmc2@gmail.com>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <martin_oshea@outlook.com>
Cc: users@netbeans.apache.org; netcat <netcat@netbeans.apache.org>; Jiří­ Kovalský
<jiri.kovalsky@oracle.com>; Paul Franz <paul.franz@oracle.com>
Subject: Re: Unable to start MySQL in NetBeans

Okay, I did not mention this but I removed the last part of the connection string on the driver.

Old string:  jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull

New string:  jdbc:mysql://localhost:3310

I am using port 3310 for MySQL 8.0.11.


After connecting, I noticed the system changed a setting to:


jdbc:mysql://localhost:3310/mysql?zeroDateTimeBehavior=convertToNull
Display name:  jdbc:mysql://localhost:3310/dbtest?zeroDateTimeBehavior=convertToNull [root
on Default schema]

This will show once you connect to a database in my case I am connected the dbtest
Database URL: jdbc:mysql://localhost:3310/dbtest?zeroDateTimeBehavior=convertToNull



On Thu, Apr 26, 2018 at 7:27 AM, Martin O'Shea <martin_oshea@outlook.com<mailto:martin_oshea@outlook.com>>
wrote:
Efrem

I have been trying your suggestions in the last 30 minutes:

I am able to create connections in NetBeans 8.2 to MySQL 8.0.11 using both connectors 5.1.46
and 8.0.11 and can execute SQL commands:

[cid:image008.png@01D3DD63.57310ED0]

So that is an improvement in my situation.

However, what I have not been able to do so far is register MySQL 8.0.11 in NetBeans 8.2 itself,
i.e.:

[cid:image009.png@01D3DD63.57310ED0]

And

[cid:image010.png@01D3DD63.57310ED0]

The results is:

[cid:image011.png@01D3DD63.57310ED0]

Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:

[cid:image012.png@01D3DD63.57310ED0]

And messages:

2018-04-26T11:22:58.117040Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server
8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 3364
mysqld: Table 'mysql.plugin' doesn't exist
2018-04-26T11:23:00.260993Z 0 [ERROR] [MY-010735] [Server] Can't open the mysql.plugin table.
Please run mysql_upgrade to create it.
2018-04-26T11:23:00.993556Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used.
Table 'mysql.gtid_executed' cannot be opened.
2018-04-26T11:23:02.212455Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self
signed.
2018-04-26T11:23:02.219559Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP
port: Unknown error
2018-04-26T11:23:02.219766Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld
server running on port: 3306 ?
2018-04-26T11:23:02.220053Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-04-26T11:23:04.027661Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server
8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

Yet table mysql_plugin does exist under 8.0.11.

Similarly when trying to connect to the registered version of MySQL, I receive:

[cid:image013.png@01D3DD63.57310ED0]

Have you any idea about these at all?

Thanks

Martin O’Shea.

From: Efrem Mc <efremmc2@gmail.com<mailto:efremmc2@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <martin_oshea@outlook.com<mailto:martin_oshea@outlook.com>>;
users@netbeans.apache.org<mailto:users@netbeans.apache.org>; netcat <netcat@netbeans.apache.org<mailto:netcat@netbeans.apache.org>>
Cc: Jiří­ Kovalský <jiri.kovalsky@oracle.com<mailto:jiri.kovalsky@oracle.com>>;
Paul Franz <paul.franz@oracle.com<mailto:paul.franz@oracle.com>>
Subject: Re: Unable to start MySQL in NetBeans

Hi all:
I have the following running on this system concurrently MySQL 5.6 on port 3308, Maria DB
10.x on port 3306, MySQL 8.0.11 on port 3310, and Oracle XE Express on port 1521. Several
Apache & Tomcat servers running on different ports and all working.


On Thu, Apr 26, 2018, 1:26 AM Efrem Mc <efremmc2@gmail.com<mailto:efremmc2@gmail.com>>
wrote:
Tested on NB 9.0 build 413 using MySQL 8.0.11 using legacy
authentication.  This works!

Pictures for proof.

Efrem

On Thu, Apr 26, 2018 at 12:51 AM, Efrem Mc <efremmc2@gmail.com<mailto:efremmc2@gmail.com>>
wrote:
> Hi all:
>
> Once the connection was made, I ran a command:   create database dbtest
> It works!
>
> Now testing on NB 9.0 beta build 413 on Windows and MacOS.
>
> Regards,
>
> Efrem
>
> On Thu, Apr 26, 2018 at 12:29 AM, Efrem Mc <efremmc2@gmail.com<mailto:efremmc2@gmail.com>>
wrote:
>> Hi all:
>>
>> Here is something to review.  Starting in mySQL 8.0.11, there is a new
>> authentication method; Use Strong Password Encryption for
>> Authentication using SHA256-based password methods or Legacy
>> Authentication Method (Retain mySQL 5.x Compatibility).  If you select
>> the Strong Password Encryption method, a new connector and clients
>> (caching_sha2_password authentication) is needed.  The system admin
>> can select which method to use.  For compatibility, I selected Legacy
>> authentication and different connector.
>>
>> The default connector in NB 8.2 for mySQL uses the following:
>>
>> Driver:           C:\Program Files\NetBeans
>> 8.2\ide\modules\ext\mysql-connector-java-5.1.23-bin.jar
>> Driver class:  com.mysql.jdbc.Driver
>> Name:           <any name you want here, defaults: MySQL (Connector/J driver)>
>>
>> This will NOT work with 8.0.11!
>>
>> Using Legacy mode, use the following:
>> Driver:           C:\Program
>> Files\Java\jdk1.8.0_162\db\lib\mysql-connector-java-5.1.46.jar
>> Driver class:  com.mysql.jdbc.Driver   (Same calling method)
>> Name:            <any name you want here, I changed it to: MySQL
>> (Connector/J driver) 5.1.46>
>>
>> This works using NB.  See attached.  I downloaded the above driver,
>> search for it.
>>
>> I will next change the authentication method to the Strong Password
>> Encryption and use the following configuration.  I will also test it
>> with the legacy authentication to just see it fail.
>>
>> mysql-connector-java-8.0.11.jar
>>
>> It is installed in:  C:\Program Files (x86)\MySQL\Connector J 8.0
>> But this requires either a selective installation of mySQL using their
>> installer, just don't accept the default method to customize it.  I
>> selected the components to install and selected the connector.
>>
>> The connector is also available at:
>> https://dev.mysql.com/downloads/connector/j/5.0.html
>>
>>
>> phpMyAdmin from version 1.42 and higher supports the administration of
>> multiple MySQL servers.  I am attaching one I am usings as an example.
>> I am using XAMPP on Windows here.
>>
>> The file is located in: C:\xampp\phpMyAdmin\
>>
>> The filename is config.inc.php.  I changed the name because I hard
>> coded the admin account and password.  There is probably a method to
>> prompt for the name. I did not have time to set it up or try it.
>>
>>
>> Regards,
>>
>> Efrem McCrimon
>> GUI Builder Tribe
>> DB Tribe
>>
>>
>>
>> On Wed, Apr 25, 2018 at 6:04 PM, Martin O'Shea <martin_oshea@outlook.com<mailto:martin_oshea@outlook.com>>
wrote:
>>> Paul
>>>
>>>
>>>
>>> I have just run MySQL_Upgrade as you suggested, and have restarted MySQL and
>>> NetBeans. But unfortunately, the result is the same as before.
>>>
>>>
>>>
>>> Yet I know that table 'mysql.plugin' does exist.
>>>
>>>
>>>
>>> Any ideas?
>>>
>>>
>>>
>>> Thanks
>>>
>>>
>>>
>>> Martin O’Shea.
>>>
>>>

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message