You are viewing a plain text version of this content. The canonical link for it is here.
Posted to netcat@netbeans.apache.org by Efrem Mc <ef...@gmail.com> on 2018/04/26 11:11:24 UTC
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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin, do you use Powershell? I was thinking about developing a
Powershell script. I tested it and it works but I have a Windows BAT/CMD
that works.
Here is a Windows DOS batch file I created. The filename can end in either
.bat or .cmd
File contents: mysql_stop.bat
@echo off
@cd /D "C:\ProgramData\MySQL\MySQL Server 8.0\Data"
@echo Mysql database shutdowm custom ...
@if not exist %computername%.pid GOTO exit
@echo Delete %computername%.pid ...
for /f "delims=" %%x in (%computername%.PID) do set CN=%%x
taskkill /PID %CN% /F /T
:exit
I tested it and it works.
Regards,
Efrem
On Thu, Apr 26, 2018 at 3:02 PM, Martin O'Shea <ma...@outlook.com>
wrote:
> Again, many thanks.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 20 01
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, you're welcome. I am glad I was able to help. Interesting
> with all the driver changes and new authentication methods. Windows works
> better as a service and makes it easier to toggle services. When you run
> multiple instances there are many options that must be unique such as log
> files, message files, replication, and start/stop services. Hence the
> problem and I believe it is true for configuring as a windows service.
>
>
>
> Thanks for letting me know. You can alway use the command line or the NET
> STOP command to end the services. On the stop line, I added a '--password'
> option to prompt for a password. It never sent a prompt message. So now
> I am ending the database using from the command line. I will write a
> script but it has its own limits.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
> On Thu, Apr 26, 2018 at 2:50 PM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> Efrem
>
>
>
> I was just about to send it to you. You should be aware that I am now able
> to Start, Connect and Disconnect to MySQL within NetBeans as well. But the
> Stop option is not allowed but that is a minor concern given that I have
> now set MySQL up as a Windows service.
>
>
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 19 47
> *To:* Martin O'Shea <ma...@outlook.com>
>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> I start is working find and my stop is not working for using MySQL 8.0.11
> native. Using XAMPP services it works as they have a canned application
> that fixes the limits of the DOS scripting language. Powershell is so new
> and required special some configuration to execute the script. However it
> gets more complex when you have multiple database instances and want to
> stop specific ones. This is designated to a specific instance.
>
>
>
> Please over your Admin Property tab for MySQL. I have about 30 miin now.
>
>
>
> Regards
>
>
>
> Efrem
>
>
>
> On Thu, Apr 26, 2018, 12:19 PM Efrem Mc <ef...@gmail.com> wrote:
>
> Hi Martin, send a copy of you Admin property page
>
>
>
> I think the best way to manage the service depends on its functionality.
> Windows is not as nice for scripting as 'bash', PowerShell has the
> equivalent power as DOS batch is limited.
>
>
>
> Efrem
>
>
>
> On Thu, Apr 26, 2018 at 11:23 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> Efrem
>
>
>
> Unfortunately that did not work. The messages displayed were slightly
> different as you can see:
>
>
>
>
>
> Oddly enough the file C:\ProgramData\MySQL\MySQL Server 8.0\Data\ibdata1
> has Windows read and write permissions.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 16 11
> *To:* Martin O'Shea <ma...@outlook.com>
>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin:
>
>
>
> To start try this:
>
> Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
>
> Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL
> Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
>
>
>
> If you are using the default port, it defaults to 3306.
>
>
>
> To stop, use Disconnect. I will have to create a custom stop such as a
> script. From a command line, I was able to stop the database.
>
> mysqladmin --port=#### --host 127.0.0.1 --user root --password
>
>
>
> From xampp for stop, it uses a script, most interesting it contains logic
> to remove the pid file if it exist. I will write a script.
>
>
>
> The other method for Windows to create a service, then you can use the
> "NET STOP" to stop the service, and "NET START" to start the service.
>
> On your windows machine, go to a command prompt, "net start". It will
> show a list or running services. These are the same services, if you look
> at the process services in Taskman. Linux/Unix uses "ps".
>
>
>
> For the Admin, I am using phpmyadmin.
>
>
>
> I will connect later.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
> GUI Builder Tribe
>
> DB Tribe
>
>
>
>
>
> On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> Efrem
>
>
>
> I am using NetBeans 8.2 on a Windows 10 64-bit PC.
>
>
>
> The Java version I have is 9.0.4 64-bit.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 14 18
>
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, I will try it. There are several methods to configure the
> start and stop process and it is platform dependent.
>
>
>
> You can use configuration files or scripts.
>
>
>
> I will get back to you later. I am working now and will resume this
> later.
>
>
>
> What is your configuration again and platform? I have Windows, MacOS,
> Linux 64-bit, and Linux 32-bit
>
>
>
> The other information I sent was from my Windows system.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
>
>
> On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
>
>
>
>
>
>
>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin, send a copy of you Admin property page
I think the best way to manage the service depends on its functionality.
Windows is not as nice for scripting as 'bash', PowerShell has the
equivalent power as DOS batch is limited.
Efrem
On Thu, Apr 26, 2018 at 11:23 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> Efrem
>
>
>
> Unfortunately that did not work. The messages displayed were slightly
> different as you can see:
>
>
>
>
>
> Oddly enough the file C:\ProgramData\MySQL\MySQL Server 8.0\Data\ibdata1
> has Windows read and write permissions.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 16 11
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin:
>
>
>
> To start try this:
>
> Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
>
> Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL
> Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
>
>
>
> If you are using the default port, it defaults to 3306.
>
>
>
> To stop, use Disconnect. I will have to create a custom stop such as a
> script. From a command line, I was able to stop the database.
>
> mysqladmin --port=#### --host 127.0.0.1 --user root --password
>
>
>
> From xampp for stop, it uses a script, most interesting it contains logic
> to remove the pid file if it exist. I will write a script.
>
>
>
> The other method for Windows to create a service, then you can use the
> "NET STOP" to stop the service, and "NET START" to start the service.
>
> On your windows machine, go to a command prompt, "net start". It will
> show a list or running services. These are the same services, if you look
> at the process services in Taskman. Linux/Unix uses "ps".
>
>
>
> For the Admin, I am using phpmyadmin.
>
>
>
> I will connect later.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
> GUI Builder Tribe
>
> DB Tribe
>
>
>
>
>
> On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> Efrem
>
>
>
> I am using NetBeans 8.2 on a Windows 10 64-bit PC.
>
>
>
> The Java version I have is 9.0.4 64-bit.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 14 18
>
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, I will try it. There are several methods to configure the
> start and stop process and it is platform dependent.
>
>
>
> You can use configuration files or scripts.
>
>
>
> I will get back to you later. I am working now and will resume this
> later.
>
>
>
> What is your configuration again and platform? I have Windows, MacOS,
> Linux 64-bit, and Linux 32-bit
>
>
>
> The other information I sent was from my Windows system.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
>
>
> On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
>
>
>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin, send a copy of you Admin property page
I think the best way to manage the service depends on its functionality.
Windows is not as nice for scripting as 'bash', PowerShell has the
equivalent power as DOS batch is limited.
Efrem
On Thu, Apr 26, 2018 at 11:23 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> Efrem
>
>
>
> Unfortunately that did not work. The messages displayed were slightly
> different as you can see:
>
>
>
>
>
> Oddly enough the file C:\ProgramData\MySQL\MySQL Server 8.0\Data\ibdata1
> has Windows read and write permissions.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 16 11
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin:
>
>
>
> To start try this:
>
> Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
>
> Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL
> Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
>
>
>
> If you are using the default port, it defaults to 3306.
>
>
>
> To stop, use Disconnect. I will have to create a custom stop such as a
> script. From a command line, I was able to stop the database.
>
> mysqladmin --port=#### --host 127.0.0.1 --user root --password
>
>
>
> From xampp for stop, it uses a script, most interesting it contains logic
> to remove the pid file if it exist. I will write a script.
>
>
>
> The other method for Windows to create a service, then you can use the
> "NET STOP" to stop the service, and "NET START" to start the service.
>
> On your windows machine, go to a command prompt, "net start". It will
> show a list or running services. These are the same services, if you look
> at the process services in Taskman. Linux/Unix uses "ps".
>
>
>
> For the Admin, I am using phpmyadmin.
>
>
>
> I will connect later.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
> GUI Builder Tribe
>
> DB Tribe
>
>
>
>
>
> On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> Efrem
>
>
>
> I am using NetBeans 8.2 on a Windows 10 64-bit PC.
>
>
>
> The Java version I have is 9.0.4 64-bit.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 14 18
>
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, I will try it. There are several methods to configure the
> start and stop process and it is platform dependent.
>
>
>
> You can use configuration files or scripts.
>
>
>
> I will get back to you later. I am working now and will resume this
> later.
>
>
>
> What is your configuration again and platform? I have Windows, MacOS,
> Linux 64-bit, and Linux 32-bit
>
>
>
> The other information I sent was from my Windows system.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
>
>
> On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
>
>
>
>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
Efrem
Unfortunately that did not work. The messages displayed were slightly different as you can see:
[cid:image008.png@01D3DD7A.E3639820]
Oddly enough the file C:\ProgramData\MySQL\MySQL Server 8.0\Data\ibdata1 has Windows read and write permissions.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 16 11
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@oracle.com>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin:
To start try this:
Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
If you are using the default port, it defaults to 3306.
To stop, use Disconnect. I will have to create a custom stop such as a script. From a command line, I was able to stop the database.
mysqladmin --port=#### --host 127.0.0.1 --user root --password
From xampp for stop, it uses a script, most interesting it contains logic to remove the pid file if it exist. I will write a script.
The other method for Windows to create a service, then you can use the "NET STOP" to stop the service, and "NET START" to start the service.
On your windows machine, go to a command prompt, "net start". It will show a list or running services. These are the same services, if you look at the process services in Taskman. Linux/Unix uses "ps".
For the Admin, I am using phpmyadmin.
I will connect later.
Regards,
Efrem McCrimon
GUI Builder Tribe
DB Tribe
On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>> wrote:
Efrem
I am using NetBeans 8.2 on a Windows 10 64-bit PC.
The Java version I have is 9.0.4 64-bit.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 14 18
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@oracle.com>>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin, I will try it. There are several methods to configure the start and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this later.
What is your configuration again and platform? I have Windows, MacOS, Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>> wrote:
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:image009.png@01D3DD7A.E3639820]
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 <ef...@gmail.com>>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ma...@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:image010.png@01D3DD7A.E3639820]
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:image011.png@01D3DD7A.E3639820]
And
[cid:image012.png@01D3DD7A.E3639820]
The results is:
[cid:image013.png@01D3DD7A.E3639820]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image014.png@01D3DD7A.E3639820]
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:image015.png@01D3DD7A.E3639820]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
Efrem
Unfortunately that did not work. The messages displayed were slightly different as you can see:
[cid:image008.png@01D3DD7A.E3639820]
Oddly enough the file C:\ProgramData\MySQL\MySQL Server 8.0\Data\ibdata1 has Windows read and write permissions.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 16 11
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@oracle.com>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin:
To start try this:
Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
If you are using the default port, it defaults to 3306.
To stop, use Disconnect. I will have to create a custom stop such as a script. From a command line, I was able to stop the database.
mysqladmin --port=#### --host 127.0.0.1 --user root --password
From xampp for stop, it uses a script, most interesting it contains logic to remove the pid file if it exist. I will write a script.
The other method for Windows to create a service, then you can use the "NET STOP" to stop the service, and "NET START" to start the service.
On your windows machine, go to a command prompt, "net start". It will show a list or running services. These are the same services, if you look at the process services in Taskman. Linux/Unix uses "ps".
For the Admin, I am using phpmyadmin.
I will connect later.
Regards,
Efrem McCrimon
GUI Builder Tribe
DB Tribe
On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>> wrote:
Efrem
I am using NetBeans 8.2 on a Windows 10 64-bit PC.
The Java version I have is 9.0.4 64-bit.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 14 18
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@oracle.com>>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin, I will try it. There are several methods to configure the start and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this later.
What is your configuration again and platform? I have Windows, MacOS, Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>> wrote:
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:image009.png@01D3DD7A.E3639820]
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 <ef...@gmail.com>>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ma...@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:image010.png@01D3DD7A.E3639820]
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:image011.png@01D3DD7A.E3639820]
And
[cid:image012.png@01D3DD7A.E3639820]
The results is:
[cid:image013.png@01D3DD7A.E3639820]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image014.png@01D3DD7A.E3639820]
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:image015.png@01D3DD7A.E3639820]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin:
To start try this:
Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL
Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
If you are using the default port, it defaults to 3306.
To stop, use Disconnect. I will have to create a custom stop such as a
script. From a command line, I was able to stop the database.
mysqladmin --port=#### --host 127.0.0.1 --user root --password
From xampp for stop, it uses a script, most interesting it contains logic
to remove the pid file if it exist. I will write a script.
The other method for Windows to create a service, then you can use the "NET
STOP" to stop the service, and "NET START" to start the service.
On your windows machine, go to a command prompt, "net start". It will show
a list or running services. These are the same services, if you look at
the process services in Taskman. Linux/Unix uses "ps".
For the Admin, I am using phpmyadmin.
I will connect later.
Regards,
Efrem McCrimon
GUI Builder Tribe
DB Tribe
On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> Efrem
>
>
>
> I am using NetBeans 8.2 on a Windows 10 64-bit PC.
>
>
>
> The Java version I have is 9.0.4 64-bit.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 14 18
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, I will try it. There are several methods to configure the
> start and stop process and it is platform dependent.
>
>
>
> You can use configuration files or scripts.
>
>
>
> I will get back to you later. I am working now and will resume this
> later.
>
>
>
> What is your configuration again and platform? I have Windows, MacOS,
> Linux 64-bit, and Linux 32-bit
>
>
>
> The other information I sent was from my Windows system.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
>
>
> On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin:
To start try this:
Path to start: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
Arguments: --console --port 3310 --datadir="C:\\ProgramData\\MySQL\\MySQL
Server 8.0\\Data\\" --default-authentication-plugin=mysql_native_password
If you are using the default port, it defaults to 3306.
To stop, use Disconnect. I will have to create a custom stop such as a
script. From a command line, I was able to stop the database.
mysqladmin --port=#### --host 127.0.0.1 --user root --password
From xampp for stop, it uses a script, most interesting it contains logic
to remove the pid file if it exist. I will write a script.
The other method for Windows to create a service, then you can use the "NET
STOP" to stop the service, and "NET START" to start the service.
On your windows machine, go to a command prompt, "net start". It will show
a list or running services. These are the same services, if you look at
the process services in Taskman. Linux/Unix uses "ps".
For the Admin, I am using phpmyadmin.
I will connect later.
Regards,
Efrem McCrimon
GUI Builder Tribe
DB Tribe
On Thu, Apr 26, 2018 at 9:20 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> Efrem
>
>
>
> I am using NetBeans 8.2 on a Windows 10 64-bit PC.
>
>
>
> The Java version I have is 9.0.4 64-bit.
>
>
>
> Many thanks
>
>
>
> Martin O’Shea.
>
>
>
> *From:* Efrem Mc <ef...@gmail.com>
> *Sent:* 26 Apr 2018 14 18
>
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@oracle.com>; Paul Franz <
> paul.franz@oracle.com>
> *Subject:* Re: Unable to start MySQL in NetBeans
>
>
>
> Hi Martin, I will try it. There are several methods to configure the
> start and stop process and it is platform dependent.
>
>
>
> You can use configuration files or scripts.
>
>
>
> I will get back to you later. I am working now and will resume this
> later.
>
>
>
> What is your configuration again and platform? I have Windows, MacOS,
> Linux 64-bit, and Linux 32-bit
>
>
>
> The other information I sent was from my Windows system.
>
>
>
> Regards,
>
>
>
> Efrem McCrimon
>
>
>
>
>
> On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
> wrote:
>
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
>
>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
Efrem
I am using NetBeans 8.2 on a Windows 10 64-bit PC.
The Java version I have is 9.0.4 64-bit.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 14 18
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@oracle.com>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin, I will try it. There are several methods to configure the start and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this later.
What is your configuration again and platform? I have Windows, MacOS, Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>> wrote:
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:image001.png@01D3DD69.B2808CB0]
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 <ef...@gmail.com>>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ma...@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:image002.png@01D3DD69.B2808CB0]
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:image003.png@01D3DD69.B2808CB0]
And
[cid:image004.png@01D3DD69.B2808CB0]
The results is:
[cid:image005.png@01D3DD69.B2808CB0]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image006.png@01D3DD69.B2808CB0]
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:image007.png@01D3DD69.B2808CB0]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
Efrem
I am using NetBeans 8.2 on a Windows 10 64-bit PC.
The Java version I have is 9.0.4 64-bit.
Many thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 14 18
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@oracle.com>
Subject: Re: Unable to start MySQL in NetBeans
Hi Martin, I will try it. There are several methods to configure the start and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this later.
What is your configuration again and platform? I have Windows, MacOS, Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>> wrote:
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:image001.png@01D3DD69.B2808CB0]
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 <ef...@gmail.com>>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>>
Cc: users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>; Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ma...@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:image002.png@01D3DD69.B2808CB0]
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:image003.png@01D3DD69.B2808CB0]
And
[cid:image004.png@01D3DD69.B2808CB0]
The results is:
[cid:image005.png@01D3DD69.B2808CB0]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image006.png@01D3DD69.B2808CB0]
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:image007.png@01D3DD69.B2808CB0]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin, I will try it. There are several methods to configure the start
and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this
later.
What is your configuration again and platform? I have Windows, MacOS,
Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Martin, I will try it. There are several methods to configure the start
and stop process and it is platform dependent.
You can use configuration files or scripts.
I will get back to you later. I am working now and will resume this
later.
What is your configuration again and platform? I have Windows, MacOS,
Linux 64-bit, and Linux 32-bit
The other information I sent was from my Windows system.
Regards,
Efrem McCrimon
On Thu, Apr 26, 2018 at 8:35 AM, Martin O'Shea <ma...@outlook.com>
wrote:
> 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:
>
>
>
>
>
> 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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 13 13
> *To:* Martin O'Shea <ma...@outlook.com>
> *Cc:* users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>;
> Jiří Kovalský <ji...@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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
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 <ef...@gmail.com>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@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 <ma...@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 <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
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 <ef...@gmail.com>
Sent: 26 Apr 2018 13 13
To: Martin O'Shea <ma...@outlook.com>
Cc: users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>; Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@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 <ma...@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 <ef...@gmail.com>>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>>; users@netbeans.apache.org<ma...@netbeans.apache.org>; netcat <ne...@netbeans.apache.org>>
Cc: Jiří Kovalský <ji...@oracle.com>>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
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 <ma...@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 <ef...@gmail.com>
> *Sent:* 26 Apr 2018 12 11
> *To:* Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org;
> netcat <ne...@netbeans.apache.org>
> *Cc:* Jiří Kovalský <ji...@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 <ef...@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 <ef...@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 <ef...@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.
> >>>
> >>>
>
>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
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:image004.png@01D3DD59.E3FB9560]
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:image002.png@01D3DD59.51B2DA60]
And
[cid:image003.png@01D3DD59.51B2DA60]
The results is:
[cid:image001.png@01D3DD59.1872F050]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image005.png@01D3DD59.E3FB9560]
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:image006.png@01D3DD59.E3FB9560]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>
Cc: Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>
RE: Unable to start MySQL in NetBeans
Posted by Martin O'Shea <ma...@outlook.com>.
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:image004.png@01D3DD59.E3FB9560]
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:image002.png@01D3DD59.51B2DA60]
And
[cid:image003.png@01D3DD59.51B2DA60]
The results is:
[cid:image001.png@01D3DD59.1872F050]
Then, if I try to start MySQL in NetBeans from the context menu, I receive the prompt:
[cid:image005.png@01D3DD59.E3FB9560]
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:image006.png@01D3DD59.E3FB9560]
Have you any idea about these at all?
Thanks
Martin O’Shea.
From: Efrem Mc <ef...@gmail.com>
Sent: 26 Apr 2018 12 11
To: Martin O'Shea <ma...@outlook.com>; users@netbeans.apache.org; netcat <ne...@netbeans.apache.org>
Cc: Jiří Kovalský <ji...@oracle.com>; Paul Franz <pa...@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 <ef...@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 <ef...@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 <ef...@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 <ma...@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.
>>>
>>>