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 <martin_os...@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 <efrem...@gmail.com> > *Sent:* 26 Apr 2018 13 13 > *To:* Martin O'Shea <martin_os...@outlook.com> > *Cc:* us...@netbeans.apache.org; netcat <netcat@netbeans.apache.org>; > Jiří Kovalský <jiri.koval...@oracle.com>; Paul Franz < > paul.fr...@oracle.com> > > *Subject:* Re: Unable to start MySQL in NetBeans > > > > Okay, I did not mention this but I removed the last part of the connection > string on the driver. > > > > Old string: jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior= > convertToNull > > > > New string: jdbc:mysql://localhost:3310 > > > > I am using port 3310 for MySQL 8.0.11. > > > > > > After connecting, I noticed the system changed a setting to: > > > > > > jdbc:mysql://localhost:3310/mysql?zeroDateTimeBehavior=convertToNull > > Display name: > jdbc:mysql://localhost:3310/dbtest?zeroDateTimeBehavior=convertToNull > [root on Default schema] > > > > This will show once you connect to a database in my case I am connected > the dbtest > > Database URL: jdbc:mysql://localhost:3310/dbtest?zeroDateTimeBehavior= > convertToNull > > > > > > > > On Thu, Apr 26, 2018 at 7:27 AM, Martin O'Shea <martin_os...@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 <efrem...@gmail.com> > *Sent:* 26 Apr 2018 12 11 > *To:* Martin O'Shea <martin_os...@outlook.com>; us...@netbeans.apache.org; > netcat <netcat@netbeans.apache.org> > *Cc:* Jiří Kovalský <jiri.koval...@oracle.com>; Paul Franz < > paul.fr...@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 <efrem...@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 <efrem...@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 <efrem...@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_os...@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. > >>> > >>> > > >
