Andy! Even Installing as a service and choosing Server Machine as Server type does not install mysqld the settings I used are as follows. I even did a search in the C drive
SetUp Type Complete The configuration choices made running Configuration Wizard 1Configuration Type Detailed 2 Server Type Server Machine 3 Database Usage Transactional database only 4 Drive for InnoDB data file InnoDB Tablespace Settings Default Settings(C: Drive and Installation path) 5 Number OF Concurrent Approximate connections Decision Support 6 Networking Options Enable networking options Checked(ticked) Add firewall exception for port 3306 Checked(ticked) Enable strict mode Checked(ticked) 7 Default Charter set Standard Character set 8 Windows Options Install As A Service Checked(ticked) Launch MySQL Server Automaticaly Checked(ticked) Service Name: MySQL Include Bin Directory in Windows path Checked(ticked) 9 Set the security settings A root password set 10 Ready to Execute Screen Execute Button Clicked Preparation configuration Okay Write Configuration file (C:\Program Files\MySQL\MySQL Server 5.0\bin) Okay Start Service Okay Apply security settings Okay Regards Varuna On Sun, Oct 5, 2008 at 9:05 PM, Andy Shellam <[EMAIL PROTECTED]>wrote: > Varuna, > > Please also remember to copy the list back in to your response so others > can follow your steps if they're having trouble. > > As I said in my e-mail, I would recommend installing as a Windows service > (you said in your e-mail that "Install as a Windows service" was unchecked.) > I don't use MySQL on Windows so I cannot be 100% confident, but this might > be the reason why the "mysqld" binary is not installed. You could also try > installing the server as a Server Machine, not a Developer Machine. > > Try these and see if you get any further. > > Regards, > Andy > > > Varuna Seneviratna wrote: > >> Dear Andy >> I am sorry if I have been nuisance to you by posting six times the >> same question.I wanted to learn all the three types of the server. >> I did a search as you have suggested and it didn't return a mysqld >> binary.But it returned mysqld-nt.What the reference manual says is not >> true.I again installed and i have listed them below .I have tried choosing >> the setup type as complete and custom also But the mysqld server can not be >> started >> >> >> The setUp double clicked and the screen to select the setup type appeared >> Then as follows >> >> 1 SetUp type >> typical >> Configuration Wizard >> 1 Server Type >> Developer Machine >> 2 Database Usage >> Multifunctional Database >> 3 InnoDB data file drive >> the default settings was selected >> Drive C and the installation path >> 4 Approximate Number Of Connections >> Decision Support(Dss and OLAP) >> 5 Networking Options >> TCP/IP Enabled >> port number 3306, >> Add Firewall Exception checked >> Enabled Strict Mode checked >> 6 Default character set >> Standard Character set >> 7 Windows Options >> Install as a Windows service Unchecked >> Include Bin Directory in Windows Path Checked >> *The screen with the execute Button Appeared and When clicked >> Prepare configuration ticked(Okay) >> Write Configuration file path(C:\Program Files\MySQL\MySQL Server >> 5.0\my.ini) ticked(Okay) >> After above listed installation I went to the bin directory and >> typed >> mysqld --console->Nothing happened >> >> mysqld-nt --console >> The output was >> 081005 19:02:09 InnoDB: Started; log sequence number 0 43655 >> 081005 19:02:09 [Note] mysqld-nt: ready for connections. >> Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community >> Edition >> (GPL) >> >> Anyway I will settle with the mysqld-nt and go on with my >> assignment.Thanks For your help.Iam sorry if I have caused you any >> inconvenience >> >> Thanks Regards Varuna >> >> On Sun, Oct 5, 2008 at 3:17 PM, Andy Shellam <[EMAIL PROTECTED]> >> wrote: >> >> Varuna, >> >> A polite note - if you post the same question 6 times (especially >> in the space of 24 hours) people are going to be more unlikely to >> help you. Post the question once, and read people's responses. >> >> Now onto your issues... >> >> When you run "mysqld-nt" you were starting a standalone version of >> MySQL with named pipes support. Once this was running in one >> command window, you would need another command window with a >> client connecting to that server. >> >> The message you are getting back from Windows is that "mysqld" >> doesn't exist in "C:\Program Files\MySQL\MySQL Server 5.0\bin". >> My first step would be to do a search for this binary (Start > >> Search > Files or Folders etc.) >> >> Secondly there are a number of ways in which MySQL can be >> installed on a Windows system - how did you do it? Which package >> did you download? Have you run the configuration wizard? (I >> don't use MySQL on Windows so I'm reading from the manual.) >> >> Have you installed MySQL as a service or as a server? If you've >> installed as a service, then you shouldn't need to be starting the >> server manually - just stop and start the service using >> services.msc. If not, I'd highly recommend reinstalling and doing so. >> >> As for users, if you've not assigned the user a password when you >> created it, that user won't have a password so you don't need the >> "-p" option in MySQL client programs. If you haven't created a >> user, the only user your system will have configured is "root." >> >> Andy >> >> >> Varuna Seneviratna wrote: >> >> Hello Steven >> >> I have installed it as an service, I first stopped the service >> form the >> Service Control Manager and I went to the directory "C:\Program >> Files\MySQL\MySQL >> >> Server 5.0\bin" ran the command "mysqld" --console. >> >> and out put was >> >> C:\Program Files\MySQL\MySQL Server 5.0\bin>"mysqld" --console >> '"mysqld"' is not recognized as an internal or external command, >> operable program or batch file. >> >> >> The reference manual says that there are three server types, >> mysqld >> ,mysqld-nt, mysqld-debug.My problem is I am able to start >> mysqld server >> >> >> Varuna >> >> On Sun, Oct 5, 2008 at 1:14 PM, Steven >> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> >> >> wrote: >> >> >> Good Morning Steven >> >> Hello Varuna! >> >> >> Well to start mysqld the reference >> manual instructs to give the command [C:\> "C:\Program >> Files\MySQL\MySQL >> Server 5.0\bin\mysqld" --console] >> >> The out put is as below >> >> 'C:\' is not recognized as an internal or external >> command, >> operable program or batch file.under the heading >> "Starting the server for >> the first time" >> >> It's not practical to install MySQL in the directory >> Program Files, >> because the folder name for cmd is too long and it's a >> little bit >> tricky. Better structure is the following: >> >> C:\MySQL\ >> >> So the service to start -> Command Prompt (cmd) >> >> >> C: >> cd /MySQL/ >> mysqld-- console >> >> It is important to the folder where MySQL is. Otherwise it >> is not my >> opinion. >> >> Greetings, >> Steven >> >> >> >> >> >>