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 1DsVWU-00049l-6e for garchives@archives.gentoo.org; Wed, 13 Jul 2005 00:54:50 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j6D0rG20029956; Wed, 13 Jul 2005 00:53:16 GMT Received: from sls-ce5p321.hostitnow.com (sls-ce5p321.hostitnow.com [72.9.236.50]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j6D0opjY003100 for ; Wed, 13 Jul 2005 00:50:51 GMT Received: from c-67-181-38-200.hsd1.ca.comcast.net ([67.181.38.200] helo=localhost) by sls-ce5p321.hostitnow.com with esmtpa (Exim 4.50) id 1DsVTK-0007qI-UZ for gentoo-dev@lists.gentoo.org; Tue, 12 Jul 2005 19:51:35 -0500 Date: Wed, 13 Jul 2005 18:23:30 +0900 From: Chris White To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] MySQL doc [updated] Message-ID: <20050713182331.21816b9c@localhost> In-Reply-To: <20050712124850.GA7573@sympatico.ca> References: <20050712133816.74d66597@localhost> <20050713012259.36dd9dcc@localhost> <20050712124850.GA7573@sympatico.ca> Organization: Gentoo X-Mailer: Sylpheed-Claws 1.9.12 (GTK+ 2.6.8; i686-pc-linux-gnu) 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: multipart/signed; boundary=Signature_Wed__13_Jul_2005_18_23_31_+0900_bBKHq4HI9vHz49Hz; protocol="application/pgp-signature"; micalg=pgp-sha1 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sls-ce5p321.hostitnow.com X-AntiAbuse: Original Domain - lists.gentoo.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - gentoo.org X-Source: X-Source-Args: X-Source-Dir: X-Archives-Salt: ff3dbafc-6670-49b9-a88a-64876b01c27a X-Archives-Hash: 77fc52d35b280b27c4ff27f4fc5c1c50 --Signature_Wed__13_Jul_2005_18_23_31_+0900_bBKHq4HI9vHz49Hz Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Tue, 12 Jul 2005 08:48:50 -0400 Philip Webb wrote: > As someone who has never used MySQL, but might want to in future, > your help doc looks very useful: thanks for your efforts. Not a problem. =20 > It does need running thro' a spell-checker & a careful proof-reading, > which is always easier for someone else than for the author himself. Yah, I know, the docs-team makes fun of me daily for it ;p. =20 > Someone has already pointed out that it's 'Structured', not 'Standard'. > 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 belo= w]; Fixed, init script does, actual admin login doesn't > at the beginning of Sect 2 , you have 'promt'; Fixed > below '2.1', you don't explain what database 'mysql' is for; Don't see exactly where this is in reference to. > below '2.3', "let's us know" sb [should be] "lets us know"; Fixed > 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. Most spredsheet programs sav= e to comma seperated files, which MySQL file loading requires tab seperated= files. > below '3.2', "most simplistic" sb "simplest" or "most straightforward"; Fixed > under '3.6', you should explain that you are using 'insert into' > to insert a new record (if that's what it does), not arbitrary data; Fixed > under '3.7', "seperated" sb "separated" (other instances below): > it's a trap for anyone who missed out on Latin at school (smile); I was told that by someone else :P Fixed > under '3.10', you need to expand your explanation: > "if you paste information "; Fixed that + another "seperation" > under '3.11', "comprimised" sb "compromised": > 3.11-12 looks a bit out of place: perhaps move it below with a cross-re= f ? Fixed > 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 > under '3.16', "priveleges" & "privleges" sb "privileges": > this recurs several times below (grimace); Twice in one paragraph, nice ;p Fixed > at the beginning of Sect 4 , the point about root versus users is explain= ed: > this sb mentioned briefly right at the top in Sect 1 ; Actually, it's a root mysql account, not the system root, I made a note abo= ut that. > under '4.3', i would write "quitting", but perhaps US-speak is "quiting"; Fixed > under '4.8', is "admin" the same as "root" ? -- this needs explanation. Clarified =20 > I've skipped over all the stuff about user privileges, > as it looks as if my own usage would be as "root" in the MySQL sense (abo= ve). Ok =20 > One final point you don't mention: is there a GUI front-end for MySQL ? > I'm sure there is, so which one(s) do you recommend ? > For myself, I'm happy to use CLI where it's simplest, > but it looks as if a GUI would save a lot of typing injuries here. Adding a section on that right now... I'll post the new updated page in ju= st a bit. =20 > HTH : it's meant to be picky (smile). Sure, sure, just take away my freedom!!! ;) > Your doc looks very helpful, but needs a bit of polishing & expansion. >=20 > --=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D,= ,=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > SUPPORT ___________//___, Philip Webb : purslow@chass.utoronto.ca > ELECTRIC /] [] [] [] [] []| Centre for Urban & Community Studies > TRANSIT `-O----------O---' University of Toronto > --=20 > gentoo-dev@gentoo.org mailing list >=20 >=20 --Signature_Wed__13_Jul_2005_18_23_31_+0900_bBKHq4HI9vHz49Hz Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFC1N2aFdQwWVoAgN4RAl8dAKCYsNT+jqOUtc7/RX090kRbjtBbQgCcCYPr gaS4/sMUEQGZ2Fz6EgR4Eqg= =8ZnD -----END PGP SIGNATURE----- --Signature_Wed__13_Jul_2005_18_23_31_+0900_bBKHq4HI9vHz49Hz-- -- gentoo-dev@gentoo.org mailing list