[gentoo-dev] New MySQL doc

[gentoo-dev] New MySQL doc

[Chris White]

[-- Attachment #1: Type: text/plain, Size: 173 bytes --]

Here's the initial devspace draft of the new MySQL draft I've been working on:

http://dev.gentoo.org/~chriswhite/mysql.html

Comments, etc are welcome.

Chris White

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] New MySQL doc

[John Myers]

[-- Attachment #1: Type: text/plain, Size: 599 bytes --]

On Monday 11 July 2005 21:38, Chris White wrote:
> http://dev.gentoo.org/~chriswhite/mysql.html
>
> Comments, etc are welcome.

You might want to make
	Code listing 4.19: Finding our guest user in the user table
a little narrower, as it makes the page much wider than my 1,280 pixel wide 
screen can show.

I would suggest 
	SELECT Host, User, Password FROM user WHERE User = 'guest';
rather than
	SELECT * FROM user WHERE User = 'guest';
which will make the output much, much smaller. You might want to mention the 
other query in passing for the user to try on their own, however.

[-- Attachment #2: Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-dev] New MySQL doc

[John Myers]

[-- Attachment #1: Type: text/plain, Size: 358 bytes --]

On Monday 11 July 2005 21:38, Chris White wrote:
> http://dev.gentoo.org/~chriswhite/mysql.html
>
> Comments, etc are welcome.
Sorry for posting twice, but
	Code listing 4.11: REVOKE format
is incorrect. It probably should say
	REVOKE [privleges] ON database.* FROM '[user]'@'[host]';
rather than
	PRIVLEGES [privleges] ON database.* FROM '[user]'@'[host]';

[-- Attachment #2: Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-dev] New MySQL doc

[Francesco R]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Chris White wrote:

>Here's the initial devspace draft of the new MySQL draft I've been
working on:
>
>http://dev.gentoo.org/~chriswhite/mysql.html
>
>Comments, etc are welcome.
>
>Chris White

one reminder:
"Code listing 1.3: MySQL configuration" probably will change for
mysql-4.1 and better (when unmasked)


and having the possibility to scroll the screen,

"Code listing 4.19: Finding our guest user in the user table"
mysql> SELECT * FROM user WHERE User = 'guest';

may become

"Code listing 4.19: Finding our guest user in the user table"
mysql> SELECT * FROM user WHERE User = 'guest' \G

to make it more readable. See J.M. email too


the default my.cnf has the following line
bind-address    = 127.0.0.1
that actually restrict the server access to local  machine only. You
may want to signal this in the "Granting Privleges with GRANT" section.


Last but not last, thankyou -> nice intro document
Francesco R.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
 
iD8DBQFC0tyw1wNBTLVPMuARAroiAJsHl8+M1cOD0Yq2Zlti8kVaMxDnIQCdFIke
NS4BndQanBMCysEuApHAwG0=
=dy9e
-----END PGP SIGNATURE-----

-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] New MySQL doc

[Julien Allanos]

Chris White wrote:
> Here's the initial devspace draft of the new MySQL draft I've been working on:
> 
> http://dev.gentoo.org/~chriswhite/mysql.html
> 
> Comments, etc are welcome.
> 
> Chris White

Nice guide! You might mention phpmyadmin as well, as it's a popular
web-based gui to mysql.
-- 
dju`
Julien Allanos
Gentoo Developer (web-apps)
-- 
gentoo-dev@gentoo.org mailing list

[gentoo-dev] MySQL doc [updated]

[Chris White]

[-- Attachment #1: Type: text/plain, Size: 265 bytes --]

I've updated the MySQL doc here:

http://dev.gentoo.org/~chriswhite/mysql.html

It contains the fixes that have been suggested to me, as well as a note on the SELECT field FROM table form of the SELECT statement.  Thanks for the input recieved!

Chris White

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]

[gentoo-dev] Re:

[Arnaud Launay]

[-- Attachment #1: Type: text/plain, Size: 224 bytes --]

Le Wed, Jul 13, 2005 at 01:22:59AM +0900, Chris White a écrit:
> I've updated the MySQL doc here:
> http://dev.gentoo.org/~chriswhite/mysql.html

Hm, I'd say "privileges" is "privileges", not "privleges" :)

	Arnaud.

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] MySQL doc [updated]

[Philip Webb]

050713 Chris White wrote:
> I've updated the MySQL doc here:
> http://dev.gentoo.org/~chriswhite/mysql.html
> It contains the fixes that have been suggested to me,
> as well as a note on the SELECT field FROM table form
> of the SELECT statement.  Thanks for the input recieved!

As someone who has never used MySQL, but might want to in future,
your help doc looks very useful: thanks for your efforts.

It does need running thro' a spell-checker & a careful proof-reading,
which is always easier for someone else than for the author himself.

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 below];
at the beginning of Sect 2 , you have 'promt';
below '2.1', you don't explain what database 'mysql' is for;
below '2.3', "let's us know" sb [should be] "lets us know";
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 ?
below '3.2', "most simplistic" sb "simplest" or "most straightforward";
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;
under '3.7', "seperated" sb "separated" (other instances below):
  it's a trap for anyone who missed out on Latin at school (smile);
under '3.10', you need to expand your explanation:
  "if you paste information <into your infile>";
under '3.11', "comprimised" sb "compromised":
  3.11-12 looks a bit out of place: perhaps move it below with a cross-ref ?
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 ?
under '3.16', "priveleges" & "privleges" sb "privileges":
  this recurs several times below (grimace);
at the beginning of Sect 4 , the point about root versus users is explained:
  this sb mentioned briefly right at the top in Sect 1 ;
under '4.3', i would write "quitting", but perhaps US-speak is "quiting";
under '4.8', is "admin" the same as "root" ? -- this needs explanation.

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 (above).

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.

HTH : it's meant to be picky (smile).
Your doc looks very helpful, but needs a bit of polishing & expansion.

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

Re: [gentoo-dev] MySQL doc [updated]

[Chris White]

[-- Attachment #1: Type: text/plain, Size: 3981 bytes --]

On Tue, 12 Jul 2005 08:48:50 -0400
Philip Webb <purslow@sympatico.ca> 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.
 
> 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.
 
> 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 below];

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 save 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 <into your infile>";

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

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 explained:
>   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 about 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
 
> 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 (above).

Ok
 
> 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 just a bit.
 
> 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.
> 
> -- 
> ========================,,============================================
> 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
> 
> 

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] MySQL doc [updated]

[Philip Webb]

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

Re: [gentoo-dev] New MySQL doc

[Michiel de Bruijne]

On Tuesday 12 July 2005 06:38, Chris White wrote:
> Here's the initial devspace draft of the new MySQL draft I've been working
> on:
>
> http://dev.gentoo.org/~chriswhite/mysql.html
>
> Comments, etc are welcome.

This is a very good guide! Thanks a lot!!
-- 
gentoo-dev@gentoo.org mailing list

[gentoo-dev] New MySQL doc (update 3)

[Chris White]

[-- Attachment #1: Type: text/plain, Size: 433 bytes --]

Added a bazillion spell fixes, also a list of places to find GUI frontends for MySQL:

Thanks goes to my mom, my dad, my family for all their support
I'd also like to thank the academy for their hard effort
Philip Webb for tolerating my odd grammar/spelling/logic
Bruce Wolk for the same
And most importantly, I'd like to thank the fine folks at Speedy's dinner!

http://dev.gentoo.org/~chriswhite/mysql.html

Chris White

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]