Re: Unable to start MySQL in NetBeans

[Efrem Mc]

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 <martin_os...@outlook.com>
wrote:

> Again, many thanks.
>
>
>
> *From:* Efrem Mc <efrem...@gmail.com>
> *Sent:* 26 Apr 2018 20 01
>
> *To:* Martin O'Shea <martin_os...@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 <martin_os...@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 <efrem...@gmail.com>
> *Sent:* 26 Apr 2018 19 47
> *To:* Martin O'Shea <martin_os...@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 <efrem...@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 <martin_os...@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 <efrem...@gmail.com>
> *Sent:* 26 Apr 2018 16 11
> *To:* Martin O'Shea <martin_os...@outlook.com>
>
> *Cc:* users@netbeans.apache.org; netcat <net...@netbeans.apache.org>;
> Jiří­ Kovalský <jiri.koval...@oracle.com>; Paul Franz <
> paul.fr...@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 

Re: Unable to start MySQL in NetBeans

[Efrem Mc]

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: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: >> (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.
> >>>
> >>>
>

Re: Unable to start MySQL in NetBeans

[Efrem Mc]

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  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-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: [GUI Editor]

[Efrem Mc]

Thank you Chuck, I never used that  option of pay attention to it.
Thanks for pointing that out.  I just checked NB 9.0 406 build is it
is already on by Default.

Thanks once again Chuck!

Efrem

On Tue, Apr 17, 2018 at 10:20 PM, Chuck Davis  wrote:
> Tools->Options->Java->GUI Builder   Check the box "Show Assistant".  I think
> this is that for which you are looking.
>
> On Tue, Apr 17, 2018 at 5:55 PM, Joseph Huber  wrote:
>>
>> Hello!
>>
>>
>>
>> In the NetBeans GUI editor, when on the “Design” tab, there is normally a
>> help bar (with a light bulb icon on the left side and an “X” on the right
>> side) above the form being edited.  Somehow I clicked the “X” or somehow did
>> something else to remove the help bar.
>>
>>
>>
>> I cannot seem to find a setting to re-enable the help bar.  I have done
>> the toolbar reset, and the window reset, but this did not bring the help bar
>> back.  Does anyone know how to get this help bar back?  I am using NetBeans
>> 8.2
>>
>>
>>
>> Thank You!
>>
>>
>>
>> Joe Huber
>>
>>
>
>

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: [GUI Editor]

[Efrem Mc]

Hi, I'm not sure, but this is what I have on the bar for NB 8.2

Edit the image and draw a circle to indicate what you are talking about.

Thanks

Efrem

On Tue, Apr 17, 2018 at 8:55 PM, Joseph Huber  wrote:
> Hello!
>
>
>
> In the NetBeans GUI editor, when on the “Design” tab, there is normally a
> help bar (with a light bulb icon on the left side and an “X” on the right
> side) above the form being edited.  Somehow I clicked the “X” or somehow did
> something else to remove the help bar.
>
>
>
> I cannot seem to find a setting to re-enable the help bar.  I have done the
> toolbar reset, and the window reset, but this did not bring the help bar
> back.  Does anyone know how to get this help bar back?  I am using NetBeans
> 8.2
>
>
>
> Thank You!
>
>
>
> Joe Huber
>
>

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: C++ in Netbeans on Windows requires qmake.

[Efrem Mc]

Thank you for that clarification.  I used both Cygwin and MinGW for
Netbeans 8.2 - NB 6.1 on Windows.

Thanks Banepa to set the record straight!

Efrem

On Tue, Mar 27, 2018 at 1:23 PM, Валера Солдатов  wrote:
> 27.03.2018 5:25, A Z пишет:
>
> I am a 64 bit Windows 10 user.  I have learned that I cannot build my c++
> projects without qmake working.  However, I have learned
> that the only way to obtain this from Qt seems to be via a huge 2Gb
> download (or even larger).  Can someone please reply back to me
> with a compatible, much smaller, version of qmake so that
> I can build my c++ code using the c++ plugin for netbeans, please?
>
> Usually qmake is not needed in NetBeans. Only if you use Qt framework
> NetBeans will use qmake in order to build project. Usually NetBeans uses
> compilers and tools from Cygwin, MinGW or MSYS2.

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: C++ in Netbeans on Windows requires qmake.

[Efrem Mc]

Sorry for the multiple emails.  Here is a link to https://cygwin.com/index.html

I recall the installation took a long time.



On Tue, Mar 27, 2018 at 3:32 AM, Efrem Mc <efrem...@gmail.com> wrote:
> I have not tested this within NetBeans.  I used either CYGWIN in the
> past with NetBeans.  Dev-CPP uses a different library, MinGW.
>
> You might have to use Qt.
>
> Regards,
>
>
>
> On Tue, Mar 27, 2018 at 3:06 AM, Efrem Mc <efrem...@gmail.com> wrote:
>> Hi, I am not sure what you are compiling that requires qmake.
>>
>> qmake is available from Qt.   I use version 5.6, 5.7, and 5.8.  I
>> believe 5.10 is out now.
>> Source: https://www.qt.io/download
>>
>> I use a basic CPP /C++ package named Dev-C++
>> source: https://sourceforge.net/projects/orwelldevcpp/?source=navbar
>>
>> I use Dev-C++ for doing basic C++ programming on Windows and it uses
>> just make.  It is a small package and does both 32bit/64bit.
>>
>>
>> Regards,
>>
>> Efrem Mc
>>
>>
>> On Mon, Mar 26, 2018 at 10:25 PM, A Z <powerus...@live.com.au> wrote:
>>> I am a 64 bit Windows 10 user.  I have learned that I cannot build my c++
>>> projects without qmake working.  However, I have learned
>>> that the only way to obtain this from Qt seems to be via a huge 2Gb
>>> download (or even larger).  Can someone please reply back to me
>>> with a compatible, much smaller, version of qmake so that
>>> I can build my c++ code using the c++ plugin for netbeans, please?

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: C++ in Netbeans on Windows requires qmake.

[Efrem Mc]

I have not tested this within NetBeans.  I used either CYGWIN in the
past with NetBeans.  Dev-CPP uses a different library, MinGW.

You might have to use Qt.

Regards,



On Tue, Mar 27, 2018 at 3:06 AM, Efrem Mc <efrem...@gmail.com> wrote:
> Hi, I am not sure what you are compiling that requires qmake.
>
> qmake is available from Qt.   I use version 5.6, 5.7, and 5.8.  I
> believe 5.10 is out now.
> Source: https://www.qt.io/download
>
> I use a basic CPP /C++ package named Dev-C++
> source: https://sourceforge.net/projects/orwelldevcpp/?source=navbar
>
> I use Dev-C++ for doing basic C++ programming on Windows and it uses
> just make.  It is a small package and does both 32bit/64bit.
>
>
> Regards,
>
> Efrem Mc
>
>
> On Mon, Mar 26, 2018 at 10:25 PM, A Z <powerus...@live.com.au> wrote:
>> I am a 64 bit Windows 10 user.  I have learned that I cannot build my c++
>> projects without qmake working.  However, I have learned
>> that the only way to obtain this from Qt seems to be via a huge 2Gb
>> download (or even larger).  Can someone please reply back to me
>> with a compatible, much smaller, version of qmake so that
>> I can build my c++ code using the c++ plugin for netbeans, please?

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Re: C++ in Netbeans on Windows requires qmake.

[Efrem Mc]

Hi, I am not sure what you are compiling that requires qmake.

qmake is available from Qt.   I use version 5.6, 5.7, and 5.8.  I
believe 5.10 is out now.
Source: https://www.qt.io/download

I use a basic CPP /C++ package named Dev-C++
source: https://sourceforge.net/projects/orwelldevcpp/?source=navbar

I use Dev-C++ for doing basic C++ programming on Windows and it uses
just make.  It is a small package and does both 32bit/64bit.


Regards,

Efrem Mc


On Mon, Mar 26, 2018 at 10:25 PM, A Z <powerus...@live.com.au> wrote:
> I am a 64 bit Windows 10 user.  I have learned that I cannot build my c++
> projects without qmake working.  However, I have learned
> that the only way to obtain this from Qt seems to be via a huge 2Gb
> download (or even larger).  Can someone please reply back to me
> with a compatible, much smaller, version of qmake so that
> I can build my c++ code using the c++ plugin for netbeans, please?

-
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists