Can't run MySQL
Posted: 11. March 2008 05:58
I just installed Xampp on a new computer. When I tried to run mysql, I got the following error:
[code]
[root@localhost erelsgl]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost erelsgl]# less /opt/lampp/var/mysql/localhost.err
080310 15:59:08 mysqld started
080310 15:59:08 [ERROR] Can't start server : Bind on unix socket: Permission denied
080310 15:59:08 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
080310 15:59:08 [ERROR] Aborting
080310 15:59:08 [Note] /opt/lampp/sbin/mysqld: Shutdown complete
080310 15:59:08 mysqld ended
[root@localhost erelsgl]# ll /opt/lampp/var
total 16
drwxrwxrwx 6 erelsgl erelsgl 4096 2008-03-11 06:46 mysql/
drwxr-xr-x 2 erelsgl erelsgl 4096 2008-03-10 15:59 proftpd/
-rw-r--r-- 1 root root 5 2008-03-10 15:59 proftpd.pid
drwxr-xr-x 2 erelsgl erelsgl 4096 2005-05-31 14:00 run/
[root@localhost erelsgl]# ll /opt/lampp/var/mysql
total 20
drwxrwxrwx 2 erelsgl erelsgl 4096 2003-10-30 00:12 cdcol/
-rwxrwxrwx 1 nobody root 2196 2008-03-11 06:46 localhost.err*
drwxrwxrwx 2 erelsgl erelsgl 4096 2005-10-24 18:42 mysql/
drwxrwxrwx 2 erelsgl erelsgl 4096 2004-12-06 15:56 phpmyadmin/
drwxrwxrwx 2 erelsgl erelsgl 4096 2005-07-12 12:22 test/
[root@localhost erelsgl]# ps -ecf|grep mysql
root 25226 8798 TS 19 06:53 pts/2 00:00:00 grep --color mysql
As you can see, I have no other mysqld running, and no mysql.sock file. I am root and I all files and folders have all permissions.
What should I do?
[code]
[root@localhost erelsgl]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost erelsgl]# less /opt/lampp/var/mysql/localhost.err
080310 15:59:08 mysqld started
080310 15:59:08 [ERROR] Can't start server : Bind on unix socket: Permission denied
080310 15:59:08 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
080310 15:59:08 [ERROR] Aborting
080310 15:59:08 [Note] /opt/lampp/sbin/mysqld: Shutdown complete
080310 15:59:08 mysqld ended
[root@localhost erelsgl]# ll /opt/lampp/var
total 16
drwxrwxrwx 6 erelsgl erelsgl 4096 2008-03-11 06:46 mysql/
drwxr-xr-x 2 erelsgl erelsgl 4096 2008-03-10 15:59 proftpd/
-rw-r--r-- 1 root root 5 2008-03-10 15:59 proftpd.pid
drwxr-xr-x 2 erelsgl erelsgl 4096 2005-05-31 14:00 run/
[root@localhost erelsgl]# ll /opt/lampp/var/mysql
total 20
drwxrwxrwx 2 erelsgl erelsgl 4096 2003-10-30 00:12 cdcol/
-rwxrwxrwx 1 nobody root 2196 2008-03-11 06:46 localhost.err*
drwxrwxrwx 2 erelsgl erelsgl 4096 2005-10-24 18:42 mysql/
drwxrwxrwx 2 erelsgl erelsgl 4096 2004-12-06 15:56 phpmyadmin/
drwxrwxrwx 2 erelsgl erelsgl 4096 2005-07-12 12:22 test/
[root@localhost erelsgl]# ps -ecf|grep mysql
root 25226 8798 TS 19 06:53 pts/2 00:00:00 grep --color mysql
As you can see, I have no other mysqld running, and no mysql.sock file. I am root and I all files and folders have all permissions.
What should I do?