首页 > 代码库 > ubuntu 大小写 二进制日志 修改无效

ubuntu 大小写 二进制日志 修改无效

1,ubuntu mysql 默认区分大小写。

让他不区分,就在my.cnf中设置lower_case_table_names=1

设置后重启mysql 发现没有起作用。

 


mysql> show variables like ‘lower_case_table_names‘ ;
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 0     |
+------------------------+-------+
1 row in set (0.00 sec)

2,在my.cnf加log-bin=/var/log/mysql-bin.log

重启

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)

就是说my.cnf修改对mysql不起作用

可能是不用/etc/mysql/my.cnf 不是mysql的配置。

把my.cnf重命名为my_current.cnf 可以重启。。。。

但是突然在重启mysql服务的时候
root@slav-Vostro:~# /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
按照这个Warning修改my.cnf权限 744,重启服务,成功。

ubuntu 大小写 二进制日志 修改无效