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@××××××××××××××.ca
ELECTRIC   /] [] [] [] [] []|  Centre for Urban & Community Studies
TRANSIT    `-O----------O---'  University of Toronto
-- 
gentoo-dev@g.o mailing list