Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Rien on May 01, 2004, 07:49:10 PM

Title: HELP MySQL error
Post by: Rien on May 01, 2004, 07:49:10 PM

Hi,

I get the following MySQL-error:

Quote

warning: World-writeable config file /root/.my.cnf is ignored
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

What should I do?

Rien

Title: HELP MySQL error
Post by: Anonymous on May 01, 2004, 11:19:05 PM

The error is obvious (so it seems):

Change the attributes of /root/.my.cnf to 640 (or better 600):

chmod 600 /root/.my.cnf

Then it should work as designed.

Title: HELP MySQL error
Post by: Rien on May 02, 2004, 12:01:19 AM

Thank you very much, I was afraid I had to install the server again.

I obviously changed the permissions of the whole /root directory. Can you tell me what the permissions must be of the other files in the /root directory?

Rien

Title: HELP MySQL error
Post by: bobk on May 02, 2004, 04:34:49 AM

Quote from: "Rien"

Thank you very much, I was afraid I had to install the server again.

I obviously changed the permissions of the whole /root directory. Can you tell me what the permissions must be of the other files in the /root directory?

Rien

Code: [Select]

[root@XXXXXXX root]# ls -all
total 136
drwxr-x---    5 root     root         4096 May  2 09:50 .
drwxr-xr-x   21 root     root         4096 Apr 18 11:07 ..
-rw-r--r--    1 root     root          740 Mar  7 09:55 anaconda-ks.cfg
-rw-------    1 root     root         9905 Apr 29 08:41 .bash_history
-rw-r--r--    1 root     root           24 Jun 11  2000 .bash_logout
-rw-r--r--    1 root     root          234 Jul  6  2001 .bash_profile
-rw-r--r--    1 root     root          176 Aug 24  1995 .bashrc
drwx------    2 root     root         4096 Mar  7 13:11 .cedit
-rw-r--r--    1 root     root          210 Jun 11  2000 .cshrc
-rw-r--r--    1 root     root        12152 Mar  7 09:55 install.log
-rw-r--r--    1 root     root        49152 Mar  7 09:56 install.log.syslog
drwxr-xr-x    3 root     root         4096 May  2 10:32 .mc
-rw-------    1 root     root          636 Mar  7 10:04 .my.cnf
-rw-------    1 root     root         1024 Mar  7 10:02 .rnd
drwx------    2 root     root         4096 Apr 20 07:18 .ssh
-rw-r--r--    1 root     root          196 Jul 11  2000 .tcshrc
-rw-r--r--    1 root     root         3877 Jun 27  2003 .vimrc
-rw-r--r--    1 root     root         1126 Aug 24  1995 .Xresources
-rw-r--r--    1 root     root          312 Feb 24 10:01 yum-e-smith-antivirus.conf


Title: HELP MySQL error
Post by: Rien on May 02, 2004, 12:44:02 PM

Thank you very much again. It works fine now.

Rien