MySql in NetBeans 5.0

[javagal]

I have installed Netbeans 5.0 on my PC,
I have installed mysql 5.0 on my PC,
installed a mysql service on pc but this service is not getting started ,
Please help me.

[JavaBean]

As far as i remember, it had an option to install it as a service. You might need to restart to see it started!

If it does not work, then this documentation may help:

MySQL AB :: MySQL 5.0 Reference Manual :: 2.4.8.11 Starting MySQL as a Windows Service

[javagal]

Connecting to a MySQL Database in NetBeans IDE

I refered to this manual starting from download and the configuration wizard allow me to install the service.

The last option is to run it by clicking EXECUTE button..and there I got the error. So tried with command prompt ,

" sc query MySQL " shows me that service is available on machine but its stopped.

so tried to start it using command :
"sc start MySQL"

but finally it gave me error

I will copy the exact error once I reach home as trying on my home PC.

Please tell me if some other settings to check..

[JavaBean]

Let us know the error when you reach home. I will look at that manual after i see the error.

[javagal]

Hi... Look below...I have copied the results I am getting....
First command is showing that the service is running, so I tried to start the service but
C:\Documents and Settings>sc query MySQL

SERVICE_NAME: MySQL
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0


C:\Documents and Settings>sc start MySQL
[SC] StartService FAILED 2:

The system cannot find the file specified.


I also tried to start the service from "(Start > Control Panel > Administrative Tools > Services). " but it gives a error "Could not start the service on local computer,The system cannot find the file specified. "

I am not able to understand this..

Please please help me....

[JavaBean]

Did you be able to solve your problem? As far as i see this is a mysql problem (not related to netbeans). I guess you had some previous installation or installed the service wrongly. (The executable to mysql service seems to be not found.) I think the best way is to try uninstalling previous mysql instances and reinstalling mysql again.

[javagal]

yes I agree that its a pure mysql problem.

Yesterday I found that one mysql service is already installed on my compi so

the service for mysql 5.0 is not getting installed.

look at this msg :

"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --install

C:\Documents and Settings\Home>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysq
ld" --install
The service already exists!
The current server installed: C:/mysql/bin/mysqld-nt.exe

Now I need to figure out, how to uninstall that service..
lets see....