How to check whether mysql service is running or not

Question

0.00/5 (No votes)

See more:

Hello...
I wanna ensure for mysql service when my app is first time trying to fetch data from mysql...Can u suggest me anything...

Thanks in advance...

Posted 21-Mar-11 20:17pm

krishna kishore58

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-03-21T20:26:00

Solution 1

Here is a general way to know whether service is running or not

C#

public bool CheckIfServiceIsRunning(string serviceName)
{
    ServiceProcess.ServiceController mySC = new ServiceProcess.ServiceController(serviceName);
    if (mySC.Status == ServiceProcess.ServiceControllerStatus.Running) {
        // Service already running
        return true;
    }
    else {
        return false;
    }
}

Posted 21-Mar-11 20:26pm

Prerak Patel

Comments

OriginalGriff 22-Mar-11 3:23am

Bear in mind that this will only work if the MySql instance is running on the local machine...

Prerak Patel 22-Mar-11 3:25am

or you can use mySC.MachineName if you have sufficient rights.

Wayne Gaylard 22-Mar-11 3:27am

Well, that is what the OP wants to check. This method will return true only if MySql Server is running, else it will return false, and so the user can deal with that.

Wayne Gaylard 22-Mar-11 3:25am

Good answer. As the mysql service is called mysqld.exe, you can just call this method CheckIfServiceIsRunning(mysqld.exe).

OriginalGriff · Answer 2 · 2011-03-21T20:30:00

Solution 2

The only way I know of, is to do a trial MySqlConnection.Open in a try..catch block. If an exception is raised, then you cannot connect (or at least, not with that connection string). You can use the MySqlConnection.Ping method, but since that needs an open connection anyway...:laugh:

Posted 21-Mar-11 20:30pm

OriginalGriff