Re: "SHOW VARIABLES" and "mysqladmin variables" show different settings

[rihad rihad]

Rick James Wrote:
-------------------------------------------------------
> Is there a [mysqld] section?
Yup.
> Is the number 1000000 anywhere?
Nope.

> You looked for ~/.my.*, but that assumes _you_ are
> then one encountering the problem. If it is
> another use doing the login, check _his_
> ~him/.my.* And the username that is the *nix
> username, not the mysql username.

Thanks, I can figure out that much :) It's me doing the login and me encountering the problem. We haven't yet moved this box into production in place of the older server but we will soon, so I kind of want to be prepared for that.