当前位置:   article > 正文

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,重启服务,成功。

转载于:https://www.cnblogs.com/bashala/p/3968032.html

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/小蓝xlanll/article/detail/705118
推荐阅读
相关标签
  

闽ICP备14008679号