warning: World-writable config file my.cnf is ignored

Problems with the Linux version of XAMPP, questions, comments, and anything related.

warning: World-writable config file my.cnf is ignored

Postby hanpedro » 25. February 2007 10:54

Please look int my problem, and give me some comment.

I have installed fedora 6 and restored mysql data.
After installing xampp for linux, I ran lampp start.
The, this error message came out.

Starting XAMPP for Linux 1.4.13...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
warning: World-writable config file /opt/lampp/etc/my.cnf is ignored
warning: World-writable config file /opt/lampp/etc/my.cnf is ignored
warning: World-writable config file /opt/lampp/etc/my.cnf is ignored
XAMPP for Linux started.

(exactly 3 times.)

And, my.cnf is

[client]
default-character-set = utf8
#password = your_password
port = 3306
socket = var/mysql/mysql.sock

[mysqld]
default-character-set = utf8
port = 3306
socket = /var/mysql/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M

skip-innodb

[mysqldump]
default-character-set = utf8
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

Any comment would be appreciated.
hanpedro
 
Posts: 133
Joined: 09. February 2005 06:03
Operating System: SCientific Linux 6.1 x86

Postby JKMickelson » 26. February 2007 22:11

warning: World-writable config file /opt/lampp/etc/my.cnf is ignored
...
Any comment would be appreciated.

I have seen warnings like this before, and as a developer, I have written them. I could not find an explicit answer on via Google, but here is my answer.

MySQL is deliberately ignoring your config file (my.cnf) as a safety precaution because the file can be over-written by a malicious user.

To see the file's permissions, use the following command.
Code: Select all
ls -l /opt/lampp/etc/my.cnf

in response, you will see
-rw-r--r-- 1 root root 4998 Oct 28 2005 /opt/lampp/etc/my.cnf


If the first part of the line looks like "-rw-rw-rw-" or "rwxrwxrwx", the file's permissions are "World-writable".

To fix this problem, use the following command to change file's permissions
Code: Select all
chmod 644 /opt/lampp/etc/my.cnf

It will not display anything. Use this command again to see the change.
Code: Select all
ls -l /opt/lampp/etc/my.cnf

Your file listing should look like the second quote listed above
JKMickelson
 
Posts: 30
Joined: 23. February 2007 09:56


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests