From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1DsjZx-0002XM-El for garchives@archives.gentoo.org; Wed, 13 Jul 2005 15:55:21 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j6DFrdCa027032; Wed, 13 Jul 2005 15:53:39 GMT Received: from tomts16-srv.bellnexxia.net (tomts16.bellnexxia.net [209.226.175.4]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j6DFpw3A032525 for ; Wed, 13 Jul 2005 15:51:59 GMT Received: from sympatico.ca ([70.49.116.234]) by tomts16-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with SMTP id <20050713155300.MPFL27508.tomts16-srv.bellnexxia.net@sympatico.ca> for ; Wed, 13 Jul 2005 11:53:00 -0400 Received: by sympatico.ca (sSMTP sendmail emulation); Wed, 13 Jul 2005 11:52:59 -0400 Date: Wed, 13 Jul 2005 11:52:59 -0400 From: Philip Webb To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] MySQL doc [updated] Message-ID: <20050713155259.GB7169@sympatico.ca> Mail-Followup-To: gentoo-dev@lists.gentoo.org References: <20050712133816.74d66597@localhost> <20050713012259.36dd9dcc@localhost> <20050712124850.GA7573@sympatico.ca> <20050713182331.21816b9c@localhost> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Reply-to: gentoo-dev@lists.gentoo.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050713182331.21816b9c@localhost> User-Agent: Mutt/1.5.8i X-Archives-Salt: b113639b-a8f3-4247-b871-ee241081f577 X-Archives-Hash: be0c5b973d8b9bbe0038d1b9baf5c117 050713 Chris White wrote: > 050712 Philip Webb wrote: >> Someone has already pointed out that it's 'Structured', not 'Standard'. As ditto, it's still not corrected 050713 1132 EST. >> under '[code list] 1.4', why do we need a root password ? >> are you not setting this up as a user ? eg if I use MySQL, >> it will be to manage a large database of urban transit information, >> which I will do entirely inside my desktop machine >> with no access to other users or to the Internet [ok: I see Sect 4 below]; > Fixed, init script does, actual admin login doesn't "The configuration recommends that you change your root password as soon as possible". This remains very misleading to a novice: you need to add a sentence eg "Note: your MySQL 'root' password is not the same as your system 'root': it refers to the administrator of your MySQL installation, not the admin of your whole system." >> below '2.1', you don't explain what database 'mysql' is for; > Don't see exactly where this is in reference to. mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | <<<<<<<<<<< this one: what is it ? <<<<<<<<<<<<< | test | +----------+ 2 rows in set (0.09 sec) >> under 'Creating the tables', it looks very much like a spreadsheet: >> perhaps you could point out the parallels; >> can you import data directly from a spreadsheet like Open Calc ? > Not sure if I quite understand this corectly. With a spreadsheet, you have files > sheets > rows + cols = cells ; with MySQL, you seem to have databases > tables > cases + fields ; with both, the cells/equivalent can be formatted. Is there a way to copy data between eg OO Calc & MySQL similarly ? >> below '3.2', "most simplistic" sb "simplest" or "most straightforward"; > Fixed Not yet in your public version. >> under '3.14', why do the columns not line up in your examples ? >> is this a deficiency in MySQL or a result of your desktop set-up ? > not sure what you mean there, they look fine to me Sorry, my mistake: I was misled by the variable-spaced font in Firefox. >> One final point you don't mention: is there a GUI front-end for MySQL ? > Adding a section on that right now. Excellent ! This looks like a really useful doc. -- ========================,,============================================ SUPPORT ___________//___, Philip Webb : purslow@chass.utoronto.ca ELECTRIC /] [] [] [] [] []| Centre for Urban & Community Studies TRANSIT `-O----------O---' University of Toronto -- gentoo-dev@gentoo.org mailing list