English 中文(简体)
MySQL在CentOS 5.5和“ERROR 2002”赢得了一定开端。
原标题:MySQL won t start in CentOS 5.5 and the "ERROR 2002"

I would like to ask a help for the problem I encountered. My mysql server suddenly stopped after I install php-soap. I don t know why it get stopped actually...

既然我停下来,我就试图通过打字线开始:

# /etc/init.d/mysqld start

之后,我收到以下信息:

MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

开始我方言似乎失败了。 页: 1 我曾多次尝试,并得出这一结果。 我检查了我的原.,这里是我所说的话。

======================================================================================================================================================================================================================================================= MYSQL LOG====

120511 21:34:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120511 21:34:43 [ERROR] Error message file  /usr/share/mysql/english/errmsg.sys  had only 481 error messages,
but it should contain at least 641 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
120511 21:34:43 [ERROR] Can t open the mysql.plugin table. Please run mysql_upgrade to create it.
120511 21:34:43  InnoDB: Initializing buffer pool, size = 8.0M
120511 21:34:44  InnoDB: Completed initialization of buffer pool
120511 21:34:44  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call:  open .
InnoDB: Cannot continue operation.
120511 21:34:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

www.un.org/spanish/ecosoc 其他信息:

OS: CentOS 5.5 64bit

<>Mysql edition: 由于我的服务器上出现这一错误,我无法拿到我的服务器上安装的我的仪表。

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

有些人能够帮助我解决这一问题?

谢谢你。

最佳回答

looks like your installation of mysql is not corrupt with /usr/share/mysql/english/errmsg.sys having been modified to contain less than the number of entries needed.

i would get the installation/src files for mysql for your centos box again. Untar it and locate the file errmsg.sys from sql/share/english, copy it to /usr/share/mysql/english/errmsg.sys and restart your mysqld. Another option is just to reinstall mysql from centos repo, after backing up your dbs to make sure they don t get blown away and to have a copy/backup of it.

我也想到的是,对护堤如动物档案做了哪些改动。

问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签