netbeans-netcat mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Efrem Mc <efrem...@gmail.com>
Subject Re: Unable to start MySQL in NetBeans
Date Thu, 26 Apr 2018 12:12:32 GMT
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>
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:
>
>
>
>
>
> 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.:
>
>
>
>
>
> And
>
>
>
>
>
> The results is:
>
>
>
>
>
> Then, if I try to start MySQL in NetBeans from the context menu, I receive
> the prompt:
>
>
>
>
>
> 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:
>
>
>
>
>
> Have you any idea about these at all?
>
>
>
> Thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <efremmc2@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <martin_oshea@outlook.com>; users@netbeans.apache.org;
> netcat <netcat@netbeans.apache.org>
> *Cc:* Jiří­ Kovalský <jiri.kovalsky@oracle.com>; Paul Franz <
> 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> 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> 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> 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> 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
View raw message