Facing an error by starting and stopping mysql service in command line mode

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • santhanalakshmi
    New Member
    • May 2009
    • 147

    Facing an error by starting and stopping mysql service in command line mode

    Hi,

    I want to start the mysql services by manually in the dos on windows......

    Starting an Mysql Service :

    Code:
    [B] shell>net start mysql[/B]
    The service name is invalid.

    More help is available by typing NET HELPMSG 2185
    .

    Stopping an Mysql Service :

    Code:
    [B] shell>net stop mysql[/B]
    System error 1060 has occurred

    The specified service does not exist as an installed service.



    Thanks in advance.....
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    Hey.

    Like the error says, the name of the service you are trying to start is invalid. You need to find out the correct name.

    To do that, right click the "My Computer" shortcut in the Start menu, select "Manage", click "Services" in the "Services and applications" group. And then search the list of services until you find the MySQL service.

    Then you can start the service by using that name. It is can sometimes be called "mysql5" or "mysql51", or something like that. Depends on who installed it.

    Comment

    • santhanalakshmi
      New Member
      • May 2009
      • 147

      #3
      I cant able to find out the mysql services name in the "Services and applications" group.........t here is any other possible way to find out .

      Comment

      • santhanalakshmi
        New Member
        • May 2009
        • 147

        #4
        hi,
        i am using Xampp .Mysql services wont be displayed under services.

        Comment

        • Atli
          Recognized Expert Expert
          • Nov 2006
          • 5062

          #5
          You could try the SC command.

          For example, this will list all services:
          [code=text]sc query type= service[/code]

          Comment

          • Atli
            Recognized Expert Expert
            • Nov 2006
            • 5062

            #6
            Originally posted by santhanalakshmi
            hi,
            i am using Xampp .Mysql services wont be displayed under services.
            Ahh I see. XAMPP does not install a service by default, but it does provide .bat files to start it's components. They are located under the XAMPP root dir, typically at "C:\xampp".

            So try:
            [code=text]C:\xampp\mysql_ start.bat[/code]

            Comment

            • santhanalakshmi
              New Member
              • May 2009
              • 147

              #7
              Hi,

              Thanks for your reply......I got it

              Comment

              Working...