mysql 服务器监听的套接字,通过套接字连接到本地MySQL服务器

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I tried everything I found on internet, but cannot solve the problem on Ubuntu 11.04.

I tried these things:

started mysqld manually using sudo /usr/sbin/mysqld start

started mysqld using service mysqld start

Checked it is running using ps ax | grep mysqld and got result 3419 pts/0 S+ 0:00 grep --color=auto mysqld

created the file manually at/var/run/mysqld/mysqld.sock

Gave rights to mysql user

Tried to remove and re-install but it still do not work

Tried tasksel to configure LAMP, every thing else works but mysql generate same error.

When run with mysqld -P 3305 it generates the error

110630 0:24:24 [Warning] Can't create test file /var/lib/mysql/nazar-studio.lower-test

110630 0:24:24 [Warning] Can't create test file /var/lib/mysql/nazar-studio.lower-test

mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)

110630 0:24:24 [ERROR] Aborting

110630 0:24:24 [Note] mysqld: Shutdown complete

Here is the mysql error log

10630 0:07:22 [Note] Plugin 'FEDERATED' is disabled.

110630 0:07:22 InnoDB: Initializing buffer pool, size = 8.0M

110630 0:07:22 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file ./ibdata1 did not exist:

InnoDB: a new database to be created!

110630 0:07:22 InnoDB: Setting file ./ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

110630 0:07:22 InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

110630 0:07:22 InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

110630 0:07:23 InnoDB: Started; log sequence number 0 0

110630 0:07:23 InnoDB: Starting shutdown...

110630 0:07:28 InnoDB: Shutdown completed; log sequence number 0 44233

110630 0:07:28 [Note] Plugin 'FEDERATED' is disabled.

110630 0:07:28 InnoDB: Initializing buffer pool, size = 8.0M

110630 0:07:28 InnoDB: Completed initialization of buffer pool

110630 0:07:28 InnoDB: Started; log sequence number 0 44233

ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1

110630 0:07:28 [ERROR] Aborting

110630 0:07:28 InnoDB: Starting shutdown...

110630 0:07:34 InnoDB: Shutdown completed; log sequence number 0 44233

110630 0:07:34 [Note] /usr/sbin/mysqld: Shutdown complete

110630 0:07:34 [Note] Plugin 'FEDERATED' is disabled.

110630 0:07:34 InnoDB: Initializing buffer pool, size = 8.0M

110630 0:07:34 InnoDB: Completed initialization of buffer pool

110630 0:07:34 InnoDB: Started; log sequence number 0 44233

110630 0:07:34 InnoDB: Starting shutdown...

110630 0:07:39 InnoDB: Shutdown completed; log sequence number 0 44233

110630 0:07:39 [Note] Plugin 'FEDERATED' is disabled.

110630 0:07:39 InnoDB: Initializing buffer pool, size = 8.0M

110630 0:07:39 InnoDB: Completed initialization of buffer pool

110630 0:07:39 InnoDB: Started; log sequence number 0 44233

ERROR: 1050 Table 'plugin' already exists

110630 0:07:39 [ERROR] Aborting

110630 0:07:39 InnoDB: Starting shutdown...

110630 0:07:44 InnoDB: Shutdown completed; log sequence number 0 44233

110630 0:07:44 [Note] /usr/sbin/mysqld: Shutdown complete

110630 0:18:30 [Note] Plugin 'FEDERATED' is disabled.

110630 0:18:30 InnoDB: Initializing buffer pool, size = 8.0M

110630 0:18:30 InnoDB: Completed initialization of buffer pool

110630 0:18:30 InnoDB: Started; log sequence number 0 44233

mysqld: Too many arguments (first extra is 'start').

Use --verbose --help to get a list of available options

110630 0:18:30 [ERROR] Aborting

110630 0:18:30 InnoDB: Starting shutdown...

110630 0:18:35 InnoDB: Shutdown completed; log sequence number 0 44233

110630 0:18:35 [Note] mysqld: Shutdown complete

How can this error be resolved?

解决方案

I did experiments and finally solve it with these commands

sudo chown mysql:root /var/lib/mysql/ -R

sudo chmod g+rw /var/lib/mysql/ -R

sudo /usr/sbin/mysqld --skip-grant &

It get running...... Hurraaahhhhhhhhhh!!!!!!!!!!!!