Mysql installation on Windows XP

I am trying to use the SAMS's teach yourself SQL book. I have download
mysql to C:\mysql. I am attempting to open mysql but do not understand
what steps I must take one I have the command prompt open. Can anyone
give me the proper syntax to get mysql to open?



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Mysql installation on Windows XP

On the assumption this is "Teach Yourself PHP, MySQL and Apache":-

Make sure the MySQL server is running as a Windoze service. If you don't
see it, you need to install it - that's in the MySQL documentation, which
should be in something like C:\mysql\docs. Or you can dig your way down to
it on www.mysql.com, which I haven't done for a while, which is why I'm
being deliberately vague...

If that's OK, then go to c:\mysql\bin, and enter "mysql -u root -p".
Respond to the prompt with an empty line, that should get you in. Of
course, this is vastly insecure... Fix it by taking the steps in the manual
(see next para).

Personally, I don't use mysqladmin - I don't believe it does anything for
you that you can't do from the DOS prompt. If you haven't yet downloaded
the MySQL manual, I strongly recommend doing that, reading it for a day or
so, then getting serious. I'd recommend the HTML format rather than say PDF
or plain text, tho that's probably purely personal. Specifically, I also
recommend the flavour where you have one file with the ToC, and another with
the entire book, rather than chapter by chapter. The advantage is that you
can use your browser to look for significant phrases like "-u root".

HTH, GStC.

----- Original Message -----
From: "Joyce M Brewer"
To:
Sent: Monday, February 21, 2005 9:23 AM
Subject: Mysql installation on Windows XP


>I am trying to use the SAMS's teach yourself SQL book. I have download
>mysql to C:\mysql. I am attempting to open mysql but do not understand what
>steps I must take one I have the command prompt open. Can anyone give me
>the proper syntax to get mysql to open?
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=graeme_st_clair@atlanticb b.net
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Mysql installation on Windows XP

In working through the same problems you are experiencing, I used =
Managing
and Using MySQL by George Reese, Randy Jay Yarger, and Tim King; =
Published
by O'Reilly & Associates; ISBN 0-596-00211-4. It was great help for me =
in
getting the MySQL Service up and running. Your local library will =
probably
have a copy of the book.

I think that the DOS prompt is perfectly adequate for the changes you =
need
to make when you set up the MySQL Service. One other note - you need to
download and run the ZIP version of the windows installer because the =
MSI
version apparently does not have the client software included, only the
server software.

I use PHPMyAdmin (http://www.phpmyadmin.net/home_page/) and recommend it =
for
maintaining the database. There are some good instructions for making =
sure
that your installation has adequate security in the setup files. You =
will
need PHP up and working on your server. If you are setting up from =
scratch
and do not have a server, get Apache - it is much easier than IIS to set =
up
and use in a small network environment (or even a single computer
environment).

LBE
larry@wakewash.com

----- Original Message -----=20
From: "Joyce M Brewer"
To:
Sent: Monday, February 21, 2005 9:23 AM
Subject: Mysql installation on Windows XP


>I am trying to use the SAMS's teach yourself SQL book. I have download
>mysql to C:\mysql. I am attempting to open mysql but do not understand =
what

>steps I must take one I have the command prompt open. Can anyone give =
me=20
>the proper syntax to get mysql to open?
>
--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3DLarry@wakewash.com





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org