赞
踩
操作数据库提示警告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]#
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。