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