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