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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
