Invalid Ubuntu case-insensitive binary log Modification

1. Ubuntu MySQL is case sensitive by default.

Set lower_case_table_names = 1 in my. CNF.

Setting and restarting MySQL does not work.

 

Mysql> show variables like 'lower _ case_table_names ';
+ ------------------------ + ------- +
| Variable_name | value |
+ ------------------------ + ------- +
| Lower_case_table_names | 0 |
+ ------------------------ + ------- +
1 row in SET (0.00 Sec)

2, add log-bin =/var/log/mysql-bin.log in my. CNF

Restart

Mysql> show variables like '% log_bin % ';
+ --------------------------------- + ------- +
| Variable_name | value |
+ --------------------------------- + ------- +
| Log_bin | off |
| Log_bin_trust_function_creators | off |
| SQL _log_bin | on |
+ --------------------------------- + ------- +
3 rows in SET (0.01 Sec)

That is to say, modification to my. CNF does not work for MySQL.

It may be that/etc/MySQL/My. CNF is not configured in MySQL.

Rename my. CNF to my_current.cnf to restart ....

However, when the MySQL service is restarted
[Email protected]: ~ #/Etc/init. d/MySQL restart
* Stopping MySQL database server mysqld warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
Warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
[OK]
Warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
* Starting MySQL database server mysqld warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
Warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
Warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
Warning: World-Writable Config File '/etc/MySQL/My. CNF' is ignored
Follow this warning command to modify my. CNF permission 744 and restart the service.

Invalid Ubuntu case-insensitive binary log Modification