Bug 152139

Summary: possible improvement on defaults in /etc/my.cnf .
Product: [openSUSE] SUSE LINUX 10.0 Reporter: Olli Artemjev <grey-olli>
Component: OtherAssignee: Michal Marek <mmarek>
Status: RESOLVED WONTFIX QA Contact: E-mail List <qa-bugs>
Severity: Enhancement    
Priority: P4 - Low CC: grey-olli, suse-beta
Version: FinalKeywords: easy_fix, Fix_No_Build, patch
Target Milestone: ---   
Hardware: All   
OS: SuSE Linux 10.0   
Whiteboard:
Found By: Customer Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

Description Olli Artemjev 2006-02-20 03:14:26 UTC 
I suggest to add the following into /etc/my.cnf:

--------cut-------------
## uncomment if'd like mysql use this:
#language        = /usr/share/mysql/english

[mysql]
## uncomment if'd like mysql use this:
#no-auto-rehash # faster start of mysql but no tab completition

## keep secure by default. Comment this out to allow mysqld binding on other
## interfaces:
bind-address    = 127.0.0.1

--------cut-------------

I'm just curiouse - noone use mysql console? Complitions are good for console.
So I suggest to comment currently used by default 'no-auto-rehash'.
Last time I had to configure mysql I've used manual & other sources.. Now just compared results on diffrent mine servers to defaults with.
Comment 1 Olli Artemjev 2006-02-20 03:20:17 UTC 
The 1st commented out entry 'language=' should be put on some section.. 
The last should be under [mysqld].
Comment 2 Olli Artemjev 2006-02-20 04:02:46 UTC 
oops.. seems need to get to smoke some dox. )) Complition doesn't work. Even if no-auto-rehash  is commented. :(
Comment 3 Michael Gross 2006-02-20 10:38:06 UTC 
I agree, the completion feature does not take much time and is very useful.
Comment 4 Michal Marek 2006-02-27 13:16:18 UTC 
(In reply to comment #0)
> I suggest to add the following into /etc/my.cnf:
> 
> --------cut-------------
> ## uncomment if'd like mysql use this:
> #language        = /usr/share/mysql/english

??

> [mysql]
> ## uncomment if'd like mysql use this:
> #no-auto-rehash # faster start of mysql but no tab completition

Then add 'auto-rehash' to your ~/.my.cnf. In fact, having the client
configuration in /etc/my.cnf is pointless, because /etc/my.cnf is 0660.
We just use one of the upstream config files (my-medium.cnf), that's why
it's there.


> ## keep secure by default. Comment this out to allow mysqld binding on other
> ## interfaces:
> bind-address    = 127.0.0.1

No, we won't do such a change that can break working setups. At least
not in beta phase.
Comment 5 Olli Artemjev 2006-03-01 11:04:11 UTC 
As about language - some people prefer not to use localisation for some programms.
The translation quality is some times low & having for example reports in localised way is somewhat alike to looking to the thing "via mind of translator". =)

PS: I'm still amused by translators of Novell Netware 3.11 to russian. The translation of 'untill not loaded' if translated back to english will look like 'untill loaded'. :D That's funny after years. Though was not too funny to spend  more time than required to get the things work. %)