当前位置:   article > 正文

my_print_defaults: [Warning] World-writable config file ‘/usr/local/mysql/my.cnf‘ is ignored.

my_print_defaults: [Warning] World-writable config file ‘/usr/local/mysql/my.cnf‘ is ignored.

操作数据库提示警告World-writable config file '/usr/local/mysql/my.cnf' is ignored

检查发现my.cnf权限过高【777】,将权限更改为644即可。

======================================================================

[root@sc-cgd-01-w-node-0002 init.d]# /etc/init.d/mysqld restart
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
Shutting down MySQL..                                      [  OK  ]
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
Starting MySQL.my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql/my.cnf' is ignored.
                                                           [  OK  ]

[root@sc-cgd-01-w-node-0002 init.d]# ll /usr/local/mysql/my.cnf 
-rwxrwxrwx 1 mysql mysql 1705 Apr  8 10:22 /usr/local/mysql/my.cnf
[root@sc-cgd-01-w-node-0002 init.d]# 
[root@sc-cgd-01-w-node-0002 init.d]# cd /usr/local/mysql/
[root@sc-cgd-01-w-node-0002 mysql]# ll
total 92
drwxr-xr-x  2 mysql mysql  4096 Sep  9  2019 bin
-rw-r--r--  1 mysql mysql 17987 Jun 10  2019 COPYING
-rw-r--r--  1 mysql mysql 17987 Jun 10  2019 COPYING-test
drwxr-xr-x  2 mysql mysql  4096 Sep  9  2019 docs
drwxr-xr-x  2 mysql mysql  4096 Sep  9  2019 extra
drwxr-xr-x  3 mysql mysql  4096 Sep  9  2019 include
drwxr-xr-x  4 mysql mysql  4096 Sep  9  2019 lib
drwxr-xr-x  2 mysql mysql  4096 Apr  8 10:19 logs
drwxr-xr-x  3 mysql mysql  4096 Sep  9  2019 man
-rwxrwxrwx  1 mysql mysql  1705 Apr  8 10:22 my.cnf
drwxrwxr-x 10 mysql mysql  4096 Sep  9  2019 mysql-test
-rw-r--r--  1 mysql mysql  2478 Jun 10  2019 README
-rw-r--r--  1 mysql mysql  2478 Jun 10  2019 README-test
drwxr-xr-x 28 mysql mysql  4096 Sep  9  2019 share
drwxr-xr-x  2 mysql mysql  4096 Sep  9  2019 support-files
[root@sc-cgd-01-w-node-0002 mysql]# chmod 644 my.cnf 
[root@sc-cgd-01-w-node-0002 mysql]# /etc/init.d/mysqld restart
Shutting down MySQL..                                      [  OK  ]
Starting MySQL.                                            [  OK  ]
[root@sc-cgd-01-w-node-0002 mysql]# 
 

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

闽ICP备14008679号