[gentoo-user] New MySQL doc

[gentoo-user] 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-user] New MySQL doc

[Matthew Cline]

On 7/12/05, Chris White <chriswhite@gentoo.org> 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.

I think this is very good. I liked the discussion on user privilages,
but maybe it would be possible/a good idea to add an explicit
discussion of MySQL security issues.

Also, just a minor typo right under "Creating a Database:"

"We now have a mysql promt displayed"

Overall, a nice guide.

Matt

-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] New MySQL doc

[Dave Nebinger]

> 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.

While the document is a good and short intro to MySQL, I still have to ask
"why?"  Aren't there enough similar good short introductions?

As far as the gentoo-specific stuff, there's no mention of how to
MySQL-enable other packages, no mention of why you would want to do the
"ebuild ... config" step and not the simpler "emerge mysql", ...

Seriously, I'm not trying to rain on your parade, Chris; I'm just trying to
figure out why we need this?



-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] New MySQL doc

[Nick Rout]

On Mon, 11 Jul 2005 16:20:50 -0400
Dave Nebinger wrote:

> As far as the gentoo-specific stuff, there's no mention of how to
> MySQL-enable other packages, no mention of why you would want to do the
> "ebuild ... config" step and not the simpler "emerge mysql", ...

emerge mysql does not do ebuild .... config. 

the config step only needs to be carried out the very first time mysql
is emerged. Thats why the instructions that appear at the end of the
emerge say:

"You might want to run:
"ebuild /var/db/pkg/dev-db/mysql-4.0.24-r1/mysql-4.0.24-r1.ebuild config"
IF THIS IS A NEW INSTALL." (my emphasis added)

Yes it might be wise to add in something about adding the mysql USE
flag, either globally or per package, to get mysql functionality into
other packages.

As for your other question (why is it needed?) - I guess for me this is
the simplest and most to the point exposition of setting up mysql I have
found. The forums and mailing list seem to reveal that the steps of
setting initial databases and permissions is one where newbies have some
difficulties. I like it. 

I am often referring non gentoo users to the fine gentoo documentation.
Keep it coming.



-- 
Nick Rout

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] Re: New MySQL doc

[Francesco Talamona]

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.

SQL
     Structured Query Language
     ^^^^^^
"S" doesn't stand for "standard".
Good guide, thanks
	Francesco
-- 
Linux Version 2.6.11-gentoo-r11, Compiled #1 Thu Jun 23 05:26:18 CEST
One 2.2GHz AMD Athlon 64 Processor, 2GB RAM, 4308.99 Bogomips Total
aemaeth
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] New MySQL doc

[kashani]

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.


	Mysql is bound to localhost by default in Gentoo. I'd add a note and 
make it blink in gigantic neon letters. That's the number one problem 
users have in the forums. An explanation of how to change that in the 
my.cnf and some of the security implications of that would probably be a 
good idea as well.

	Adding privileges for remote users. You do a good job with adding 
access from localhost, but there isn't any mention of adding access for 
a user from any IP. Additionally it might be nice to show how to allow a 
user access from a particular subnet as well a single IP. You may also 
want to mention that things like phpmyadmin should connect to localhost 
if they are on the same server instead of the hostname which is a common 
mistake.

	The root user is just a convention. I've also seen a number of post 
where users seem to think that the root user is somehow special in Mysql 
rather than a Gentoo/distro default user that has been granted admin 
privileges. You might want to shoot for a much broader explanation of 
users accounts than what you currently have mostly centering around the 
fact that Mysql accounts are separate from system accounts.

	On the subject of USE variables you may want to mention that in 4.0.x 
innodb is not turned on by default while in 4.1.x or greater it will be 
due to a request from upstream. Also mention that innodb will need to be 
turned on within the my.cnf file as it is not on by default.

	Another common forum question is how to completely remove all Mysql 
databases and start from scratch though there might be less call for 
this if users are able to set Mysql up correctly from the get go. How to 
reset the admin password is another common question in the same vein.

	If you're aiming for a more complete doc, you might also want to 
demonstrate a SELECT * FROM $table WHERE $field LIKE '%$string%' as 
that's another handy select beginners will find useful. Also adding 
LIMIT 10 or COUNT (*) are other good ones. Some mention of mysqldump and 
restoring from a dump might also be interesting. myisamchk and turning 
on bin-logs for data recovery if needed would also be nice. And finally 
the default my.cnf isn't tuned towards a dedicated Mysql installation. 
Users may want to at my-huge.cnf in 
/usr/share/doc/mysql-version/conf-sampples. Most of this last part is 
probably way outside your planned scope, but it is stuff that has come 
up on the forums.

	All in all this is a well written and readable doc. It'll help a number 
of users. Nice job.

kashani
-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] 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-user] Re: MySQL doc [updated]

[Francesco Talamona]

On Tuesday 12 July 2005 18:22, 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!
>
> Chris White
your doc states:
SQL stands for (S)tandard (Q)uery (L)anguage

but Virtual Entity of Relevant Acronyms (Version 1.9, June 2002) [vera] 
says:
SQL
     Structured Query Language (ISO 9075, DB, 4GL)

and The Free On-line Dictionary of Computing (27 SEP 03) [foldoc] says:
According to Allen G. Taylor, SQL does _not_ stand for
"Structured Query Language".  That, like "SEQUEL" (and its
pronunciation /see'kw*l/), was just another unofficial name
for a precursor of SQL.  However, the IBM SQL Reference manual
for DB2 and Craig Mullins's "DB2 Developer's Guide" say SQL
_does_ stand for "Structured Query Language".

So I think you have to correct (S)tandard to (S)tructured

Ciao
	Francesco

-- 
Linux Version 2.6.9, Compiled #1 Tue Dec 28 11:57:18 CET 2004
One 946MHz Intel Celeron Processor, 255M RAM, 1875.96 Bogomips Total
TecSW4
-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] 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 --]

Re: [gentoo-user] New MySQL doc (update 3)

[Kevin Hanson]

Chris White wrote:

>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
>  
>
I know you've seen this twice from other replies, but you still haven't
changed it.  It's not Standard Query Language, it's Structured Query
Language.

Cheers,
Kevin
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] New MySQL doc (update 3)

[kashani]

Chris White wrote:
> 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

Default installations of MySQL are bound only to localhost by way of the 
line bind-address = 127.0.0.1 in my.cnf is a fact that really needs to 
be addressed in your doc.

http://forums.gentoo.org/viewtopic-t-356728.html
http://forums.gentoo.org/viewtopic-t-349692.html
http://forums.gentoo.org/viewtopic-t-344032.html
http://forums.gentoo.org/viewtopic-t-303769.html
http://forums.gentoo.org/viewtopic-t-300745.html
http://forums.gentoo.org/viewtopic-t-282209.html
http://forums.gentoo.org/viewtopic-t-225581.html
http://forums.gentoo.org/viewtopic-t-206368.html
http://forums.gentoo.org/viewtopic-t-150044.html

kashani
-- 
gentoo-user@gentoo.org mailing list