CRUD Tutorial - NetBean MySql Shutdown Properties

[sweeny]

Unable to shutdown MySql v 5.0 in NetBeans v6.5 on XP.

In the NetBean -> Services -> Databases -> MySql Server -> Properties
arguments given have been

1. -u root -p shutdown

2. -u root stop

3. -u root -p stop

4. -u root shutdown

All of which have not stopped the server.

Also tried passing in the root user password

5. -u root -pRootPassword stop

This sees the IDE go into a infinite shutdown process.

The tutorials on configuring MySql for NetBeans have also been considered with no success
http://www.netbeans.org/kb/docs/php/wish-list-lesson1.html

Screen shots are attached.

NOTE: When "-u root stop" arguments are given they generate error message as per attached img "NetBeans [u root stop]". This may give better insight!

Any pointers or suggested articles would greatly appreciated.


[/img]

[bstack]

try it from the xp command prompt and see what messages you get.

start->run->cmd

> mysqladmin -u root --password=PASSWD shutdown

[sweeny]

Thank you for the prompt reply.

A fix has been found -

1.Adjust the localhost firewall to allow TCP Ports 3306 and 10061.

2.The arguments required when using root user with a password are
"-u root -pRootPassword shutdown" and this is without the quotes and without any trailing space between "-p" and the root password.

3.Right click on MySql service in NetBeans, select "stop" and it does!

There is a good reference article out there on the MySql developer site, which offers insight into how to install this server as a windows service, could be worth checking out.

http://mirror.it.swin.edu.au/mysql/doc/refman/5.0/en/wind

[65dos]

how did you fix that problem? because I still cannot stop mysql server from netbeans, btw, i tried your solution, although I'm not sure what do you mean with "1.Adjust the localhost firewall to allow TCP Ports 3306 and 10061.

im using windows vista.