错误2002(HY000):无法通过套接字’/var/run/mysqld/mysqld.sock’(2)连接到本地MySQL服务器
我尝试了在互联网上找到的所有内容,但是无法解决在Ubuntu 11.04上出现的问题。
我尝试了这些事情:
sudo /usr/sbin/mysqld start
service mysqld start
ps ax | grep mysqld
3419 pts/0 S+ 0:00 grep --color=auto mysqld
/var/run/mysqld/mysqld.sock
mysql
tasksel
与mysqld -P 3305它一起运行时会产生错误
mysqld -P 3305
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
这是mysql错误日志
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
如何解决此错误?
我做了实验,最后用这些命令解决了
sudo chown mysql:root /var/lib/mysql/ -R sudo chmod g+rw /var/lib/mysql/ -R sudo /usr/sbin/mysqld --skip-grant &
它开始运行了……Hurraaahhhhhhhhh !!!!!!!!!!!!