From: Andy Shellam (andy-listsnetworkmail.eu)
Date: Sun Oct 05 2008 - 10:35:20 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
> <andy-listsnetworkmail.eu> 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
> <toxic01413googlemail.com <mailto:toxic01413googlemail.com>>
> 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
>
>
>
>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]