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@g.o mailing list