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
>>
>>
>>
>>
>>
>>

Reply via email to