newbie question....an idiot"s guide to installing sql on an xp deskto....

------_=_NextPart_001_01C5F6BD.F1A4300F
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hi,

does a simplified document exist that someone can point me to get mysql =
installed easily on my desk top? im looking for the idiots guide. i just =
want to get it installed easy so i can start learning the basics of =
database structures and sql.

whats better. running it as a service or as command line client?

any help would be greatly appreciated.

bob brozewicz
pittsburgh, pa.
=20
The information contained in this e-mail may be confidential and is =
intended solely for the use of the named addressee.
Access, copying or re-use of the e-mail or any information contained =
therein by any other person is not authorized.
If you are not the intended recipient please notify us immediately by =
returning the e-mail to the originator.(16b)

------_=_NextPart_001_01C5F6BD.F1A4300F--

RE: newbie question....an idiot"s guide to installing sql on an xp deskto....

What do you find unacceptable about the instructions at:

http://dev.mysql.com/doc/refman/5.0/en/windows-installation. html

Is there a section you would consider too complicated?

Mike


> -----Original Message-----
> From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]
> Sent: Thursday, December 01, 2005 2:27 PM
> To: win32@lists.mysql.com
> Subject: newbie question....an idiot's guide to installing sql on an xp
> deskto....
>
> hi,
>
> does a simplified document exist that someone can point me to get mysql
> installed easily on my desk top? im looking for the idiots guide. i just
> want to get it installed easy so i can start learning the basics of
> database structures and sql.
>
> whats better. running it as a service or as command line client?
>
> any help would be greatly appreciated.
>
> bob brozewicz
> pittsburgh, pa.
>
> The information contained in this e-mail may be confidential and is
> intended solely for the use of the named addressee.
> Access, copying or re-use of the e-mail or any information contained
> therein by any other person is not authorized.
> If you are not the intended recipient please notify us immediately by
> returning the e-mail to the originator.(16b)


--
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: newbie question....an idiot"s guide to installing sql on an xp deskto....

I think section 2.3 in the manual is pretty easy to follow and contains
all that you need to know.

Running as a service is usually simplest.

John B.

-----Original Message-----
From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]=20
Sent: Friday, 2 December 2005 7:57 AM
To: win32@lists.mysql.com
Subject: newbie question....an idiot's guide to installing sql on an xp
deskto....

hi,

does a simplified document exist that someone can point me to get mysql
installed easily on my desk top? im looking for the idiots guide. i just
want to get it installed easy so i can start learning the basics of
database structures and sql.

whats better. running it as a service or as command line client?

any help would be greatly appreciated.

bob brozewicz
pittsburgh, pa.
=20
The information contained in this e-mail may be confidential and is
intended solely for the use of the named addressee.
Access, copying or re-use of the e-mail or any information contained
therein by any other person is not authorized.
If you are not the intended recipient please notify us immediately by
returning the e-mail to the originator.(16b)

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

Re: newbie question....an idiot"s guide to installing sql on an xp deskto....

There's nothing more simple, to the point and still pretty extense to
teach you the basic/intermediate info you need to install/run/use
MySQL as the MySQL Manual itself, nowadays with UML and doc generation
you usually never need more than the program help itself in order to
use it.

Gotta love help, --help, F1, -h, /?, man, info, .CHMs, .HLPs, all TXTs
(readme, help, info, install) and HTMLs, Google, Altavista and PHPBB.
Besides today you have WIKIs, HOWTOs, complete real-time updated
online documentation and this mailing lists and foruns in case the
previous help didn't solve your problem.

On 12/1/05, jbonnett@sola.com.au wrote:
> I think section 2.3 in the manual is pretty easy to follow and contains
> all that you need to know.
>
> Running as a service is usually simplest.
>
> John B.
>
> -----Original Message-----
> From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]
> Sent: Friday, 2 December 2005 7:57 AM
> To: win32@lists.mysql.com
> Subject: newbie question....an idiot's guide to installing sql on an xp
> deskto....
>
> hi,
>
> does a simplified document exist that someone can point me to get mysql
> installed easily on my desk top? im looking for the idiots guide. i just
> want to get it installed easy so i can start learning the basics of
> database structures and sql.
>
> whats better. running it as a service or as command line client?
>
> any help would be greatly appreciated.
>
> bob brozewicz
> pittsburgh, pa.
>
> The information contained in this e-mail may be confidential and is
> intended solely for the use of the named addressee.
> Access, copying or re-use of the e-mail or any information contained
> therein by any other person is not authorized.
> If you are not the intended recipient please notify us immediately by
> returning the e-mail to the originator.(16b)
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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

RE: newbie question....an idiot"s guide to installing sql on an xp deskto....

Bob,

I'm kind of new to MySQL also but maybe if I give you my impression some
other people who are more knowledgeable on this list might point out =
where
I've gone wrong and we'll both learn something.

Since I'm not sure how basic your starting point is here are some very =
basic
things that I think are correct.

1. mysqld-nt.exe is designed to run as a service (windows) or daemon
(linux/unix but named mysqld). This program has no direct interface to =
the
operator but gets requests on a tcp/ip port (or other interprogram
communication method).

2. mysql is designed to be a command line interface to the mysqld
service/daemon. The primary command interface is SQL plus some =
extensions
which are documented in the manual. The extensions to SQL allow this to =
be
an administrative interface as well as an SQL interface.

3. The manual in it's various forms (.pdf, .chm, .html, etc.) is =
extensive
and, with apologies to the writers and contributors, is quite confusing =
on
first exposure. But it seems to be comprehensive as you become more
familiar with the product.

4. There are a lot of other graphical command type interfaces. I =
bought
one called Navicat which seems to be good but I've seen no mention of it =
on
the list and a number of people have talked about being pleased with =
other
interface programs.

5. There are a lot of command line switches that can be used to control
both the mysqld(-nt) and mysql programs when started. I noticed that =
the
installation of MySQL server (the mysqld-nt.exe program) on my system =
the
use-defaults switch was used. It took me quite a bit of exploring to =
find
the various controlling .ini files. I'm still confused about how many
configuration (.ini) files there are and where they're located.

6. My recommendation to begin exploring mysql is to install the server =
as a
service and just let it run as part of the system startup. If you're =
not
using it, it won't consume much in the way of resources. Then use the =
mysql
program to interface to it. It's a command line style interface and if
you're more used to a GUI, it'll seem clunky. However, from my own
viewpoint, it exposes the most information about how the server actually
works and what the commands are that can be delivered to the server. =
That
forms a basis for understanding the various GUI interfaces.

7. There's a MyODBC package that I tried to get running but was not
successful. Others report success with it so you'd be able to write
programs that use an ODBC interface or link to MySQL from Microsoft =
Access
if that's helpful. My guess is that I had a configuration problem with =
what
I was doing. However, one of the list participants suggested using
VBMySQLDirect (I'm using VB6 for my current MySQL project) instead of =
ODBC.
This is a direct tcp/ip interface to the SQL server which provides a
connection object to the MySQL server. It was a good recommendation and
I've committed to that approach.

==================== =====3D=
=========3D

I don't know if this helps but I'll be watching for any comments about =
where
my understanding is incorrect.

Regards.



Lawson Cronlund
lawson@vrtinc.com
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
=20

-----Original Message-----
From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]=20
Sent: Thursday, December 01, 2005 2:27 PM
To: win32@lists.mysql.com
Subject: newbie question....an idiot's guide to installing sql on an xp
deskto....


hi,

does a simplified document exist that someone can point me to get mysql
installed easily on my desk top? im looking for the idiots guide. i just
want to get it installed easy so i can start learning the basics of =
database
structures and sql.

whats better. running it as a service or as command line client?

any help would be greatly appreciated.

bob brozewicz
pittsburgh, pa.
=20
The information contained in this e-mail may be confidential and is =
intended
solely for the use of the named addressee.
Access, copying or re-use of the e-mail or any information contained =
therein
by any other person is not authorized.
If you are not the intended recipient please notify us immediately by
returning the e-mail to the originator.(16b)


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

RE: newbie question....an idiot"s guide to installing sql on an xp deskto....

A quick addition to this on the point of GUI's. There is a free windows =
GUI
from the MySQL team called MYSQL Query browser which allows you to query =
the
database using a more friendly interface.=20

Regards,
Jerry Fitzgibbon

-----Original Message-----
From: Lawson Cronlund [mailto:lawson@vrtinc.com]=20
Sent: Friday, December 02, 2005 3:38 PM
To: 'Brozewicz Robert F'; win32@lists.mysql.com
Subject: RE: newbie question....an idiot's guide to installing sql on an =
xp
deskto....


Bob,

I'm kind of new to MySQL also but maybe if I give you my impression some
other people who are more knowledgeable on this list might point out =
where
I've gone wrong and we'll both learn something.

Since I'm not sure how basic your starting point is here are some very =
basic
things that I think are correct.

1. mysqld-nt.exe is designed to run as a service (windows) or daemon
(linux/unix but named mysqld). This program has no direct interface to =
the
operator but gets requests on a tcp/ip port (or other interprogram
communication method).

2. mysql is designed to be a command line interface to the mysqld
service/daemon. The primary command interface is SQL plus some =
extensions
which are documented in the manual. The extensions to SQL allow this to =
be
an administrative interface as well as an SQL interface.

3. The manual in it's various forms (.pdf, .chm, .html, etc.) is =
extensive
and, with apologies to the writers and contributors, is quite confusing =
on
first exposure. But it seems to be comprehensive as you become more
familiar with the product.

4. There are a lot of other graphical command type interfaces. I =
bought
one called Navicat which seems to be good but I've seen no mention of it =
on
the list and a number of people have talked about being pleased with =
other
interface programs.

5. There are a lot of command line switches that can be used to control
both the mysqld(-nt) and mysql programs when started. I noticed that =
the
installation of MySQL server (the mysqld-nt.exe program) on my system =
the
use-defaults switch was used. It took me quite a bit of exploring to =
find
the various controlling .ini files. I'm still confused about how many
configuration (.ini) files there are and where they're located.

6. My recommendation to begin exploring mysql is to install the server =
as a
service and just let it run as part of the system startup. If you're =
not
using it, it won't consume much in the way of resources. Then use the =
mysql
program to interface to it. It's a command line style interface and if
you're more used to a GUI, it'll seem clunky. However, from my own
viewpoint, it exposes the most information about how the server actually
works and what the commands are that can be delivered to the server. =
That
forms a basis for understanding the various GUI interfaces.

7. There's a MyODBC package that I tried to get running but was not
successful. Others report success with it so you'd be able to write
programs that use an ODBC interface or link to MySQL from Microsoft =
Access
if that's helpful. My guess is that I had a configuration problem with =
what
I was doing. However, one of the list participants suggested using
VBMySQLDirect (I'm using VB6 for my current MySQL project) instead of =
ODBC.
This is a direct tcp/ip interface to the SQL server which provides a
connection object to the MySQL server. It was a good recommendation and
I've committed to that approach.

==================== =====3D=
=========3D

I don't know if this helps but I'll be watching for any comments about =
where
my understanding is incorrect.

Regards.



Lawson Cronlund
lawson@vrtinc.com
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
=20

-----Original Message-----
From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]=20
Sent: Thursday, December 01, 2005 2:27 PM
To: win32@lists.mysql.com
Subject: newbie question....an idiot's guide to installing sql on an xp
deskto....


hi,

does a simplified document exist that someone can point me to get mysql
installed easily on my desk top? im looking for the idiots guide. i just
want to get it installed easy so i can start learning the basics of =
database
structures and sql.

whats better. running it as a service or as command line client?

any help would be greatly appreciated.

bob brozewicz
pittsburgh, pa.
=20
The information contained in this e-mail may be confidential and is =
intended
solely for the use of the named addressee. Access, copying or re-use of =
the
e-mail or any information contained therein by any other person is not
authorized. If you are not the intended recipient please notify us
immediately by returning the e-mail to the originator.(16b)


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Djerry@twisteddigits.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

Re: newbie question....an idiot"s guide to installing sql on an xp deskto....

I'll try to add something, despite of the fact that Lawson did a good job..=
..

On 12/2/05, Lawson Cronlund wrote:
> Bob,
>
> I'm kind of new to MySQL also but maybe if I give you my impression some
> other people who are more knowledgeable on this list might point out wher=
e
> I've gone wrong and we'll both learn something.
>
> Since I'm not sure how basic your starting point is here are some very ba=
sic
> things that I think are correct.
>
> 1. mysqld-nt.exe is designed to run as a service (windows) or daemon
> (linux/unix but named mysqld). This program has no direct interface to t=
he
> operator but gets requests on a tcp/ip port (or other interprogram
> communication method).

There are other mysqld-XX.exe binaries, and they have specific uses as
well as defaults, the manual describes each one and what is the
default use/flags that it takes. You may be careful in using the same
version for the program AND the manual cause there were big changes,
both in the name and the use of those binaries.

>
> 2. mysql is designed to be a command line interface to the mysqld
> service/daemon. The primary command interface is SQL plus some extension=
s
> which are documented in the manual. The extensions to SQL allow this to =
be
> an administrative interface as well as an SQL interface.

It is also called the "mysql console".

>
> 3. The manual in it's various forms (.pdf, .chm, .html, etc.) is extensi=
ve
> and, with apologies to the writers and contributors, is quite confusing o=
n
> first exposure. But it seems to be comprehensive as you become more
> familiar with the product.

The MySQL Manual has sections, once you got your prefered version
(CHM, HTML, PDF, you choose), you'll have to learn a way to search
inside the manual (either CTRL+F, or F3, or the index and search tab
for chm) for specific keywords, because the Manual has a LOT of
information and sometimes you just don't get the right section first
try.

>
> 4. There are a lot of other graphical command type interfaces. I bought
> one called Navicat which seems to be good but I've seen no mention of it =
on
> the list and a number of people have talked about being pleased with othe=
r
> interface programs.

MySQL AB provides a free, easy to use and complete suite composed by
MySQL Administrator and MySQL Query Browser, both are useful and give
you a lot of functions with a well defined and documented interface.
Some people buy programs or try third-party GUI software, but I stick
with the idea that the best software to administer a server should be
made by the same people that made the server.

>
> 5. There are a lot of command line switches that can be used to control
> both the mysqld(-nt) and mysql programs when started. I noticed that the
> installation of MySQL server (the mysqld-nt.exe program) on my system the
> use-defaults switch was used. It took me quite a bit of exploring to fin=
d
> the various controlling .ini files. I'm still confused about how many
> configuration (.ini) files there are and where they're located.

There's only one .ini file called my.ini in Windows or my.cnf on Linux
(by default), most times when you install as a service, the service
command line has the "--defaults-file" switch that points to the .ini
(that can be changed, I'm explaining default settings here). Nearly
all aspects of MySQL Server can be controlled by specific variables
inside the ini file, and all of them are pretty well documented in the
manual. The location of the .ini file can be changed, but if no
--defaults-file argument is given to the server, it searches for the
file on specific folders in an order that the manual explains as well
(I don't exactly remember the order).

>
> 6. My recommendation to begin exploring mysql is to install the server a=
s a
> service and just let it run as part of the system startup. If you're not
> using it, it won't consume much in the way of resources. Then use the my=
sql
> program to interface to it. It's a command line style interface and if
> you're more used to a GUI, it'll seem clunky. However, from my own
> viewpoint, it exposes the most information about how the server actually
> works and what the commands are that can be delivered to the server. Tha=
t
> forms a basis for understanding the various GUI interfaces.

Lawson is right, GUIs are good, of course, but if you start using
them, you get kinda lazy, and because THEY'RE NOT DEFAULT, you may get
lost. Almost any mysql installation has the mysql console, but not all
of them has GUIs installed, once you learn the commands from the
console, you can easily administer mysql on any platform and system
locally or remotelly.

>
> 7. There's a MyODBC package that I tried to get running but was not
> successful. Others report success with it so you'd be able to write
> programs that use an ODBC interface or link to MySQL from Microsoft Acces=
s
> if that's helpful. My guess is that I had a configuration problem with w=
hat
> I was doing. However, one of the list participants suggested using
> VBMySQLDirect (I'm using VB6 for my current MySQL project) instead of ODB=
C.
> This is a direct tcp/ip interface to the SQL server which provides a
> connection object to the MySQL server. It was a good recommendation and
> I've committed to that approach.
>
> ==================== =====
==========
>
> I don't know if this helps but I'll be watching for any comments about wh=
ere
> my understanding is incorrect.
>
> Regards.
>
>
>
> Lawson Cronlund
> lawson@vrtinc.com
> +1(480)308-0641 (Voice)
> +1(602)996-0376 (Fax)
>
>
> -----Original Message-----
> From: Brozewicz Robert F [mailto:brozewicz.rf@mellon.com]
> Sent: Thursday, December 01, 2005 2:27 PM
> To: win32@lists.mysql.com
> Subject: newbie question....an idiot's guide to installing sql on an xp
> deskto....
>
>
> hi,
>
> does a simplified document exist that someone can point me to get mysql
> installed easily on my desk top? im looking for the idiots guide. i just
> want to get it installed easy so i can start learning the basics of datab=
ase
> structures and sql.
>
> whats better. running it as a service or as command line client?
>
> any help would be greatly appreciated.
>
> bob brozewicz
> pittsburgh, pa.
>
> The information contained in this e-mail may be confidential and is inten=
ded
> solely for the use of the named addressee.
> Access, copying or re-use of the e-mail or any information contained ther=
ein
> by any other person is not authorized.
> If you are not the intended recipient please notify us immediately by
> returning the e-mail to the originator.(16b)
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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