Bugzilla – Bug 152139
possible improvement on defaults in /etc/my.cnf .
Last modified: 2006-03-01 11:04:11 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.
The 1st commented out entry 'language=' should be put on some section.. The last should be under [mysqld].
oops.. seems need to get to smoke some dox. )) Complition doesn't work. Even if no-auto-rehash is commented. :(
I agree, the completion feature does not take much time and is very useful.
(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.
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. %)