chown -R mysql /var/lib/mysql
david wright wrote:
>I can't seem to run MySql:
>ERROR 2002: Can't connect to local MySQL server through socket
>as you can see '/var/lib/mysql/mysql.sock' does exist
>
>I know i'm just missing something but i've been over this a few times, any
>ideas?
>[root@RR lib]# pwd
>/var/lib
>[root@RR lib]# l
>total 44
>drwxrwxrwt 2 root root 4096 Sep 23 2001 cddb
>drwxr-xr-x 2 root root 4096 Dec 29 14:11 games
>-rw-r--r-- 1 root root 220 Jan 1 1904 logrotate.status
>drwxr-xr-x 2 root root 4096 May 15 2000 misc
>drwxr-xr-x 4 mysql mysql 4096 Jun 20 02:35 mysql
>drwxr-xr-x 3 root root 4096 Dec 29 14:10 nfs
>drwxr-xr-x 2 root root 4096 Feb 14 1996 rpm
>drwxr-x--- 2 root slocate 4096 Jun 19 16:26 slocate
>drwxrwxrwt 2 root root 4096 Dec 29 14:10 texmf
>drwxr-xr-x 3 root root 4096 Dec 29 14:14 xdm
>drwxr-xr-x 2 root root 4096 Dec 31 15:27 xkb
>[root@RR lib]# mysql
>ERROR 2002: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
>[root@RR lib]# l /var/lib/mysql/
>total 8
>drwx------ 2 root root 4096 Jun 20 02:26 mysql
>srwxrwxrwx 1 mysql mysql 0 Jun 20 02:35 mysql.sock
>drwx------ 2 root root 4096 Jun 20 02:26 test
>
>
>checking the error logs produces:
>[root@RR bin]# cat /var/log/mysqld.log
>020620 02:32:00 mysqld started
>020620 2:32:01 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
>(errno: 13)
>020620 02:32:01 mysqld ended
>
>020620 02:35:22 mysqld started
>020620 2:35:22 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
>(errno: 13)
>020620 02:35:22 mysqld ended
>
>
>But as you can see './mysql/host.frm' exists in /var/lib/mysql/mysql:
>[root@RR bin]# l /var/lib/mysql/mysql
>total 104
>-rw-rw---- 1 root root 0 Jun 20 02:26 columns_priv.MYD
>-rw-rw---- 1 root root 1024 Jun 20 02:26 columns_priv.MYI
>-rw-rw---- 1 root root 8778 Jun 20 02:26 columns_priv.frm
>-rw-rw---- 1 root root 302 Jun 20 02:26 db.MYD
>-rw-rw---- 1 root root 3072 Jun 20 02:26 db.MYI
>-rw-rw---- 1 root root 8982 Jun 20 02:26 db.frm
>-rw-rw---- 1 root root 0 Jun 20 02:26 func.MYD
>-rw-rw---- 1 root root 1024 Jun 20 02:26 func.MYI
>-rw-rw---- 1 root root 8641 Jun 20 02:26 func.frm
>-rw-rw---- 1 root root 0 Jun 20 02:26 host.MYD
>-rw-rw---- 1 root root 1024 Jun 20 02:26 host.MYI
>-rw-rw---- 1 root root 8958 Jun 20 02:26 host.frm
>-rw-rw---- 1 root root 0 Jun 20 02:26 tables_priv.MYD
>-rw-rw---- 1 root root 1024 Jun 20 02:26 tables_priv.MYI
>-rw-rw---- 1 root root 8877 Jun 20 02:26 tables_priv.frm
>-rw-rw---- 1 root root 428 Jun 20 02:26 user.MYD
>-rw-rw---- 1 root root 2048 Jun 20 02:26 user.MYI
>-rw-rw---- 1 root root 9148 Jun 20 02:26 user.frm
>
>thanks - this is Yellow Dog Linux on PowerPC by the way, but it shouldn't
>mattter this is from a already compiled source distro CD.
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread112544@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
