never mind. Now I’m sure the default path is /etc/my.cnf and I made a mistake while testing. Configurations in configure file is global variable and should use “show global variable” to show it.
On Feb 15, 2016, at 12:43 PM, 许若辰 <[email protected]<mailto:[email protected]>> wrote: Hi friends, I want to use mysql in smartos zone c540b62c-beb2-11e5-8512-8b1694a57f84 But I find that the default path /opt/local/my.cnf is useless, also I’ve tried /etc/my.cnf /etc/mysql/my.cnf /opt/local/mysql/my.cnf, but none of them work. So how can I configure my mysql? [mysqld] wait_timeout = 14400 mysql> SHOW VARIABLES LIKE 'wait_timeout'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) Thanks. smartos-discuss | Archives<https://www.listbox.com/member/archive/184463/=now> [https://www.listbox.com/images/feed-icon-10x10.jpg1d3216c.jpg?uri=aHR0cHM6Ly93d3cubGlzdGJveC5jb20vaW1hZ2VzL2ZlZWQtaWNvbi0xMHgxMC5qcGc] <https://www.listbox.com/member/archive/rss/184463/27846711-c61ff54c> | Modify<https://www.listbox.com/member/?&;> Your Subscription [https://www.listbox.com/images/listbox-logo-small.png1d3216c.png?uri=aHR0cHM6Ly93d3cubGlzdGJveC5jb20vaW1hZ2VzL2xpc3Rib3gtbG9nby1zbWFsbC5wbmc] <http://www.listbox.com/> ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
