Apr 27 2009

Starting MySQL from Command Line on Windows Dedicated Server

Published by at 8:29 pm under Dedicated Servers, Windows Dedicated server, dedicated server hosting

Once you have Installated MySQL server on your Windows Dedicated server you will have to Start MySQL on it. Now, this process can be difficult if you do not follow the steps properly. You can follow the steps given below to Start MySQL from the Windows Command Line :

.NET - Windows Server 2003

Note : These steps can be used to start MySQL on any Version of Windows. There are no such restrictions depending on the version.

1) You will have to start the Console Window which is also known as DOS window to start the mysqld server from the Command Line and enter the Command given below :

C:\> “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld”

2) Path of mysqld on your Windows Dedicated server will depend on the Location on which MySQL is installed on your Windows Dedicated server.

It is also possible for you to stop the working of MySQL Server on your Windows Dedicated server by simply executing the below Command :

C:\> “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin” -u root shutdown

Important : You will have to bring in the mysqladmin with the -p option if the MySQL root user account has a password and you will need to provide the password when it is asked for.

3. Once the above command is used, it brings the MySQL Administrative utility into action and informs mysqladmin to establish a connection with the server and tells it to shutdown.

4. The Default Administrative account in the MySQL System is the MySQL Root user and the command is responsible to connect as the same.

Important : Users in the MySQL Grant system are independent from any other users using logins under Windows.

MySQL Dedicated Web Servers

5. Now, if you are facing a problem with the starting of MySQL then you should check the error logs to see whether the Server dropped any messages there to indicate the main reason for the problem.

6. Most probably, the error logs in Windows Dedicated server is found in the C:\Program Files\MySQL\MySQL Server 5.1\data which is a directory. This file is found with a suffix which is .err (which basically means error).

Note : If the above steps don’t work for you, you can also try to start the server using mysqld –console. If you use this command to start the server, you may get some useful information on the Screen that will help you to get rid of the problem which you are facing.

7. Now, if the above solutions don’t work for you then you will only have a single option available for you which is to start mysqld with the –standalone and debug options.

8. In the above solution, mysqld writes a log file C:\mysqld.trace which should give you the answer why mysqld does not start.

Note : You can also use the Command mysqld –verbose –help to check all the options which is avialable and are supported by mysqld.

68 responses so far

68 Responses to “Starting MySQL from Command Line on Windows Dedicated Server”

  1. # uyxeoqnfkyon 30 Apr 2010 at 10:06 am

    AxK6QS qscjurblfmvo, [url=http://gkcprydunpfl.com/]gkcprydunpfl[/url], [link=http://wqgztwgqllae.com/]wqgztwgqllae[/link], http://bchacecppafy.com/

  2. # nott4everon 15 May 2010 at 12:03 am

    accutane online 6517 phentermine >:-) what is xanax 77061 buy valium holland eoaji phentermine %-D buy phentermine without a prescription %P buy accutane 853

  3. # nickringeron 17 May 2010 at 7:25 pm

    cialis levitra vs egszh cialis 1868 purchase valium %))) acomplia 6166 tramadol 7356

  4. # josheczamon 17 May 2010 at 9:27 pm

    valium 911 carisoprodol 965564 prednisone 111363 ambien problems 5727 vardenafil levitra 1395

  5. # zingebaron 20 May 2010 at 12:50 am

    home insurance coverage cync life insurance 2741 first health insurance >:(( western southern life insurance vtc auto insurance rates kikqvq cheapest auto insurance 9676

  6. # Tommitomitoon 21 May 2010 at 10:50 pm

    what is phentermine 0364 valium 8-((( valium 0893 levitra shemale yasmin lee 658635 online prescription for acomplia :(

  7. # theburnttreeon 24 May 2010 at 5:25 pm

    auto insurance quotes yljp affordable health insurance >:(( auto insurance rates 780 home insurance online quote utah 29856 discount auto insurance 535155

  8. # tehhwhitefoxon 25 May 2010 at 12:21 am

    xanax equivalent valium hpid retin 93251 propecia 9635 buy doxycycline online 501 order accutane online lipa valium lkg buy ambien yecyp

  9. # tenditavon 25 May 2010 at 8:52 am

    phentermine 0976 acomplia jlm apcalis levitra viagra =]]] ultram 7974 buy valium by roch ebn ambien 13844 buy levitra online hoo

  10. # elisabeghellion 25 May 2010 at 9:04 pm

    health insurance rates vyq adova health insurance 9636 auto insurance =[[[ cheap health insurance 46604 cheap auto insurance zsd home insurance rates abawl auto insurance quotes 424280

  11. # xeinshineon 26 May 2010 at 12:33 am

    ambien dangers 8078 accutane 9493 ambien 5835 ultracet qzjf ultram rmnci buy pills tramadol 37464

  12. # lamahbearon 26 May 2010 at 12:33 am

    online accutane 43990 buy 90 ambien online 625747 acomplia 041209 accutane buy 78178 mp3musics %-OO tramadol >:-[[ tramadol 3671

  13. # mergfkton 26 May 2010 at 4:40 am

    aciphex :) )) generic phentermine uefefm retin %-((( levitra cjeiwq valium 23276 phentermine 4816 prednisone ler

  14. # pkingrulzon 27 May 2010 at 6:54 pm

    etna health insurance =-] life insurance quotes lpy individual health insurance plans :]]] homeowner’s insurance =D life insurance rates 88770 cheap home insurance hoz

  15. # erikaPRUPPon 27 May 2010 at 8:09 pm

    propecia 9613 phentermine overnight igvzd phentermine ingredients 219 accutane =( tramadol :-OO online store cialis bvcz

  16. # jellybloveron 28 May 2010 at 12:31 am

    buy propecia usa fvir prednisone buy >:-DD doxycycline %( cialis for sale %((( viagra 8)) prednisone ujozjg

  17. # Jdubstaon 28 May 2010 at 6:39 pm

    valley forge life insurance 1308 home insurance quotes igbas auto insurance 2002 car insurance qoutes >:-(( life of georgia insurance 387567 insurance home hqba

  18. # osutsloveson 28 May 2010 at 11:06 pm

    prednisone no prescription vvuxt ultram mcxcic ambien 674719 buying viagra 2704 prednisone %-]]

  19. # NoTiMe4GaMeZon 29 May 2010 at 4:05 pm

    cheap health insurance 39307 life insurance quotes 242082 life insurance quotes sbw auto insurance ihm mobile home insurance mxwlx auto insurance rates hpcm

  20. # drmaxuton 30 May 2010 at 1:30 am

    tramadol 619785 retin 8701 propecia yice valium epm buy prednisone 12575 prednisone online %-[[[ levitra viagra vs cdr

  21. # DrawingLordon 30 May 2010 at 4:23 am

    valium :-O viagra gey purchase prednisone asu tramadol 45492 what is doxycycline used to treat 099216 doxycycline >:-OOO

  22. # EbonyVeiledon 30 May 2010 at 6:28 pm

    life insurance quotes 37804 auto insurance quotes 86730 discount auto insurance lqcpix life insurance rates 9450 life insurance policies 626955 homeowner’s insurance 887332

  23. # LogicJimon 31 May 2010 at 2:19 am

    viagra dtnrqn xanax 468665 valium crwuo acomplia and canadian pharmacies =OOO doxycycline %-PP

  24. # Pharmb396on 31 May 2010 at 5:27 am

    Hello! dddkeke interesting dddkeke site!

  25. # Pharme922on 31 May 2010 at 5:27 am

    Very nice site! cheap viagra

  26. # Pharmg973on 31 May 2010 at 5:27 am

    Very nice site! [url=http://oieypxa.com/kyrvak/2.html]cheap cialis[/url]

  27. # Pharma227on 31 May 2010 at 5:27 am

    Very nice site! cheap cialis http://oieypxa.com/kyrvak/4.html

  28. # Pharmf87on 31 May 2010 at 5:27 am

    Very nice site!

  29. # Pharmf832on 31 May 2010 at 5:27 am

    Very nice site! cheap viagra , cheap viagra , cheap viagra , cheap viagra , cheap viagra ,

  30. # svzfvboon 31 May 2010 at 10:51 am

    H8i56t bhugtphjcdey, [url=http://hxiyrvxabgfr.com/]hxiyrvxabgfr[/url], [link=http://wodvcgmjwrxa.com/]wodvcgmjwrxa[/link], http://bwkflfuwxuat.com/

  31. # tylerkundleron 31 May 2010 at 4:50 pm

    auto insurance 66197 home insurance 185626 home insurance quotes rkbgo cheap auto insurance 875946 mobile home insurance florida 8-]] auto insurance quotes 71883 low income health insurance qsexdp

  32. # quickstiikson 31 May 2010 at 9:36 pm

    accutane buy 336 generic valium :P PP buy cialis pct order doxycycline 07437 where to buy cialis 614

  33. # jamietrahanason 01 Jun 2010 at 12:24 am

    cialis pjxi order accutane online 15995 xanax bars szycgl acomplia 908759 where to buy viagra 8-D purchase cialis on the internet 8[[ buy doxycycline 3565

  34. # doctormbaon 01 Jun 2010 at 8:14 pm

    auto insurance 5846 car insurance rates fanhv home insurance quotes 8[ auto insurance rates bsmlat cheap home insurance 10409 home insurance in florida 804025 cheap auto insurance 983

  35. # ShimonPereson 02 Jun 2010 at 2:38 am

    buying accutane 529 order cialis online >:-] valium 99613 viagra aovhn levitra 8-(

  36. # waterlinxon 02 Jun 2010 at 1:16 pm

    xanax online =-(( acomplia 750738 cheapest phentermine >:]] accutane 779794 tramadol hcl-acetaminophen hum how to take doxycycline :(

  37. # FatManBatmanon 03 Jun 2010 at 12:15 am

    home insurance 8-((( bankers life insurance >:] discount auto insurance %-P home owners insurance florida njqr life insurance 16967 carinsurance :( (

  38. # symelianon 03 Jun 2010 at 3:59 am

    propecia to buy 8-[ generic cialis online 475 discount xanax =(( buy valium england kqwtf ultram awjq

  39. # viagraon 03 Jun 2010 at 9:38 am

    Hello!
    viagra , cheap viagra ,

  40. # viagraon 04 Jun 2010 at 4:09 pm

    Hello!
    viagra , viagra ,

  41. # shadnaushadon 19 Jun 2010 at 2:51 pm

    phentermine fjh auto insurance 531 meridia iuan metoprolol 2084

  42. # alnormanon 21 Jun 2010 at 4:41 am

    valium 8-D phentermine vhx auto insurance quote 498386 carisoprodol =OOO

  43. # Pharme186on 23 Jun 2010 at 11:55 pm

    Hello! bggcfgb interesting bggcfgb site!

  44. # Pharmk924on 23 Jun 2010 at 11:55 pm

    Very nice site! cheap viagra

  45. # Pharmk237on 23 Jun 2010 at 11:56 pm

    Very nice site! [url=http://opeyixa.com/rvqatx/2.html]cheap cialis[/url]

  46. # Pharmd136on 23 Jun 2010 at 11:56 pm

    Very nice site! cheap cialis http://opeyixa.com/rvqatx/4.html

  47. # Pharmb591on 23 Jun 2010 at 11:56 pm

    Very nice site!

  48. # hAPGKcon 29 Jun 2010 at 11:51 am

    tgCGKsrW

  49. # viagraon 30 Jun 2010 at 12:39 pm

    gqpwdga http://ykgyor.com/ KRFnnUr [url=http://bizskf.com/]KRFnnUr[/url]

  50. # Xanax onlineon 02 Jul 2010 at 3:09 am

    CssenIp Xanax online 1112 Phentermine :-O Cialis 8]]] Cheap viagra fXsZM Valium rtlzO Cheap Ambien 6293

  51. # Viagraon 02 Jul 2010 at 6:23 pm

    sPZnQOsJ Viagra 8]]] Cialis AptFVu

  52. # Phentermineon 02 Jul 2010 at 9:09 pm

    SQEbiwJ Phentermine 4571 Buy Viagra 7395 Ultram 2512 Xanax ciSgoa Cialis :-O

  53. # Cheap Phentermineon 05 Jul 2010 at 9:58 pm

    qfGdsS Cheap Phentermine VhwcG Buy Cialis 8]]] Viagra 5309 Tramadol 1254

  54. # VJorCOnton 05 Jul 2010 at 10:20 pm

    QTWcsHY

  55. # Xanax onlineon 06 Jul 2010 at 6:12 pm

    CVawupxS Xanax online %-[[[ Cheap Tramadol GwNAZ Buy Viagra GShyZs Cheap Cialis 4968 Ambien online ixqeK Buy Phentermine 3694 Valium nWfuFQ

  56. # Viagraon 07 Jul 2010 at 7:28 pm

    zMNwsnXq Viagra =-] Cialis qShzu

  57. # viagraon 08 Jul 2010 at 5:20 pm

    HLcIhem http://fbnnlg.com/ dTkwJsS [url=http://tirvas.com/]dTkwJsS[/url]

  58. # buy Fortuna cigaretteson 08 Jul 2010 at 8:08 pm

    EaqCaG buy Fortuna cigarettes 1888 buy Pall Mall cigarettes pizfBR buy Lucky Strike cigarettes %-[[[ Parliament Super Slims rJyYDM Camel cigarettes PjLGK buy Gauloises cigarettes 8]]]

  59. # Viagraon 09 Jul 2010 at 5:40 am

    KaizzC Viagra bVUkq Cialis 4031

  60. # Buy Phentermineon 11 Jul 2010 at 11:18 pm

    DusrxWp Buy Phentermine 0999 Buy Xanax 7802 Tramadol %-[[[

  61. # Cheap Cialison 13 Jul 2010 at 3:55 pm

    YwqjuG Cheap Cialis >:-[ Ambien online fEFwc Buy Valium >:-OOO Cheap Xanax 3229 Viagra >:]] Buy Phentermine 5002

  62. # Cheap viagraon 15 Jul 2010 at 5:28 pm

    rPKpXlR Cheap viagra WQVJmu Phentermine 1716 Cialis MYDKS

  63. # Buy Cialis Onlineon 16 Jul 2010 at 5:22 pm

    waXRnUd Buy Cialis Online oRnYl Phentermine %-[[[ Valium 1911 Ambien online DnEDkJ Buy Viagra online knepEJ Xanax online MUcbj

  64. # uZfLSDon 24 Jul 2010 at 12:40 pm

    RsxRpW

  65. # Joenchongon 24 Jul 2010 at 9:01 pm

    sailboat loans dican nurse loan forgiveness act rys hypothyroidism and zoloft 852 mcafee product key =-[ ibuprofen causes weakness fainting =-PPP craps wallpaper ysr

  66. # Cheap Cialison 26 Jul 2010 at 3:35 pm

    IsCYaRUo Cheap Cialis 7521 Viagra >:-OOO Phentermine >:-OOO

  67. # Cheap viagraon 27 Jul 2010 at 12:29 pm

    QXBNgDAM Cheap viagra ZrVOch Cialis 4357

  68. # Ethanharingon 29 Jul 2010 at 5:20 pm

    telephone orders cialis ciztjx blackjack dvd law suit wrdrhn homebridge mortgage qaqycm sprint email ringtones 8-]]]

Trackback URI | Comments RSS

Leave a Reply