You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@netbeans.apache.org by Martin O'Shea <ma...@outlook.com> on 2018/04/25 14:59:43 UTC
Unable to start MySQL in NetBeans
Hello
I have just upgraded my installation of MySQL from 5.x to 8.0.11 but find that in NetBeans 8.2 when I try to start MySQL from the Services tab in the IDE, that I am given messages:
2018-04-25T13:46:12.356385Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 3468
mysqld: Table 'mysql.plugin' doesn't exist
2018-04-25T13:46:15.088859Z 0 [ERROR] [MY-010735] [Server] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-25T13:46:15.576408Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-04-25T13:46:16.729741Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-04-25T13:46:16.735829Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Unknown error
2018-04-25T13:46:16.736018Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2018-04-25T13:46:16.736247Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-04-25T13:46:18.039621Z 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 MySQL 8.0.11 is working correctly and reports no errors of its own.
Is NetBeans 8.2 not compatible with MySQL 8.0.11?
I have added the mysql-connector-java-8.0.11.jar as a NetBeans plug-in. However, I can only get Java-based applications in NetBeans to talk to MySQL by adding the .jar file to the version of Apache Tomcat that is used, and to the lib folder of the applications themselves.
Thanks
Martin O'Shea.
Re: Unable to start MySQL in NetBeans
Posted by Efrem Mc <ef...@gmail.com>.
Hi Paul and Martin, I just responded to users@netbeans....
He needs an updated driver file which depends on the authentication
method being used. I tested this with NB 8.2 and now about to test it
with NB 9.0 beta.
Regards,
Efrem McCrimon
GUI Builder Tribe
DB Tribe
On Wed, Apr 25, 2018 at 11:05 AM, Paul Franz <pa...@oracle.com> wrote:
> Martin,
> Did you do as it asked? (i.e. "run mysql_upgrade" to create the mysql.plugin
> table)
>
> Paul Franz
> Senior Principal Applications Engineer
> Oracle Transportation Management
> Phone #: 1-610-729-3347
> Skype Id: PaulPFranz
>
>
> On 25 Apr 2018, at 10:59, Martin O'Shea wrote:
>
> Hello
>
>
>
> I have just upgraded my installation of MySQL from 5.x to 8.0.11 but find
> that in NetBeans 8.2 when I try to start MySQL from the Services tab in the
> IDE, that I am given messages:
>
>
>
> 2018-04-25T13:46:12.356385Z 0 [System] [MY-010116] [Server] C:\Program
> Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as
> process 3468
>
> mysqld: Table 'mysql.plugin' doesn't exist
>
> 2018-04-25T13:46:15.088859Z 0 [ERROR] [MY-010735] [Server] Can't open the
> mysql.plugin table. Please run mysql_upgrade to create it.
>
> 2018-04-25T13:46:15.576408Z 0 [Warning] [MY-010015] [Repl] Gtid table is not
> ready to be used. Table 'mysql.gtid_executed' cannot be opened.
>
> 2018-04-25T13:46:16.729741Z 0 [Warning] [MY-010068] [Server] CA certificate
> ca.pem is self signed.
>
> 2018-04-25T13:46:16.735829Z 0 [ERROR] [MY-010262] [Server] Can't start
> server: Bind on TCP/IP port: Unknown error
>
> 2018-04-25T13:46:16.736018Z 0 [ERROR] [MY-010257] [Server] Do you already
> have another mysqld server running on port: 3306 ?
>
> 2018-04-25T13:46:16.736247Z 0 [ERROR] [MY-010119] [Server] Aborting
>
> 2018-04-25T13:46:18.039621Z 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 MySQL 8.0.11 is working correctly and reports no errors of its own.
>
>
>
> Is NetBeans 8.2 not compatible with MySQL 8.0.11?
>
>
>
> I have added the mysql-connector-java-8.0.11.jar as a NetBeans plug-in.
> However, I can only get Java-based applications in NetBeans to talk to MySQL
> by adding the .jar file to the version of Apache Tomcat that is used, and to
> the lib folder of the applications themselves.
>
>
>
> Thanks
>
>
>
> Martin O’Shea.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@netbeans.apache.org
For additional commands, e-mail: users-help@netbeans.apache.org
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
Re: Unable to start MySQL in NetBeans
Posted by Paul Franz <pa...@oracle.com>.
Martin,
Did you do as it asked? (i.e. "run mysql_upgrade" to create the
mysql.plugin table)
Paul Franz
Senior Principal Applications Engineer
Oracle Transportation Management
Phone #: 1-610-729-3347
Skype Id: PaulPFranz
On 25 Apr 2018, at 10:59, Martin O'Shea wrote:
> Hello
>
> I have just upgraded my installation of MySQL from 5.x to 8.0.11 but
> find that in NetBeans 8.2 when I try to start MySQL from the Services
> tab in the IDE, that I am given messages:
>
> 2018-04-25T13:46:12.356385Z 0 [System] [MY-010116] [Server] C:\Program
> Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting
> as process 3468
> mysqld: Table 'mysql.plugin' doesn't exist
> 2018-04-25T13:46:15.088859Z 0 [ERROR] [MY-010735] [Server] Can't open
> the mysql.plugin table. Please run mysql_upgrade to create it.
> 2018-04-25T13:46:15.576408Z 0 [Warning] [MY-010015] [Repl] Gtid table
> is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
> 2018-04-25T13:46:16.729741Z 0 [Warning] [MY-010068] [Server] CA
> certificate ca.pem is self signed.
> 2018-04-25T13:46:16.735829Z 0 [ERROR] [MY-010262] [Server] Can't start
> server: Bind on TCP/IP port: Unknown error
> 2018-04-25T13:46:16.736018Z 0 [ERROR] [MY-010257] [Server] Do you
> already have another mysqld server running on port: 3306 ?
> 2018-04-25T13:46:16.736247Z 0 [ERROR] [MY-010119] [Server] Aborting
> 2018-04-25T13:46:18.039621Z 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 MySQL 8.0.11 is working correctly and reports no errors of its
> own.
>
> Is NetBeans 8.2 not compatible with MySQL 8.0.11?
>
> I have added the mysql-connector-java-8.0.11.jar as a NetBeans
> plug-in. However, I can only get Java-based applications in NetBeans
> to talk to MySQL by adding the .jar file to the version of Apache
> Tomcat that is used, and to the lib folder of the applications
> themselves.
>
> Thanks
>
> Martin O'Shea.