Correct install?

--0-1142518734-1112982491=:53530
Content-Type: text/plain; charset=us-ascii

I'm totally new to MySQL and databases in general. I've done an install of MySQL running on a Windows XP Professional laptop. But I'm a little confused as to how to populate the database. The service is running, the Command Line Client works and '\s' gives the following info after I log in. I'm wondering if this is a typical status report. I also have installed the online documentation, but am wondering where I should start reading.
TIA
ron

mysql> \s
--------------
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7 Distrib 4.1.11, for Win32 (ia32)
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 4.1.11-nt
Protocol version: 10
Connection: Named pipe: mysql
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: mysql
Uptime: 29 min 37 sec
Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 0 Queries per second avg: 0.012
--------------
mysql>

--0-1142518734-1112982491=:53530--

Re: Correct install?

google it.

www.google.com/search?q=MySQL+tutorial

There are a ton of books on MySQL and various other things associated
with it. There are also client helper applications with MySQL which you
can get from www.mysql.com including an administrative GUI and a query
helper. As far as everything else the BEST place to start is
www.mysql.com/doc Is has everything you need to know.

as far as populating it....there are a few ways to do this. PHPMyAdmin
seems like the most common interfaces to DL for noobs like you and I. It
can be found at http://www.phpmyadmin.net. You can also create forms to
input data using PHP. You can create text files of code and import them
or you can just enter it right from the command prompt. The
possibilities are endless. Good luck. (HTH!)
jozef

Ron Smith wrote:

>I'm totally new to MySQL and databases in general. I've done an install of MySQL running on a Windows XP Professional laptop. But I'm a little confused as to how to populate the database. The service is running, the Command Line Client works and '\s' gives the following info after I log in. I'm wondering if this is a typical status report. I also have installed the online documentation, but am wondering where I should start reading.
>TIA
>ron
>
>mysql> \s
>--------------
>C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7 Distrib 4.1.11, for Win32 (ia32)
>Connection id: 2
>Current database:
>Current user: root@localhost
>SSL: Not in use
>Using delimiter: ;
>Server version: 4.1.11-nt
>Protocol version: 10
>Connection: Named pipe: mysql
>Server characterset: latin1
>Db characterset: latin1
>Client characterset: latin1
>Conn. characterset: latin1
>UNIX socket: mysql
>Uptime: 29 min 37 sec
>Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 0 Queries per second avg: 0.012
>--------------
>mysql>
>
>
>



--
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: Correct install?

You may what to install MySQL Administrator
http://www.mysql.com/products/administrator/. Just to have a familiar
GUI tool to manage DB.

Mikhail=20

-----Original Message-----
From: Ron Smith [mailto:geeksatlarge@yahoo.com]=20
Sent: Friday, April 08, 2005 1:48 PM
To: win32@lists.mysql.com
Subject: Correct install?

I'm totally new to MySQL and databases in general. I've done an install
of MySQL running on a Windows XP Professional laptop. But I'm a little
confused as to how to populate the database. The service is running, the
Command Line Client works and '\s' gives the following info after I log
in. I'm wondering if this is a typical status report. I also have
installed the online documentation, but am wondering where I should
start reading.
TIA
ron
=20
mysql> \s
--------------
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7 Distrib
4.1.11, for Win32 (ia32)
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 4.1.11-nt
Protocol version: 10
Connection: Named pipe: mysql
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: mysql
Uptime: 29 min 37 sec
Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush tables: 1
Open tables: 0 Queries per second avg: 0.012
--------------
mysql>

--
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: Correct install?

--=_alternative 00650C0685256FDD_=
Content-Type: text/plain; charset="US-ASCII"

Joseph Connolly wrote on 04/08/2005 02:05:35 PM:

> google it.
>
> www.google.com/search?q=MySQL+tutorial
>
> There are a ton of books on MySQL and various other things associated
> with it. There are also client helper applications with MySQL which you
> can get from www.mysql.com including an administrative GUI and a query
> helper. As far as everything else the BEST place to start is
> www.mysql.com/doc Is has everything you need to know.
>
> as far as populating it....there are a few ways to do this. PHPMyAdmin
> seems like the most common interfaces to DL for noobs like you and I. It

> can be found at http://www.phpmyadmin.net. You can also create forms to
> input data using PHP. You can create text files of code and import them
> or you can just enter it right from the command prompt. The
> possibilities are endless. Good luck. (HTH!)
> jozef
>
> Ron Smith wrote:
>
> >I'm totally new to MySQL and databases in general. I've done an
> install of MySQL running on a Windows XP Professional laptop. But
> I'm a little confused as to how to populate the database. The
> service is running, the Command Line Client works and '\s' gives the
> following info after I log in. I'm wondering if this is a typical
> status report. I also have installed the online documentation, but
> am wondering where I should start reading.
> >TIA
> >ron
> >
> >mysql> \s
> >--------------
> >C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7
> Distrib 4.1.11, for Win32 (ia32)
> >Connection id: 2
> >Current database:
> >Current user: root@localhost
> >SSL: Not in use
> >Using delimiter: ;
> >Server version: 4.1.11-nt
> >Protocol version: 10
> >Connection: Named pipe: mysql
> >Server characterset: latin1
> >Db characterset: latin1
> >Client characterset: latin1
> >Conn. characterset: latin1
> >UNIX socket: mysql
> >Uptime: 29 min 37 sec
> >Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush
> tables: 1 Open tables: 0 Queries per second avg: 0.012
> >--------------
> >mysql>
> >
> >
> >
>
oops!! Maybe you missed the part where he said he was on XP. No Apache or
PHP there. PHPmyAdmin is not a good fit for him.

PLEASE DO RTFM - I highly recommend Reading The Fine Manual (there is a
good tutorial section, I think it's chapter 3) and look for other online
tutorials. Any good walkthrough will help you get your feet wet while
explaining what is going on.

What you need to figure out is how to do things in small steps (how to
create a table, how to add records to the table, how to write a query, how
to change an existing record, etc.) Start small and work your way up. Each
step builds on the others. The FULL and DETAILED explanations are also in
the book but if you learn to skim through all of the extra details until
you find just the part you need, you will be well on your way.

If you have any questions and can't find the answers on your own (you will
learn more and learn faster if you TRY to find the answer than if you are
always given the answer first) you are invited and encouraged to ask the
list. We can all remember the first time we logged into a database and how
particular computers are about spelling and punctuation. The majority of
your early mistakes will be in translation. You think in one language but
the database only understands SQL and sometimes it can be rather picky
about how you ask it to do things.... ;-)

Best Wishes!!

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 00650C0685256FDD_=--

Re: Correct install?

I run PHPmyAdmin on both a XP home and an XP professional machine. It
works just fine. I think for someone beginning, it is easy enough to
install and use. Installing php on a WinXP professional machine is not
hard. (and it runs in IIS you don't need apache.) When I was beginning
it was a life saver because you could see the SQL of changes you made
which helps understanding MySQL SQL. That's just my .02

Sgreen is totally right about reading te manual. Everything you need to
know (for now at least) is in there. And most of it is not difficult to
get out and use. btw, That is the tiniest font i have ever seen in an e-mail


SGreen@unimin.com wrote:

>
>
> Joseph Connolly wrote on 04/08/2005 02:05:35 PM:
>
> > google it.
> >
> > www.google.com/search?q=MySQL+tutorial
> >
> > There are a ton of books on MySQL and various other things associated
> > with it. There are also client helper applications with MySQL which you
> > can get from www.mysql.com including an administrative GUI and a query
> > helper. As far as everything else the BEST place to start is
> > www.mysql.com/doc Is has everything you need to know.
> >
> > as far as populating it....there are a few ways to do this. PHPMyAdmin
> > seems like the most common interfaces to DL for noobs like you and
> I. It
> > can be found at http://www.phpmyadmin.net. You can also create forms to
> > input data using PHP. You can create text files of code and import them
> > or you can just enter it right from the command prompt. The
> > possibilities are endless. Good luck. (HTH!)
> > jozef
> >
> > Ron Smith wrote:
> >
> > >I'm totally new to MySQL and databases in general. I've done an
> > install of MySQL running on a Windows XP Professional laptop. But
> > I'm a little confused as to how to populate the database. The
> > service is running, the Command Line Client works and '\s' gives the
> > following info after I log in. I'm wondering if this is a typical
> > status report. I also have installed the online documentation, but
> > am wondering where I should start reading.
> > >TIA
> > >ron
> > >
> > >mysql> \s
> > >--------------
> > >C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7
> > Distrib 4.1.11, for Win32 (ia32)
> > >Connection id: 2
> > >Current database:
> > >Current user: root@localhost
> > >SSL: Not in use
> > >Using delimiter: ;
> > >Server version: 4.1.11-nt
> > >Protocol version: 10
> > >Connection: Named pipe: mysql
> > >Server characterset: latin1
> > >Db characterset: latin1
> > >Client characterset: latin1
> > >Conn. characterset: latin1
> > >UNIX socket: mysql
> > >Uptime: 29 min 37 sec
> > >Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush
> > tables: 1 Open tables: 0 Queries per second avg: 0.012
> > >--------------
> > >mysql>
> > >
> > >
> > >
> >
> oops!! Maybe you missed the part where he said he was on XP. No



> or PHP there. PHPmyAdmin is not a good fit for him.
>
> PLEASE DO RTFM - I highly recommend Reading The Fine Manual (there is
> a good tutorial section, I think it's chapter 3) and look for other
> online tutorials. Any good walkthrough will help you get your feet wet
> while explaining what is going on.
>
> What you need to figure out is how to do things in small steps (how to
> create a table, how to add records to the table, how to write a query,
> how to change an existing record, etc.) Start small and work your way
> up. Each step builds on the others. The FULL and DETAILED explanations
> are also in the book but if you learn to skim through all of the extra
> details until you find just the part you need, you will be well on
> your way.
>
> If you have any questions and can't find the answers on your own (you
> will learn more and learn faster if you TRY to find the answer than if
> you are always given the answer first) you are invited and encouraged
> to ask the list. We can all remember the first time we logged into a
> database and how particular computers are about spelling and
> punctuation. The majority of your early mistakes will be in
> translation. You think in one language but the database only
> understands SQL and sometimes it can be rather picky about how you ask
> it to do things.... ;-)
>
> Best Wishes!!
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine




--
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: Correct install?

--0-1588558099-1112992044=:57326
Content-Type: text/plain; charset=us-ascii

Thanks a lot folks!

It really does pay to RTFM. ;-) After a few seconds of poking around, in the on-line docs that come with MySQL, I stumbled across: "Chapter 3 MySQL Tutorial". It looks like I'm on my way, but I will also check into a nice front end, as suggested, to make things a little smoother.

Ron

Joseph Connolly wrote:
I run PHPmyAdmin on both a XP home and an XP professional machine. It
works just fine. I think for someone beginning, it is easy enough to
install and use. Installing php on a WinXP professional machine is not
hard. (and it runs in IIS you don't need apache.) When I was beginning
it was a life saver because you could see the SQL of changes you made
which helps understanding MySQL SQL. That's just my .02

Sgreen is totally right about reading te manual. Everything you need to
know (for now at least) is in there. And most of it is not difficult to
get out and use. btw, That is the tiniest font i have ever seen in an e-mail


SGreen@unimin.com wrote:

>
>
> Joseph Connolly wrote on 04/08/2005 02:05:35 PM:
>
> > google it.
> >
> > www.google.com/search?q=MySQL+tutorial
> >
> > There are a ton of books on MySQL and various other things associated
> > with it. There are also client helper applications with MySQL which you
> > can get from www.mysql.com including an administrative GUI and a query
> > helper. As far as everything else the BEST place to start is
> > www.mysql.com/doc Is has everything you need to know.
> >
> > as far as populating it....there are a few ways to do this. PHPMyAdmin
> > seems like the most common interfaces to DL for noobs like you and
> I. It
> > can be found at http://www.phpmyadmin.net. You can also create forms to
> > input data using PHP. You can create text files of code and import them
> > or you can just enter it right from the command prompt. The
> > possibilities are endless. Good luck. (HTH!)
> > jozef
> >
> > Ron Smith wrote:
> >
> > >I'm totally new to MySQL and databases in general. I've done an
> > install of MySQL running on a Windows XP Professional laptop. But
> > I'm a little confused as to how to populate the database. The
> > service is running, the Command Line Client works and '\s' gives the
> > following info after I log in. I'm wondering if this is a typical
> > status report. I also have installed the online documentation, but
> > am wondering where I should start reading.
> > >TIA
> > >ron
> > >
> > >mysql> \s
> > >--------------
> > >C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7
> > Distrib 4.1.11, for Win32 (ia32)
> > >Connection id: 2
> > >Current database:
> > >Current user: root@localhost
> > >SSL: Not in use
> > >Using delimiter: ;
> > >Server version: 4.1.11-nt
> > >Protocol version: 10
> > >Connection: Named pipe: mysql
> > >Server characterset: latin1
> > >Db characterset: latin1
> > >Client characterset: latin1
> > >Conn. characterset: latin1
> > >UNIX socket: mysql
> > >Uptime: 29 min 37 sec
> > >Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush
> > tables: 1 Open tables: 0 Queries per second avg: 0.012
> > >--------------
> > >mysql>
> > >
> > >
> > >
> >
> oops!! Maybe you missed the part where he said he was on XP. No



> or PHP there. PHPmyAdmin is not a good fit for him.
>
> PLEASE DO RTFM - I highly recommend Reading The Fine Manual (there is
> a good tutorial section, I think it's chapter 3) and look for other
> online tutorials. Any good walkthrough will help you get your feet wet
> while explaining what is going on.
>
> What you need to figure out is how to do things in small steps (how to
> create a table, how to add records to the table, how to write a query,
> how to change an existing record, etc.) Start small and work your way
> up. Each step builds on the others. The FULL and DETAILED explanations
> are also in the book but if you learn to skim through all of the extra
> details until you find just the part you need, you will be well on
> your way.
>
> If you have any questions and can't find the answers on your own (you
> will learn more and learn faster if you TRY to find the answer than if
> you are always given the answer first) you are invited and encouraged
> to ask the list. We can all remember the first time we logged into a
> database and how particular computers are about spelling and
> punctuation. The majority of your early mistakes will be in
> translation. You think in one language but the database only
> understands SQL and sometimes it can be rather picky about how you ask
> it to do things.... ;-)
>
> Best Wishes!!
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=geeksatlarge@yahoo.com




--0-1588558099-1112992044=:57326--